Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0031917 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2016-01-15 14:53 | 2016-01-15 15:00 | |||||||
| Reporter | psanjuan | View Status | public | |||||||||
| Assigned To | Triage Omni OMS | |||||||||||
| Priority | high | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.6 | |||||||
| OS Version | Ubuntu 8.04.1 | Database version | 11.1.0.6.0 | Ant version | 1.7.0 | |||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0031917: Account Payables account used instead of Vendor Prepayment account in case of rounding differences caused by a prepayment | |||||||||||
| Description | Account Payables account used instead of Vendor Prepayment account in case of rounding differences caused by a prepayment | |||||||||||
| 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 | |||||||||||
| Proposed Solution | Correct 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 | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |