Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

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
Powered by Mantis Bugtracker