Incorrect Item Ledger Entry and Value Entry

jdelfraisse

We have submitted the problem to our partner, I was curious of the ideas from other users on how to fix this. We can't determined what caused the problem and can't find any other examples of it happening before. We have a sales invoice that was posted. The item in question was sold for 1 CASE (25 each). The problem is the Item Ledger Entry and Value Entry both have the quantity at 1 each instead of 25 each. The sale amount shows the 1 case price, the cost shows the 1 each cost. This is a problem with quantity on hand as well as the value of the item. Any suggestions on the entries to fix this problem? Bottom line, the customer was charged the correct amount, it just didn't come out of ledger or value correctly.

Thanks,

Jonathan

David_Singleton

jdelfraisse wrote:

We have submitted the problem to our partner, I was curious of the ideas from other users on how to fix this. We can't determined what caused the problem and can't find any other examples of it happening before. We have a sales invoice that was posted. The item in question was sold for 1 CASE (25 each). The problem is the Item Ledger Entry and Value Entry both have the quantity at 1 each instead of 25 each. The sale amount shows the 1 case price, the cost shows the 1 each cost. This is a problem with quantity on hand as well as the value of the item. Any suggestions on the entries to fix this problem? Bottom line, the customer was charged the correct amount, it just didn't come out of ledger or value correctly.

Thanks,

Jonathan

If possible, best is to use journals to zero the item then block it, create a new one and put the correct entries in the new item.

These are generally one offs, and the cost to track them down is far more than the cost of fixing it and moving on. Unless of course it starts to happen again.

ara3n

I suggest to unapply the Item Ledger entry. Create a credit memo and apply it to the sale with qty of 1 and same sales amount.

Then create the sales order with correct qty (case) and apply it to the entry that the sale had happened.

kitik

My guess is that:
* Quantity per unit of measure of the CASE was set to 1 instead of 25 at the moment of creating the line.
* You had a sales price created for the CASE, so the price was correct.

Salut!

jdelfraisse

The problem was the Quantity(Base) was not the correct number in the sales invoice when it was processed. We are not sure how this happened and think it was a one-time thing. Our solution to fix it was to "Copy Document" to a sales credit which copied the bad Quantity(Base). Post that and then do a new sales invoice. The Quantity(Base) was correct and it processed correctly. Thank you for all of your help in this.