Have a problem in that in_qty_ord has a negative quanity for an item.
I cannot figure out why it is negative.
From looking at the definition, it says: The quantity on all open PO's and released W/O's for this
item/site.
So if I do a query on pod_det where pod_part = "098" abnd pod_site = "98" and do
total of (pod_qty_ord * pod_um_conv) should I not get the same value as in_qty_ord.
Can somebody please assist on how this can get negative and I can check to see if it fits my situation.
Thanks in advance.
I cannot figure out why it is negative.
From looking at the definition, it says: The quantity on all open PO's and released W/O's for this
item/site.
So if I do a query on pod_det where pod_part = "098" abnd pod_site = "98" and do
total of (pod_qty_ord * pod_um_conv) should I not get the same value as in_qty_ord.
Can somebody please assist on how this can get negative and I can check to see if it fits my situation.
Thanks in advance.