Sage 300 - Macro OE

[PJ71]

Does anyone have a macro that can be used to allocate shipment quantity by item on several active orders to share available stock across the orders.

 

[DjangMan]

Are you looking to buy one or do you need to write one?

What sort of algorithm do you want to use to spread the stock?

 

[PJ71]

Depending on the cost possibly to buy one. But may have to write one. The macro would need to bring up all the orders with a specific item where their is insufficient stock to fill all the orders and the user will manually spread the stock across the outstanding orders in quantity shipped and then produce invoices for all orders after the allocation.

 

[DjangMan]

Are you needing to process multiple items in one pass or it will always be for a single item?

 

[PJ71]

There will be multiple items on each pass. Where there is sufficient stock all items will be shipped. But allocation only on items with insufficient stock.

 

[DjangMan]

What version of Accpac are you running?

 

[PJ71]

Version 6.0A

 

[DjangMan]

There is this product that might do what you're looking for:

http://www.indussys.com/solutions/products/BackorderSystem/index.asp

Also - depending on your budget, most warehouse management systems will have functionality for what you're looking for.

Otherwise you're in for some writing to do the stock allocation. Creating the order via a macro isn't that hard. You can record the steps and then clean up the macro that is started for you. The code to do all of that stock allocation is where most of your effort is going to go.