Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
We have QB Enterprise with EIR. The initial bookkeepers installed QB Enterprise with EIR turned on. Then they started selling products that were not in inventory. This created negative inventory and we are trying to fix it. However, EIR has become spasmotic. We following the perfect workflow - create purchase orders, receive items, create the bill, then pay the bill. EIR sometimes generates and extra bill. For instance, we are working retroactively in May 2022, we follow the above work flow for inventory and Inventory Offset was fine, then we noticed that there is an extra bill created in 12/2022 that then creates negative amounts in the Inventory Offset Account and throughs more out of balance.
What to do? If we wanted to start over, what is the best method for exporting data?
Hello @Neural Bookkeeping,
Thank you for reaching out to us here in the Community space. I'm here to lend a hand with fixing the negative inventory in QuickBooks Desktop.
Enhanced Inventory Receiving (EIR) creates a new process for receiving and paying Items when enabled in the Enterprise version. You cannot turn off EIR once turned on.
There are changes to the process as well as new restrictions with EIR. For more details, I recommend checking out this article: Turn on Enhanced Inventory Receiving (EIR).
We advise Enterprise users to secure a backup copy before using the feature. This way, you can restore and revert to the previous method if it doesn't work with your business process.
If you don't have a backup copy, your next option is to create a new company file. You can export and import data but please keep in mind there are limitations to the information you can share.
Also, did you know you can schedule automatic backups to secure a copy of your company file? I've included a link you can use as a reference on the process instead of manually backing up your company file: Back up your QuickBooks Desktop company file.
Keep in touch here in the thread if you need more assistance fixing your inventory in QuickBooks. We're always available to help you out. Have a great day.
Thank you, but this is not helpful
Thanks for getting back here, @Neural Bookkeeping. I want to ensure this will be taken care of.
Another way in exporting the data from your QuickBooks Desktop (QBDT) account is by using a 3rd party application. To look for one, you can head to our Apps for QuickBooks Desktop page. From there, simply enter the keywords of the feature you need. A list of compatible and supported apps will be displayed.
Once you successfully exported the data you can now follow the steps in this article to import them on a new company file.
I've also added this helpful resource that you can access at any time if you need additional guides in performing QuickBooks tasks: QBDT Help articles.
If you have any other concerns about managing your books, please don't hesitate to post again here. I'd be happy to lend you a hand. Have a good one and keep safe always.
We contacted QuickBooks Support, and the engineers told us to create the PO then Bill the company, AND then afterward link the Item Receipt/Bill to the PO. In the process, creating a Bill first seems to spawn an Item Receipt automatically. I understand that this is a hack to overcome the problems with EIR - is that correct? Or is this process (PO - Bill - Item Receipt) the new workflow for EIR?
Also, it seems that QuickBooks is shipping QB Enterprise EIR turned on, can it then be turned off if nothing has been entered?
Can the sale of negative inventory corrupt the pointers for the QB database?
Thanks
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here