Project:
| View Revisions: Issue #31917 | [ Back to Issue ] | ||
| Summary | 0031917: Account Payables account used instead of Vendor Prepayment account in case of rounding differences caused by a prepayment | ||
| Revision | 2016-01-15 15:00 by psanjuan | ||
| Steps To Reproduce | 0. Check conversion rate between EUR and USD. For the test below, conversion rates used are: 01-01-2015 to 31-12-2016 EUR to USD 1.5 1. Define Prepayment account for Bebidas Alegres business partner in Vendor Accounting tab, correct ledger account is: 1410 Vendor Prepayment. 2. Register Purchase Order dated on todays's date (14-01-2016) for "F&B España" org and "Bebidas Alegres" BP. Product "Cerveza Ale 0.5L". Ordered Quantity = 10. Book the order. 3. Register a Payment dated on todays's date (14-01-2016), related to the order by prepaying it completely. Prepayment Amount = 16.46 €. Amount converted to USD = 24.69 usd (exchange rate used 1.5 EUR to USD) 4. Register a Purchase Invoice for "F&B España" org and "Bebidas Alegres" BP, dated on todays's date (14-01-2016). Run "Create lines from" and select the order. Edit Invoiced Quantity field and change it to 1. Complete and Post the Invoice. 5. Verify following accounting entries are shown: F&B España EURO 1.36 € (6000) Compra Mercaderias DEBIT 0.29 € (47200) HP IVA soportado DEBIT 1.65 € (40700) Anticipo a proveedores CREDIT F&B International Group DOLLAR 2.04 usd (1.36 * 1.5) (5360) Product Expense DEBIT 0.44 usd (0.29 * 1.5) (7410) Tax Expense DEBIT 2.48 usd (1.65 * 1.5) (1410) Vendor Prepayment CREDIT 6. Create another invoice for the same order, change qty to 1 and post it. 7. Verify following accounting entries are shown: F&B España EURO 1.36 € (6000) Compra Mercaderias DEBIT 0.29 € (47200) HP IVA soportado DEBIT 1.65 € (40700) Anticipo a proveedores CREDIT F&B International Group DOLLAR 2.04 usd (1.36 * 1.5) (5360) Product Expense DEBIT 0.44 usd (0.29 * 1.5) (7410) Tax Expense DEBIT 2.48 usd (1.65 * 1.5) (1410) Vendor Prepayment CREDIT 8. Create another invoice for the same order, change qty to 5 and post it. 9. Verify following accounting entries are shown: F&B España EURO 6.80 € (6000) Compra Mercaderias DEBIT 1.43 € (47200) HP IVA soportado DEBIT 8.23 € (40700) Anticipo a proveedores CREDIT F&B International Group DOLLAR 10.20 usd (6.80 * 1.5) (5360) Product Expense DEBIT 2.15 usd (1.43 * 1.5) (7410) Tax Expense DEBIT 12.35 usd (8.23 * 1.5) (1410) Vendor Prepayment CREDIT 10. Create another invoice for the same order, to invoice remaining qty that is 3 units. 11. Verify following accounting entries are shown: F&B España EURO 4.08 € (6000) Compra Mercaderias DEBIT 0.86 € (47200) HP IVA soportado DEBIT 4.93 € (40700) Anticipo a proveedores CREDIT 0.01 € (40000) Proveedores CREDIT F&B International Group DOLLAR 6.12 usd (4.08 * 1.5) (5360) Product Expense DEBIT 1.29 usd (0.86 * 1.5) (7410) Tax Expense DEBIT 0.01 USD (8255) Currency Balancing DEBIT 7.40 usd (4.93 * 1.5) (1410) Vendor Prepayment CREDIT 0.02 usd (0.01 * 1.5) (2110) Account Payables CREDIT |
||
| Revision | 2016-01-15 14:53 by psanjuan | ||
| Steps To Reproduce | tbd | ||
| Copyright © 2000 - 2009 MantisBT Group |
 |