Solved

How to fix Can't make a Sales Order because it has no Quantity Balance but the inventory have items?

  • 4 August 2022
  • 7 replies
  • 368 views
A
Rank
Userlevel 3
Badge

Hi 

 

Can you help me how to fix this issue. I want to create a Sales Order but I have a problem, when I’m doing SO I found out that I have no Inventory Balance but when I checked the items are there. What should I do?

 

This is the Sales Order (Inventory ID - 00002647)

 

This is the Inventory Balance

 

I’ve already checked in Recalculate Inventory (IN505000) but it nothing happen

 

 

Thanks

icon

Best answer by acumaticapm182 8 August 2022, 03:00

View original

7 replies

Laura02
Rank
Userlevel 7
Badge +14

Hello, Could the quantity on hand be used on a different order? 

It may be helpful for us to see the Inventory Balance report with Warehouse Location details and Allocation Details. It may be helpful to see the Availability Calculation rule.

It may be helpful for us to see Warehouse Locations configurations. Thank you!

 

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
A
Rank
Userlevel 3
Badge

Hi Laura

 

When I checked in Availability Calculation rule, I see that the other settings is not check and it’s working, the available items are there but when I go to Sales Order I see a problem. When I released this SO and make shipment, I encountered an error like this:

 

 

 

 

 

What should I do next?

 

Thanks

Naveen Boga
Rank
Userlevel 7
Badge +17

Hi, @acumaticapm182  As per the above screenshot showing Available for Shipping is 0.00.

To create the shipment, Acumatica will not consider the Available field and it considers the Available for Shipping.

As indicated by Laura above, have you checked the Include in Qty Available and Sales Allowed checkboxes at Warehouses screen for the Location?

And, after creating the Inventory Receipt have you RELEASED it?

Naveen B
A
Rank
Userlevel 3
Badge

Hi @Naveen Boga Yes the PO and Purchase receipt has been released and there are conflict in sub-items.. I already solved this issue by deleting again the line item then go to ADD ITEMS button and select  what sub items are available on your inventory

Like this:

 

K
Rank

Hi @acumaticapm182,

Please check the "Inventory Allocation Details" Inqiry

Inventory → Inquiries → Inventory Allocation Details

It may provide you some directions on where the particular inventory is blocked and we can take corrective steps.

 

Thank you!
Laura02
Rank
Userlevel 7
Badge +14

Hello @acumaticapm182 ,

Are you saying you solved the problem and the answer is, the sub-items have negative quantity on hand?

 

Thank you.

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
A
Rank
Userlevel 3
Badge

Hi @laura01 , Yes I’ve already solved this issue and I found out when I checked in the Purchase Order and what sub items in inventory ID and as you can see there are two sub items. The sub-item that we order is the second one (POWDR-000-TUR-25KGS-BAG) not the (POWDR-000-TUR-20KGS-BAG)

 

Purchase Order (PO301000)

 

Sales Order (SO301000)

 

Thanks,

Reply


Terms & ConditionsCookie settings
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 — 2023  Acumatica, Inc. All rights reserved