Hi All,
I have been having this weird issue from time to time in some of my sales orders. I traced the entire sales cycle and documented the case. The case is as follows:
Our warehouse people were taking inventory of the current stock, they found out that item number 30220300 had a discrepancy of 1 bag between the on ground count and system's on-hand inventory report.
We started tracing the transactions of this item until we reached this sales order (MNGD-002020). The sales order had a sales line of item 30220300 with quantity 2. The packing slip created for this sales order also had quantity 2 for this item. The sales order was invoiced and the invoice lines also had quantity 2 of this item. The invoiced amount was also calculated correctly. However, when we looked at the Lot Transactions from the invoice lines it showed quantity 1 (see image below).
Invoice Line:
Inventory Lot Transactions:
How can this happen? I revised with the users they did not do anything out of the ordinary.
The only thing I noticed is that in the sales lines the quantity is 2 but the net amount calculated for the line is for only 1 (see image below).
We have faced this issue a couple of times before. We solved it by crediting the invoice, which surprisingly credits all financial quantities by quantity mentioned in invoice (in this case it will be 2) and physical quantities by which mentioned in inventory transactions (in this case it will be 1).
Kindly advise on what causes this issue, as we need to address the root cause.
