Allocated Quantity

[jonbarr]

GP 8.0
Table IV00102 has a field called ATYALLOC for Quantity Allocated. For some Items I am getting a bigger number here than what shows in Item Allocation Enquiry window.
I have tried all of the Module Restrictions and Site variables, but cannot track where the extra orders are coming from. Is there any way that I can drill down on the ATYALLOC field to find out where it is getting its total from ? I suspect there is something from history that is not showing in Open and Work fields.

 

[jazgeek]

gp inventory allocation and on order quantity are notorious for going out of whack. Run an inventory reconcile on the affected item #'s and it'll fix it.



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

jaz

 

[BobSchleicher]

The IV00102 table will show an allocation when a sales order line has a qty in 'Qty to Invoice' but won't allocate in the IV00112 (BIN QTY MASTER TABLE) until you show a qty in the 'Qty Fulfilled' field on a sales order.

I explained the above because if go to 'Inquiry-Inventory-Item Allocation' it won't show anything being allocated if you only show a qty in the 'Qty to Invoice' field on a sales order.

Of course the IV00102 will have other reason to have someting allocated but I am only giving a sales order scenario.

BobSchleicher