Sales Orders & Allocated Qty

[PTina]

One of my users has come across an issue and I'm not sure if this is a bug.

She enters an order with some items back ordered. Nothing is done with the order for a few days. Then she may need to change the quantities invoiced or backordered and this is where the problem occurs.

Original Order
Qty to Order 2000
Qty to invoice 800
Qty to Back Order 1200

Qty Available 1000

Modified Order
Qty to Order 2000
Qty to invoice 1000
Qty to Back Order 1000

Qty Available is now only 200.

It still sees the original allocation of 800, for the same order and line item. Even if I delete the line item Qty Available is not updated correctly. The only way to correct is to run Inventory Reconcile.

We used to just key the invoices and had no problem changing around the qtys on the invoice document. We just started by keying the Sales Order first and we're having this problem.

We use multi-bin and are lot tracking some items.
This problem occurs for multiple orders keyed so far.
We're on GP Enterprise ver 8 sp 2

Any ideas?

 

[jazgeek]

seen this type of error (bug) in every version since 3.15

utilities>inventory>reconcile

seems to be the only way to fix it.

-----------
and they wonder why they call it Great Pains!

jaz

 

[Dukester0122]

Try to check the earlier threads because I thought I've seen the same problem before.

 

[markajem]

Or, do what I did. I wrote my own SQL to calculate the allocated. We don't even look at GP's allocation because of the problems and because of the fact that if a sales order contains a BOM the component items are not allocated until the BOM workorder is started. Our problem is we import and need 90 day lead time. So our purchasing department needs to know what is allocated the moment the sales order hits the open order file. Not wait until the work order is started. The workorder may not be started until 3 days prior to the order being shipped therefore the order could be open in our books for 120 days. Purchasing needs to see that allocation immediately. So now we just refer to Crystal reports created by me with the newly created allocations from my script.

 

[PTina]

Thanks for your input.

How can this bug not have been corrected since 3.15? This is just unbelievable. I guess I will now have to decide whether it makes sense for us to use the Sales Order document because I cannot have the user doing inventory reconcile every few orders.