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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0031917
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2016-01-15 14:532016-01-15 15:00
ReporterpsanjuanView Statuspublic 
Assigned ToTriage Omni OMS 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionUbuntu 8.04.1Database version11.1.0.6.0Ant version1.7.0
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0031917: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00318733.0PR16Q2 closedvmromanos Wrong multicurrency accounting entry when posting partial invoice related to a prepaid order 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2016-01-15 14:53 psanjuan New Issue
2016-01-15 14:53 psanjuan Assigned To => Triage Finance
2016-01-15 14:53 psanjuan Modules => Core
2016-01-15 14:53 psanjuan Triggers an Emergency Pack => No
2016-01-15 14:55 psanjuan Relationship added related to 0031873
2016-01-15 15:00 psanjuan Steps to Reproduce Updated View Revisions
2016-01-15 15:00 psanjuan Proposed Solution updated


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker