Problem with unit of measure in item ledger entry

Djou2424Djou2424 Member Posts: 76
Hi,

One of our client is experiencing some weird problems with the qty. per unit of measure in the item ledger entry.

They have an item X with a base unit of measure called EACH, qty of 1, and BOX, qty of 10
The purchase UoM is set to BOX

They created a PO for 5 boxes. Setup is done properly.
They received it, it's not invoiced yet.
The item ledger entry shows a quantity of 5, invoiced 0, Remaining 5 and qty. per Unit of Measure 10
The PO shows a quantity of 5, quantity received 5, qty. to invoice 5.
The Qty per Unit of Measure on the PO is 10, Unit of Measure Code is BOX
Quantity (Base) us 50, but the Outstanding Qty. (Base) is 45, instead of 5
The Posted Receipt shows a quantity of 5, Unit of Measure BOX, Qty. per Unit of Measure 10, Quantity (base) 5
Why is the quantity (base) not calculated properly.

It's not happening with every item and not every PO.
Our guess is it is caused by a user manipulation, they thing it's a software issue.
We have been unable to reproduce the problem so far.

If we post the invoice, we then get an invoice for a quantity of 50, but on the PO (still open since other items have not been shipped and invoiced yet) now shows a Qty. Rcd. Not Invoiced of -45

Any idea?

-Julie

Comments

Sign In or Register to comment.