Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022881Openbravo ERP01. General setuppublic2013-01-24 11:162013-03-02 05:48
ReporterVictorVillar 
Assigned Tojecharri 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP22Fixed in Version 
Merge Request Status
Review Assigned ToVictorVillar
OBNetwork customerNo
Web browser
ModulesCore
Support ticket19061
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022881: Wrong definition of the alert 'Wrong Matched Invoice posting. Wrong currency conversion.'
DescriptionWrong definition of the alert 'Wrong Matched Invoice posting. Wrong currency conversion.'
Steps To ReproduceAs GRoup Admin role,
Go to Goods Receipt
    Create a new register for Alimentos y Supermercados
  Lines tab:
     Product: Vino Tinto
     Qty: 10
Complete it and post it

Go to Purchase Invoice
   Create a new register for Alimentos y Supermercados
Click on 'Create Lines From' and select the one proposed
Edit the line inserted, and change the qty to: 5
     Net unit price: 200
Complete it and post it.

Go to Product window || Accounting Tab:
    Fill the INvoice PRice Variance for both Accounting Schemas (US and EU)

Go to Matched invoice window
   Select the register associated for the Invoice and Receipt created before
Post the Matched Invoice document.

Launch the Alert Process background and check that always appears the matched invoice created before for 'Wrong Matched Invoice posting. Wrong currency conversion.' Alert.

The definition of the alert is wrong becasue it is not taking into account that you can invoice less qty than receipt and the sum of the credit/debit for the matched invoice in the fact acct always will be different as the sum of the credit/debit for the invoice qty.
Proposed SolutionIn the fact_acct table there is a qty column that it could be useful in order to be aware of these cases.
Additional Information
TagsNo tags attached.
Relationships
depends on defect 00216403.0MP16 closed gorkaion Wrong MatchInvoice posting when invoice is in foreign currency 
related to defect 00236173.0MP24 closed Sandrahuguet Static alert rule query definition needs to be corrected too 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-01-24 11:16VictorVillarNew Issue
2013-01-24 11:16VictorVillarAssigned To => dmiguelez
2013-01-24 11:16VictorVillarModules => Core
2013-01-24 11:16VictorVillarOBNetwork customer => No
2013-01-24 11:16VictorVillarSupport ticket => 19061
2013-01-24 11:16VictorVillarResolution time => 1361314800
2013-01-24 11:16VictorVillarTriggers an Emergency Pack => No
2013-01-24 11:17VictorVillarRelationship addeddepends on 0021640
2013-01-24 11:17VictorVillarIssue Monitored: networkb
2013-01-24 19:34jonalegriaesarteAssigned Todmiguelez => jonalegriaesarte
2013-01-24 19:34jonalegriaesarteTarget Version3.0MP20 => 3.0MP22
2013-02-13 18:28jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2013-02-20 15:59hgbotCheckin
2013-02-20 15:59hgbotNote Added: 0056639
2013-02-20 15:59hgbotStatusnew => resolved
2013-02-20 15:59hgbotResolutionopen => fixed
2013-02-20 15:59hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/65a7f0584de6687c82db760e5077569de7807517 [^]
2013-02-21 17:48hudsonbotCheckin
2013-02-21 17:48hudsonbotNote Added: 0056697
2013-02-26 10:04VictorVillarNote Added: 0056762
2013-02-26 23:13hgbotCheckin
2013-02-26 23:13hgbotNote Added: 0056793
2013-03-01 00:45VictorVillarReview Assigned To => VictorVillar
2013-03-01 00:45VictorVillarNote Added: 0056870
2013-03-01 00:45VictorVillarStatusresolved => closed
2013-03-02 05:48hudsonbotCheckin
2013-03-02 05:48hudsonbotNote Added: 0056919
2013-04-23 13:40maiteRelationship addedrelated to 0023617

Notes
(0056639)
hgbot   
2013-02-20 15:59   
Repository: erp/devel/pi
Changeset: 65a7f0584de6687c82db760e5077569de7807517
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Feb 20 15:57:22 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/65a7f0584de6687c82db760e5077569de7807517 [^]

Fixes issue 22881: Wrong definition of the alert
'Wrong Matched Invoice posting. Wrong currency conversion.'

---
M referencedata/sampledata/F_B_International_Group.xml
---
(0056697)
hudsonbot   
2013-02-21 17:48   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/2add4de9509d [^]

Maturity status: Test
(0056762)
VictorVillar   
2013-02-26 10:04   
It would be necessary to fix the query in the module script Issue21640WrongMatchInvAccounting too, please see the issue 21640 related [1]

[1] https://issues.openbravo.com/view.php?id=21640 [^]
(0056793)
hgbot   
2013-02-26 23:13   
Repository: erp/devel/pi
Changeset: f6907c2d08fb9154b2a15fc6b4dd1e17949151ee
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Feb 26 23:13:02 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f6907c2d08fb9154b2a15fc6b4dd1e17949151ee [^]

issue 22881: Wrong definition of the alert
'Wrong Matched Invoice posting. Wrong currency conversion.'

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/Issue21640WrongMatchInvAccountingData.class
M src-util/modulescript/src/org/openbravo/modulescript/Issue21640WrongMatchInvAccounting_data.xsql
---
(0056870)
VictorVillar   
2013-03-01 00:45   
Verified
(0056919)
hudsonbot   
2013-03-02 05:48   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/f5db629e7058 [^]

Maturity status: Test