What is the most efficient way of satisfying customer orders when you dont have enough inventory ?

  • 27 January 2021
  • 7 replies
  • 137 views

We are trying to work out how to automate the allocation of stock to orders which cannot be fully completed.

There is no process to automatically “allocate” stock to orders.  It would be great if there was.

Due to stock shortages and the need to keep customers happy our client has to manually allocate stock to orders which is very time consuming.  

Some customers end up getting 10% of the order, some all of it if it is a very large order; there are many factors that come into play.

 

Thanks

 


7 replies

Badge

@jmorgan  I think what you want to do is kind like order fulfillment or ODM. I don’t think Acumatica has this functions. Acumatica even can not set priority for customers. You can lookup add-ons, customization project or pull out data to calculate base on your rules. 

Badge

Replan Back Orders is an existing feature in Acumaitca, but it does not work for when you have the Require Stock Allocation option enabled on an order type and does not handle customer/order priority. This was a major shortfall we had to workaround.

My company worked with our VAR to design a customization for this. The customization allows us to allocate/deallocate product in a bulk process from one screen. Filters can be modified on the fly to target various scenarios. Customers have a default priority level for all created orders and individual sales orders can have this overridden to a specified value. There’s always additional stuff we want to add and tweak, but it’s been exceptionally useful in managing product allocations without clicking into the allocations screen for each SOLine we want to alter the allocations on.

 

Hi Neil, thank you.  This was useful.  I think it needs to be added to the ideas page.

 

Userlevel 5
Badge +3

@jmorgan one of my first Acumatica customization (circa 2010-2011, Acumatica 2.2 -- a long time ago!) was a dynamic stock allocation mass-processing screen. The stock allocation feature was actually added to the distribution module by Acumatica following a request made by our customer, and my responsibility was to implement the mass processing screen.

The customer was a distributor of board game and kids toys and would take orders for the holiday season months in advance, without actually knowing what would be delivered or what would be the most in-demand items. If a major publication suddenly recommended a game every parent would like to buy one, and stores would fight for allocation. 

Through the custom mass processing allocation screen, they were able to allocate inventory proportionally, ensuring fair allocation to all the retailers. The screen included a filter by customer customer class, ship date and order priority so it was also possible to go very granular -- let’s say you have an agreement with a specific retailer that they go first, you could run the process first for all the locations of a given retailer, then do another round of allocation with the remaining inventory.

Although some of the logic is highly specific to the customer I was working with back then I think the underlying idea applies to other businesses. I tried to revive this project a few years ago while I was at Acumatica Labs but other projects took priority. If you or someone on your team has Acumatica dev skills I’ll be happy to share what I have...

 

Hi Gabriel, that is very useful and exactly the thing we need.  I hope to get back to you.

 

James

Userlevel 1

Replan Back Orders is an existing feature in Acumaitca, but it does not work for when you have the Require Stock Allocation option enabled on an order type and does not handle customer/order priority. This was a major shortfall we had to workaround.

My company worked with our VAR to design a customization for this. The customization allows us to allocate/deallocate product in a bulk process from one screen. Filters can be modified on the fly to target various scenarios. Customers have a default priority level for all created orders and individual sales orders can have this overridden to a specified value. There’s always additional stuff we want to add and tweak, but it’s been exceptionally useful in managing product allocations without clicking into the allocations screen for each SOLine we want to alter the allocations on.

 

Very smart. Very useful. The question now is how to get/buy your customization? Any suggestions?

Userlevel 2

Hello,

You can use this solution described in knowledge base: 

 Optionally, in the SQL view you can set an order by clause, to sort the customer orders after priority, delivery date or some custom attributes.

This is an old workaround for previous versions of Acumatica and the process of allocation could be started automatically only by scheduler, but now, in the latest versions it can be adjusted to run on a business event, after record inserted , just after a new PO Receipt is recorded in the system. In this way, after a new PO Receipt is released, the system will allocate automatically  the products to the sales orders  in a predetermined  order. 

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