Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
eganjali
Level 1

POS multi store to single store, did not transfer inventory prior to upgrade

We had POS at multiple store locations before, but we have downsized to a single location prior to performing POS upgrade.  Before upgrading, we failed to perform store exchange to bring back inventory from the stores which no longer exist.  The new POS does not have an option to perform store exchange.

 

The current POS shows different numbers for "on hand" and "available" inventory count.  We tried to correct the discrepancy, but performing quantity adjustment would adjust both "on hand" and "available" at the same time so the difference would still exist.  Does anyone know how to correct available count only in POS?

 

Also, we see entries are automatically made from time to time to a PL account called "document_offset" in QB financial - making offsetting entries to inventory account.  These journal entries would show the old store names under "class" which are currently not used.   We understand that this "document_offset" account is used when quantity or cost is manually adjusted, but we suspect that these entries are automatically generated by POS/QB as we did not make any adjustment for the items recorded in this account.  Not certain, but perhaps it may be related to the issue mentioned above?

 

Does anyone have a suggestion as to how to go about with this issue?  We would like to be able to correctly account for our inventory and not see any journal entry made to the "document_offset" account.  

1 Comment 1
LeizylM
QuickBooks Team

POS multi store to single store, did not transfer inventory prior to upgrade

Good day, eganjali. 

 

Thank you for sharing the complete details of your concern. I have here some information about changing store type in Point of Sale Multi-store. 

 

Before changing your store type, there's a limitation that we need to know. In the unique inventory items, that store will be lost if steps are not taken first when migrating them to Headquarters inventory.

 

We can do the inventory adjustment or total value of your products to correct the available count. These adjustments will automatically sync on your QuickBooks POS. 

 

To correct the account of your inventory, you can follow the steps provided in this article to resolve the problem: No adjustment shows on the QuickBooks balance sheet after inventory is deleted in Point of Sale.

 

I've got some resources that you might need for additional  information about financial exchange and how it is set up:

 

 

If you need more help in adjusting your inventory, please let us know. We'll be around. Take care.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us