Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031917Openbravo ERP09. Financial managementpublic2016-01-15 14:532016-01-15 15:00
Reporterpsanjuan 
Assigned ToTriage Omni OMS 
PriorityhighSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS20OS VersionUbuntu 8.04.1
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031917: Account Payables account used instead of Vendor Prepayment account in case of rounding differences caused by a prepayment
DescriptionAccount Payables account used instead of Vendor Prepayment account in case of rounding differences caused by a prepayment
Steps To Reproduce0. 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
Proposed SolutionCorrect accounting for the last invoice or the one causing rounding differences should be:

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 € (40700) Anticipo a 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) (1410) Vendor Prepayment CREDIT
Additional Information
TagsNo tags attached.
Relationships
related to defect 00318733.0PR16Q2 closed vmromanos Wrong multicurrency accounting entry when posting partial invoice related to a prepaid order 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-01-15 14:53psanjuanNew Issue
2016-01-15 14:53psanjuanAssigned To => Triage Finance
2016-01-15 14:53psanjuanModules => Core
2016-01-15 14:53psanjuanTriggers an Emergency Pack => No
2016-01-15 14:55psanjuanRelationship addedrelated to 0031873
2016-01-15 15:00psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=10660#r10660
2016-01-15 15:00psanjuanProposed Solution updated

There are no notes attached to this issue.