Solved

Cannot transfer items even there is sufficient available/ onhand qty. It validates against a hard qty

  • 29 November 2023
  • 2 replies
  • 61 views

Hi,

 

We have an item that shows that there are 73 units available and on-hand qty = 73 as well for a particular lot (inventory summary)

 

However, when we are trying to do a transfer, and it won't allow us to transfer our more than 27 items.

Ge the following error:

 

IN Error: The document cannot be saved because the quantity of the MAIN-LBL-SANSBURY-TU-WCWEF-R item with the 000 PAR SAI T1810 ARLO CHARCL lot number is not sufficient for shipping in the D2 warehouse. To be able to save the document with the On Hold status, clear the Allocate Items in Documents on Hold check box on the General tab of the Inventory Preferences (IN101000) form.

 

We could see that in the PX.Objects.IN.INSiteLotSerial, the hard available quantity for this material is 27. Where is this value set from? and this is where the validation gets triggered.

 

What is the difference between hard availability and availability?

 

Does anyone know what the issue here?

 

Thank you!

icon

Best answer by Laura02 29 November 2023, 14:29

View original

2 replies

Badge +18

Hello @charithma13 ,

From the Acumatica Help, Qty on Hard Demand = Qty Allocated on Sales Order + Qty Shipped on SO + Qty Backordered on SO:

Depending on an item’s Availability Calculation rules, Qty Available may also consider items in various stages of production, Items in Kit Assemblies, items in Transit, Items on Receipts, PO’s, etc.

Availability Calculation Rules

Laura

Thank you very much! @Laura02 

Reply


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 — 2024  Acumatica, Inc. All rights reserved