Someone brought to my attention today that our avg unit cost is continually inflating on our stock items. I looked in to it and found a huge problem in OE when issuing CN against specific Invoices.
Example: If an Invoice is for QTY 100 of an item at a unit cost of $10 each, the extended cost calculates at $1,000. When we issue a credit against the Invoice and change the quantity to 1, the selling price, extended selling price and unit cost calculate correctly, however the extended cost remains at $1,000 instead of adjusting to $10. This single transaction inflates the total cost of the item by $990 and equally deflates the cost of goods sold. Our inventory value keeps going up while our gross profit looks better than what it really is. Please advise how I can stop this.
I tried a few work arounds but nothing will give us the correct cost calculation when issuing Credit Notes. If you delete all the line items and add a line item, the extended cost calculates at zero. If we issue a Credit without using an Invoice number at all it calculates the extended cost at zero. Even if we calculate the cost manually, we can't enter it in because the field is greyed out.
I checked some Credit Notes from before OE 8.1D was installed and this problem was not occurring then. The cost was calculating correctly on Credit Notes before the upgrade.
Please advise a solution to this!
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario
Previous Topic
Index