Project:
View Revisions: Issue #42092 | [ Back to Issue ] | ||
Summary | 0042092: Unbalance posting when adjusting a return receipt | ||
Revision | 2019-10-29 10:46 by Sandrahuguet | ||
Steps To Reproduce | 1. Create a new product Test in F&B España. Purchase Price 20, Sales Price 25. Navigate to Accounting tab and set Invoice Price Variance to 99904 - Diferencias entre el coste del producto y el precio de la fra 2. Go to General Ledger Configuration. Select "F&B España, S.A. US/A/Euro" ledger and ensure that in Active Tables the tables related to Receipts, Matched Invoices and Cost Adjustments are active. 3. Create a new Purchase Order (PO01): - Product Test, Quantity 10units, Price 10EUR - Create the Receipt and the Invoice. 5. Create a new Purchase Order (PO02): - Product Test, Quantity 10units, Price 20EUR - Create the Receipt and the Invoice. 6. Create a Return to Vendor. - Select the line related to PO02 order and return it completely. - Set the price to 20EUR - Create the Return to Vendor Receipt and the negative Purchase Invoice. 7. Create a Sales Order - Product Test, Quantity 5 units, Price 25EUR. - Create the Shipment and Invoice. 8. Ensure that the Costing Background process is executed and check that: - The average cost after PO02 is 15EUR/unit - The return receipt is valued as 150EUR - The shipment is valued at 75EUR 9. Run the Trial Balance for: - Organization: F&B España - Ledger: "F&B España, S.A. US/A/Euro". - Product: Test - Dates including the documents created. 10 Check in the Trial Balance that: - Inventory balance is 75EUR (5 units in stock by 15EUR/unit) - Balance of COGS account is 75EUR - Balance of Invoice Price Difference account is -50EUR (caused by the return) 11. Create a manual cost adjustment in transaction related to order PO01. - Amount 200EUR - Incremental NO 12. Go to product and check: - Average costs are 20EUR/Unit. - Transactions costs are changed: Receipts and return 200EUR shipment 100EUR. 13. Ensure that the cost adjustment is Posted 14. Rerun Trial Balance and check: - Inventory balance is 100EUR (5 units by 20EUR/Unit) -> CORRECT - Balance of COGS amount is 100EUR (the new total cost of the shipment) -> CORRECT - Balance of Invoice Price Difference -50EUR. -> WRONG - Balance of Warehouse Differences -50EUR -> WRONG We expect to have: Warehouse Differences 0EUR Invoice Price difference: - PO01 should have generated a 100EUR balance as the receipt now is valued at 200EUR and the invoice is for 100EUR. - Return REceipt should have settled the -50EUR balance as now is valued at 200EUR the same as the invoice. 15. Check the accounting of the Cost Adjustment: - The adjustment of the PO01 line (100EUR) is done on Warehouse Differences instead of Price Differences - The adjustment of the return (50EUR) is done on Warehouse Differences instead of Price Differences - The adjustment of the shipment (25EUR) is done on the COGS account which is correct. |
||
Revision | 2019-10-24 23:17 by Sandrahuguet | ||
Steps To Reproduce | 1. Create a new product Test in F&B España. Purchase Price 20, Sales Price 25. 2. Go to General Ledger Configuration. Select "F&B España, S.A. US/A/Euro" ledger and ensure that in Active Tables the tables related to Receipts, Matched Invoices and Cost Adjustments are active. 3. Create a new Purchase Order (PO01): - Product Test, Quantity 10units, Price 10EUR - Create the Receipt and the Invoice. 5. Create a new Purchase Order (PO02): - Product Test, Quantity 10units, Price 20EUR - Create the Receipt and the Invoice. 6. Create a Return to Vendor. - Select the line related to PO02 order and return it completely. - Set the price to 20EUR - Create the Return to Vendor Receipt and the negative Purchase Invoice. 7. Create a Sales Order - Product Test, Quantity 5 units, Price 25EUR. - Create the Shipment and Invoice. 8. Ensure that the Costing Background process is executed and check that: - The average cost after PO02 is 15EUR/unit - The return receipt is valued as 150EUR - The shipment is valued at 75EUR 9. Run the Trial Balance for: - Organization: F&B España - Ledger: "F&B España, S.A. US/A/Euro". - Product: Test - Dates including the documents created. 10 Check in the Trial Balance that: - Inventory balance is 75EUR (5 units in stock by 15EUR/unit) - Balance of COGS account is 75EUR - Balance of Invoice Price Difference account is -50EUR (caused by the return) 11. Create a manual cost adjustment in transaction related to order PO01. - Amount 200EUR - Incremental NO 12. Go to product and check: - Average costs are 20EUR/Unit. - Transactions costs are changed: Receipts and return 200EUR shipment 100EUR. 13. Ensure that the cost adjustment is Posted 14. Rerun Trial Balance and check: - Inventory balance is 100EUR (5 units by 20EUR/Unit) -> CORRECT - Balance of COGS amount is 100EUR (the new total cost of the shipment) -> CORRECT - Balance of Invoice Price Difference -50EUR. -> WRONG - Balance of Warehouse Differences -50EUR -> WRONG We expect to have: Warehouse Differences 0EUR Invoice Price difference: - PO01 should have generated a 100EUR balance as the receipt now is valued at 200EUR and the invoice is for 100EUR. - Return REceipt should have settled the -50EUR balance as now is valued at 200EUR the same as the invoice. 15. Check the accounting of the Cost Adjustment: - The adjustment of the PO01 line (100EUR) is done on Warehouse Differences instead of Price Differences - The adjustment of the return (50EUR) is done on Warehouse Differences instead of Price Differences - The adjustment of the shipment (25EUR) is done on the COGS account which is correct. |
Copyright © 2000 - 2009 MantisBT Group |