Forget to do Update IN make item still have On Hand without availability

  • 21 January 2022
  • 4 replies

Userlevel 1

My staff forgot to do Update IN during Shipment process then accounting continue to do invoicing make the item still have Qty On Hand.

Please advise how to create an Issues to make QOH zero without having ‘Available for Issue’.




Best answer by idrusm52 25 January 2022, 01:30

View original

4 replies

Userlevel 7
Badge +8

Hi @idrusm52 

When one processes the shipment and generates invoices, the Inventory document does get generated automatically. Please confirm the following:

  • Is the Inventory document details on Shipment tab of SO blank?
  • If not, the documents were created and probably were not released yet.
  • If IN documents were generated but not released, you may check if ‘Automatically Release IN documents’ option is checked on SO Preferences.



Hope this helps,


Userlevel 1

Hi @vkumar 

Thank you for your reply.

Yes, the Inventory document details on Shipment tab of SO blank.


Userlevel 5
Badge +2

@idrusm52 , when shipment is invoiced without the updating inventory (which is really the common process), inventory issue will be generated upon the release of invoice (and released if the Automatically Release IN documents’ is checked). This is a common process to adhere the revenue-COGS matching principle

In this case,  the Qty On Hand is present until invoice is released, but the *Available for Issue* qty should be decreased by the shipment amount (it happens after the shipment confirmation), Please check  the *Available for Issue* valu additionally. It is this qty rather than qty on hand which should matter from the inventory management perspective ( Qty On Hand is mainty used for accounting)

Userlevel 1

The reason of this issue is the invoice still not release, once it’s released the Issue automatic generated.

Case closed.


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved