Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010339Openbravo ERP03. Procurement managementpublic2009-08-19 15:032009-10-06 11:14
Reporternetworkb 
Assigned Todalsasua 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP3 
Target Version2.50MP6Fixed in Version2.50MP6 
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
Summary0010339: Goods Receipt and Invoice accounting entries are not coherent in US model
DescriptionUsing US accounting model, when you have a PO, creates a goods receipt for it and posts it you obtain a general ledger entry with some accounts involved.
If you then creates an invoice from the receipt and posts it, general ledger entry involves different accounts.
Steps To Reproduce1. Go to Procurement Management || Transactions || Purchase Order and create a PO with some lines.
2. Go to Procurement Management || Transactions || Purchase Order and create the receipt for the order.
3. Complete and Post the goods receipt.
4. Go to Procurement Management || Transactions || Purchase Invoice and create an invoice from the receipt.
5. Complete and Post it.
6. Realize that credit account involved in goods receipt entry has not debit account related in the invoice entry. And also that product expense account is involved in the invoice entry.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-08-19 15:03networkbNew Issue
2009-08-19 15:03networkbAssigned To => rafaroda
2009-08-20 07:10rafarodaNote Added: 0019082
2009-08-20 07:10rafarodaAssigned Torafaroda => dalsasua
2009-08-20 07:10rafarodaPriorityimmediate => urgent
2009-08-20 07:10rafarodaStatusnew => acknowledged
2009-08-20 09:24networkbTarget Version => 2.50MP4
2009-08-20 11:27rafarodaPriorityurgent => immediate
2009-08-20 11:27rafarodaStatusacknowledged => scheduled
2009-08-20 11:33networkbPriorityimmediate => urgent
2009-08-20 11:36networkbTarget Version2.50MP4 => 2.50MP5
2009-09-03 16:52networkbTarget Version2.50MP5 => 2.50MP6
2009-09-03 16:57dalsasuaNote Added: 0019455
2009-09-09 12:11dalsasuaNote Added: 0019586
2009-09-09 12:14hgbotCheckin
2009-09-09 12:14hgbotNote Added: 0019588
2009-09-09 12:14hgbotStatusscheduled => resolved
2009-09-09 12:14hgbotResolutionopen => fixed
2009-09-09 12:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d40c533aada2bb7c607498c6fb1677d307d6737b [^]
2009-09-09 12:23hudsonbotCheckin
2009-09-09 12:23hudsonbotNote Added: 0019589
2009-09-09 12:23hudsonbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/d40c533aada2bb7c607498c6fb1677d307d6737b [^] =>
2009-09-09 12:37hudsonbotCheckin
2009-09-09 12:37hudsonbotNote Added: 0019594
2009-09-09 12:41hudsonbotCheckin
2009-09-09 12:41hudsonbotNote Added: 0019597
2009-09-09 14:40hudsonbotCheckin
2009-09-09 14:40hudsonbotNote Added: 0019606
2009-09-09 16:24hudsonbotCheckin
2009-09-09 16:24hudsonbotNote Added: 0019619
2009-09-09 21:16hudsonbotCheckin
2009-09-09 21:16hudsonbotNote Added: 0019630
2009-09-09 21:44hudsonbotCheckin
2009-09-09 21:44hudsonbotNote Added: 0019634
2009-09-09 23:14hudsonbotCheckin
2009-09-09 23:14hudsonbotNote Added: 0019641
2009-09-09 23:41hgbotCheckin
2009-09-09 23:41hgbotNote Added: 0019647
2009-09-09 23:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7743b5a1b988ad9ddf9a3cca82c7849702cc10be [^]
2009-09-09 23:52hudsonbotCheckin
2009-09-09 23:52hudsonbotNote Added: 0019648
2009-09-09 23:52hudsonbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/7743b5a1b988ad9ddf9a3cca82c7849702cc10be [^] =>
2009-09-09 23:56hudsonbotCheckin
2009-09-09 23:56hudsonbotNote Added: 0019649
2009-09-10 00:29hudsonbotCheckin
2009-09-10 00:29hudsonbotNote Added: 0019650
2009-09-10 00:38hudsonbotCheckin
2009-09-10 00:38hudsonbotNote Added: 0019651
2009-09-10 00:56hudsonbotCheckin
2009-09-10 00:56hudsonbotNote Added: 0019656
2009-09-10 00:56hudsonbotCheckin
2009-09-10 00:56hudsonbotNote Added: 0019659
2009-09-10 07:54hudsonbotCheckin
2009-09-10 07:54hudsonbotNote Added: 0019665
2009-09-10 07:54hudsonbotCheckin
2009-09-10 07:54hudsonbotNote Added: 0019668
2009-09-10 09:03hudsonbotCheckin
2009-09-10 09:03hudsonbotNote Added: 0019680
2009-09-10 09:04hudsonbotCheckin
2009-09-10 09:04hudsonbotNote Added: 0019682
2009-09-10 10:42hudsonbotCheckin
2009-09-10 10:42hudsonbotNote Added: 0019700
2009-09-10 10:42hudsonbotCheckin
2009-09-10 10:42hudsonbotNote Added: 0019702
2009-09-10 14:38hudsonbotCheckin
2009-09-10 14:38hudsonbotNote Added: 0019726
2009-09-10 14:38hudsonbotCheckin
2009-09-10 14:38hudsonbotNote Added: 0019735
2009-09-10 16:04hudsonbotCheckin
2009-09-10 16:04hudsonbotNote Added: 0019741
2009-09-10 16:04hudsonbotCheckin
2009-09-10 16:04hudsonbotNote Added: 0019744
2009-09-10 17:33hudsonbotCheckin
2009-09-10 17:33hudsonbotNote Added: 0019753
2009-09-10 17:33hudsonbotCheckin
2009-09-10 17:33hudsonbotNote Added: 0019757
2009-09-10 21:17hudsonbotCheckin
2009-09-10 21:17hudsonbotNote Added: 0019764
2009-09-10 21:17hudsonbotCheckin
2009-09-10 21:17hudsonbotNote Added: 0019765
2009-09-10 23:14hudsonbotCheckin
2009-09-10 23:14hudsonbotNote Added: 0019773
2009-09-10 23:15hudsonbotCheckin
2009-09-10 23:15hudsonbotNote Added: 0019782
2009-09-11 07:08hudsonbotCheckin
2009-09-11 07:08hudsonbotNote Added: 0019787
2009-09-11 07:08hudsonbotCheckin
2009-09-11 07:08hudsonbotNote Added: 0019790
2009-09-11 21:17hudsonbotCheckin
2009-09-11 21:17hudsonbotNote Added: 0019825
2009-09-11 21:17hudsonbotCheckin
2009-09-11 21:17hudsonbotNote Added: 0019829
2009-09-11 23:14hudsonbotCheckin
2009-09-11 23:14hudsonbotNote Added: 0019840
2009-09-11 23:15hudsonbotCheckin
2009-09-11 23:15hudsonbotNote Added: 0019849
2009-09-12 21:17hudsonbotCheckin
2009-09-12 21:17hudsonbotNote Added: 0019854
2009-09-12 21:17hudsonbotCheckin
2009-09-12 21:17hudsonbotNote Added: 0019857
2009-09-13 21:17hudsonbotCheckin
2009-09-13 21:17hudsonbotNote Added: 0019867
2009-09-13 21:17hudsonbotCheckin
2009-09-13 21:17hudsonbotNote Added: 0019871
2009-09-14 11:51hudsonbotCheckin
2009-09-14 11:51hudsonbotNote Added: 0019888
2009-09-14 11:51hudsonbotCheckin
2009-09-14 11:51hudsonbotNote Added: 0019892
2009-09-14 18:37hudsonbotCheckin
2009-09-14 18:37hudsonbotNote Added: 0019920
2009-09-14 18:37hudsonbotCheckin
2009-09-14 18:37hudsonbotNote Added: 0019921
2009-09-14 19:57hudsonbotCheckin
2009-09-14 19:57hudsonbotNote Added: 0019941
2009-09-14 19:57hudsonbotCheckin
2009-09-14 19:57hudsonbotNote Added: 0019943
2009-09-14 21:17hudsonbotCheckin
2009-09-14 21:17hudsonbotNote Added: 0019983
2009-09-14 21:17hudsonbotCheckin
2009-09-14 21:17hudsonbotNote Added: 0019985
2009-09-14 23:14hudsonbotCheckin
2009-09-14 23:14hudsonbotNote Added: 0019994
2009-09-14 23:15hudsonbotCheckin
2009-09-14 23:15hudsonbotNote Added: 0019999
2009-09-15 12:35hudsonbotCheckin
2009-09-15 12:35hudsonbotNote Added: 0020057
2009-09-15 12:35hudsonbotCheckin
2009-09-15 12:35hudsonbotNote Added: 0020064
2009-09-21 13:35psarobeStatusresolved => closed
2009-09-21 13:35psarobeNote Added: 0020240
2009-09-21 13:35psarobeFixed in Version => 2.50MP6
2009-09-22 00:00anonymoussf_bug_id0 => 2863838
2009-09-29 14:10hgbotCheckin
2009-09-29 14:10hgbotNote Added: 0020456
2009-09-29 14:10hgbotStatusclosed => resolved
2009-09-29 14:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/7743b5a1b988ad9ddf9a3cca82c7849702cc10be [^]
2009-10-06 11:14psarobeStatusresolved => closed
2009-10-06 11:14psarobeNote Added: 0020745

Notes
(0019082)
rafaroda   
2009-08-20 07:10   
David,

Can you please comment on this issue?

Thanks.
(0019455)
dalsasua   
2009-09-03 16:57   
Hi,

There exists a document called matched invoices that is thought to create the required entry. The posting method for this document is not developed, but I will take care of this.

Regards.

David Alsasua
(0019586)
dalsasua   
2009-09-09 12:11   
Hi,

In order to fix this bug, the accounting logic of the document matched invoices is developed. Some things must be taken into account to apply this fix:

- In product > accounting and product category > accounting tabs, a new field has to be filled in: Invoice Price Variance. This account will reflect the difference between the current Costs and the Invoice Price. This is not a mandatory field.
- If in a chart of accounts, user wants to have this default value set, the string "P_INVOICEPRICEVARIANCE_ACCT" must be added in the default column of the row of the subaccount to be inserted in this field. Nevertheless, this is an optional default value.

Regards.
(0019588)
hgbot   
2009-09-09 12:14   
Repository: erp/devel/pi
Changeset: d40c533aada2bb7c607498c6fb1677d307d6737b
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Wed Sep 09 12:13:51 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d40c533aada2bb7c607498c6fb1677d307d6737b [^]

Fixes issue 10339: Goods Receipt and Invoice accounting entries\nare not coherent in US model

---
M src-db/database/sourcedata/AD_FIELD.xml
M src/org/openbravo/erpCommon/ad_forms/AcctServer.java
A src/org/openbravo/erpCommon/ad_forms/DocMatchInv.java
A src/org/openbravo/erpCommon/ad_forms/DocMatchInvTemplate.java
A src/org/openbravo/erpCommon/ad_forms/DocMatchInv_data.xsql
---
(0019589)
hudsonbot   
2009-09-09 12:23   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-oracle/738/ [^]
------
(0019594)
hudsonbot   
2009-09-09 12:37   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/844/ [^]
------
(0019597)
hudsonbot   
2009-09-09 12:41   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-pgsql/341/ [^]
------
(0019606)
hudsonbot   
2009-09-09 14:40   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/84/ [^]
------
(0019619)
hudsonbot   
2009-09-09 16:24   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-oracle/336/ [^]
------
(0019630)
hudsonbot   
2009-09-09 21:16   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/168/ [^]
------
(0019634)
hudsonbot   
2009-09-09 21:44   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/85/ [^]
------
(0019641)
hudsonbot   
2009-09-09 23:14   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/135/ [^]
------
(0019647)
hgbot   
2009-09-09 23:41   
Repository: erp/devel/pi
Changeset: 7743b5a1b988ad9ddf9a3cca82c7849702cc10be
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Wed Sep 09 23:41:04 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7743b5a1b988ad9ddf9a3cca82c7849702cc10be [^]

Fixes Issue 10339: Goods Receipt and Invoice accounting entries
are not coherent in US model

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0019648)
hudsonbot   
2009-09-09 23:52   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-oracle/742/ [^]
------
(0019649)
hudsonbot   
2009-09-09 23:56   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/849/ [^]
------
(0019650)
hudsonbot   
2009-09-10 00:29   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-oracle/338/ [^]
------
(0019651)
hudsonbot   
2009-09-10 00:38   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-pgsql/344/ [^]
------
(0019656)
hudsonbot   
2009-09-10 00:56   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/86/ [^]
------
(0019659)
hudsonbot   
2009-09-10 00:56   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/86/ [^]
------
(0019665)
hudsonbot   
2009-09-10 07:54   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/169/ [^]
------
(0019668)
hudsonbot   
2009-09-10 07:54   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/169/ [^]
------
(0019680)
hudsonbot   
2009-09-10 09:03   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/87/ [^]
------
(0019682)
hudsonbot   
2009-09-10 09:04   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/87/ [^]
------
(0019700)
hudsonbot   
2009-09-10 10:42   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-smoke-test/59/ [^]
------
(0019702)
hudsonbot   
2009-09-10 10:42   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-smoke-test/59/ [^]
------
(0019726)
hudsonbot   
2009-09-10 14:38   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/88/ [^]
------
(0019735)
hudsonbot   
2009-09-10 14:38   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/88/ [^]
------
(0019741)
hudsonbot   
2009-09-10 16:04   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/170/ [^]
------
(0019744)
hudsonbot   
2009-09-10 16:04   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/170/ [^]
------
(0019753)
hudsonbot   
2009-09-10 17:33   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/89/ [^]
------
(0019757)
hudsonbot   
2009-09-10 17:33   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/89/ [^]
------
(0019764)
hudsonbot   
2009-09-10 21:17   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/171/ [^]
------
(0019765)
hudsonbot   
2009-09-10 21:17   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/171/ [^]
------
(0019773)
hudsonbot   
2009-09-10 23:14   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/136/ [^]
------
(0019782)
hudsonbot   
2009-09-10 23:15   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/136/ [^]
------
(0019787)
hudsonbot   
2009-09-11 07:08   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/172/ [^]
------
(0019790)
hudsonbot   
2009-09-11 07:08   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/172/ [^]
------
(0019825)
hudsonbot   
2009-09-11 21:17   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/173/ [^]
------
(0019829)
hudsonbot   
2009-09-11 21:17   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/173/ [^]
------
(0019840)
hudsonbot   
2009-09-11 23:14   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/137/ [^]
------
(0019849)
hudsonbot   
2009-09-11 23:15   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/137/ [^]
------
(0019854)
hudsonbot   
2009-09-12 21:17   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/174/ [^]
------
(0019857)
hudsonbot   
2009-09-12 21:17   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/174/ [^]
------
(0019867)
hudsonbot   
2009-09-13 21:17   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/175/ [^]
------
(0019871)
hudsonbot   
2009-09-13 21:17   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/175/ [^]
------
(0019888)
hudsonbot   
2009-09-14 11:51   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/138/ [^]
------
(0019892)
hudsonbot   
2009-09-14 11:51   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/138/ [^]
------
(0019920)
hudsonbot   
2009-09-14 18:37   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/176/ [^]
------
(0019921)
hudsonbot   
2009-09-14 18:37   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/176/ [^]
------
(0019941)
hudsonbot   
2009-09-14 19:57   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/177/ [^]
------
(0019943)
hudsonbot   
2009-09-14 19:57   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/177/ [^]
------
(0019983)
hudsonbot   
2009-09-14 21:17   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/178/ [^]
------
(0019985)
hudsonbot   
2009-09-14 21:17   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/178/ [^]
------
(0019994)
hudsonbot   
2009-09-14 23:14   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/139/ [^]
------
(0019999)
hudsonbot   
2009-09-14 23:15   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/139/ [^]
------
(0020057)
hudsonbot   
2009-09-15 12:35   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/179/ [^]
------
(0020064)
hudsonbot   
2009-09-15 12:35   
Fixed Issue 10339

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/179/ [^]
------
(0020240)
psarobe   
2009-09-21 13:35   
With those steps and description is impossible to verify the bug
(0020456)
hgbot   
2009-09-29 14:10   
Repository: erp/devel/pi-pageddatagrid
Changeset: 7743b5a1b988ad9ddf9a3cca82c7849702cc10be
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Wed Sep 09 23:41:04 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/7743b5a1b988ad9ddf9a3cca82c7849702cc10be [^]

Fixes Issue 10339: Goods Receipt and Invoice accounting entries
are not coherent in US model

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0020745)
psarobe   
2009-10-06 11:14   
Closed again because hudson has reopened without no reason