Hello All,
We are having an issue where Freight Charges on the Return Order PO were posted incorrectly and now our Inventory and GL are out of balance. We are wondering if anyone has any ideas on the cause and how we can fix this.
Example:
- PO for qty 2 (unit price = 90.11) + 4.25 Freight Charge - We received and invoiced this which made the Cost Amount in the posted transaction to be 184.47.
- We then created a Return PO for qty 2, but the vendor is NOT reimbursing us for the 4.25 freight charge.
- We posted the Product Receipt which had a SOLD cost amount of 184.47.
- We invoiced the product receipt, and on the invoice a positive freight charge was added for 4.25 so that we weren't "returning" the freight charge - Balancing the negative freight on the return.
Now when we run the inventory value report, with the Summary tab at the bottom, we see that our Inventory has a discrepancy of 4.25 to our Ledger.
Please see all relevant info below:
Charge Codes Setup:
Inventory Transactions:
Freight Charges on Return PO Invoice:
Accounting Distributions on Return PO Invoice:
Trial Balance:
Thanks so much!
Steven Rice
