Solved

Prepare Replenishments screen not showing a value for the Qty to Process column

  • 10 October 2023
  • 5 replies
  • 67 views
A
Rank
Userlevel 4
Badge

Hi,

 

A client has found that an item in the Prepare Replenishment query is showing no value for the Qty to Process screen, but it looks like it should be showing a value since a customer has ordered 2 of this item and the client only has 1 of these in stock.

 

Is this query result incorrect or can you see a reason why the Qty to Process column is set to 0?

 

Kind regards,

Andrew

 

icon

Best answer by Kandy Beatty 11 October 2023, 22:05

View original

5 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @AndrewA 

What is the replenishment method of that item? 
 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Kandy Beatty
Rank
Userlevel 7
Badge +16

HI @AndrewA 

Another thing to check is the Inventory Summary and see if there is possibly any in transit such as through a PO already. 

By default, it is the value calculated based on replenishment parameters specified for the item in the particular warehouse minus the quantity on supply.

Have you tried to recalculate the inventory to see if that changes it as well? Are there any open Receipts for that item that have not been posted?

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
A
Rank
Userlevel 4
Badge

Hi Kandy,

 

Thanks for your responses. The replenishment method is set to Min/Max, as shown in the first image below.

 

The second image is the Inventory Summary results. There is a value in the Purchase Orders column, so since there are open purchase orders for this item, does this mean it would not be included in the Qty to Process column calculation.

 

I can’t see any open Purchase Receipts for the supplier of this inventory item.

 

Let me know if you require any further information.

 

Kind regards,

Andrew

 

 

 

Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @AndrewA 

Yes, since there are existing purchase orders open for that item, it will not populate on the Prepare Replenishment. 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
A
Rank
Userlevel 4
Badge

Thanks so much Kandy!

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