Solved

Inventory Replenishment with Sales Orders On Hold

  • 7 October 2023
  • 3 replies
  • 91 views
D
Rank

We have an issue wherein we may enter part of a Sales Order, or the full order, and then place it on hold awaiting some further information. The Sales Order may be on hold for several days.  We are on 22R1 Build 22.119.0027

 

When you go to Prepare Replenishment, however, the replenishment calculation seems to include all orders, including those on hold, in the demand numbers.  This can cause inventory buyers to purchase items that may not be needed because we have changed the Sales Order lines or quantities before releasing it from On Hold status.

 

Is there a setting to have Replenishment ignore demand from On Hold Sales Order, much like the Inventory Availability Calculation Rules can be configured for various scenarios.  Alternately, it would be useful to have a “Draft” Sales Order Status where the order is not visible at all to other modules in the system until the Sales Order is released.

 

Has anyone else struggled with this scenario or had successful workarounds? Thanks in advance.

icon

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

View original
Engineering Solutions to Sealing Problems

3 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

HI @doldham96 

What is the replenishment method for the items?

 

Also, the orders on hold, are they allocated to the Sales Orders?

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*.
D
Rank

Thanks for replying! Here is the replenishment tab for the item. It is set to Min/Max method.

 

We do not stock this item typically. When we received a customer order, we entered it, but placed the order on hold while we were working on additional details with the customer. We only use SA order type, but in this case there was no stock on hand at the time the order was entered and placed on hold.

The purchasing team saw the item demand come up on their normal replenishment review and purchased the item, which the customer ultimately decided not to purchase. We typically put a customer order in the system and then place it on hold for review of price or other requirements.

Engineering Solutions to Sealing Problems
Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @doldham96 

I looked into this a bit more for you. A few things I found are:

  1. The SA order type does a hard demand for an item on the prepare replenishment. (I set up my item just as you described)
  1. I placed a Sales Order with the type SA and I had 0 in stock. My line is not allocated because there is none in stock.

 

  1. I went back and looked at the prepare replenishment screen and even though it does not suggest purchasing, it creates a Hard Demand. Is Acumatica creating a QTY to Process or is your team purchasing based off the hard demand?

 

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*.

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