Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029456Openbravo ERP03. Procurement managementpublic2015-03-25 13:082015-04-01 17:57
Reportermaite 
Assigned Tovmromanos 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q1.3Fixed in Version3.0PR15Q1.3 
Merge Request Status
Review Assigned Toumartirena
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2014-06-02
Regression introduced in release3.0PR14Q3
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/3e75e4d92c649e3293c1b6830771b0fba009b2da [^]
Triggers an Emergency PackNo
Summary0029456: Invoice's entry generated against Currency Balancing account instead of Vendor Prepayment account
DescriptionInvoice's entry generated against Currency Balancing account instead of Vendor Prepayment account
Steps To Reproduce1. Define Conversion Rate for today between MXN - EUR and MXN - USD
2. Create Price List in MXN currency, for purchase transactions
3. Define Financial Account payment to use different currencies
4. Register Purchase Order using MXN price list, add any line and process
5. Register multicurrency payment using Add Payment process from order's header
6. Register receipt using Pending Goods Receipt form
7. Register Purchase Invoice using Create Lines from process. Post invoice and realize that accounting entry is generated against Currency balancing account instead of Vendor Prepayment account
Proposed Solution
Additional Information
TagsApproved
Relationships
blocks defect 00294033.0PR15Q3 closed vmromanos Invoice's entry generated against Currency Balancing account instead of Vendor Prepayment account 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-03-30 13:33vmromanosTypedefect => backport
2015-03-30 13:33vmromanosTarget Version3.0PR15Q2 => 3.0PR15Q1.3
2015-03-31 12:36umartirenaFile Added: backport_29456.diff
2015-03-31 12:37umartirenaNote Added: 0076170
2015-03-31 12:51umartirenaNote Edited: 0076170bug_revision_view_page.php?bugnote_id=0076170#r8153
2015-04-01 10:58hgbotCheckin
2015-04-01 10:58hgbotNote Added: 0076298
2015-04-01 10:58hgbotStatusscheduled => resolved
2015-04-01 10:58hgbotResolutionopen => fixed
2015-04-01 10:58hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q1.3/rev/9f198e6affe383e140daf42849b13b3daa2a260a [^]
2015-04-01 10:58umartirenaReview Assigned To => umartirena
2015-04-01 10:58umartirenaStatusresolved => closed
2015-04-01 10:58umartirenaFixed in Version => 3.0PR15Q1.3
2015-04-01 10:59umartirenaFile Deleted: backport_29456.diff
2015-04-01 17:57dmitry_mezentsevTag Attached: Approved

Notes
(0076170)
umartirena   
2015-03-31 12:37   
(edited on: 2015-03-31 12:51)
Patch attached till Q1.3 backports repo is ready to push. Code Review + Testing already Done.
(0076298)
hgbot   
2015-04-01 10:58   
Repository: erp/backports/3.0PR15Q1.3
Changeset: 9f198e6affe383e140daf42849b13b3daa2a260a
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Mon Mar 30 15:20:12 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q1.3/rev/9f198e6affe383e140daf42849b13b3daa2a260a [^]

Fixed bug 29456: Invoice's entry Currency Balancing instead of Vendor Prepayment

The selectPrepayments method now searches by FIN_PAYMENT_SCHEDULEDETAIL.FIN_PAYMENT_SCHEDULE_ORDER instead of FIN_PAYMENT_SCHEDULEDETAIL.FIN_PAYMENT_SCHEDULE_INVOICE, because a prepayment is linked to an order.

---
M src/org/openbravo/erpCommon/ad_forms/DocInvoice_data.xsql
---