Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017774Openbravo ERPZ. Otherspublic2011-06-23 18:292011-08-01 14:20
Reporterjaime_chamorro 
Assigned Toeduardo_Argal 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017774: Wrong accounting for write off amounts
DescriptionThe application is accounting not properly the write off amount when the adding payment in/out is done whatever that is income or expense. Currently, the write off amounts are being posted against the account combination write-off configured at business partner level in the accounting by default system (Financial Management || Accounting || Setup || Accounting Schema || Accounting Schema >> Defaults). In our example this account is “69400” for both cases (positive or negative write-off). From the accounting point of view this is wrong because it should be against profit account if the write-off is positive (an income). But the system does not make this differentiation.
In conclusion, it necessary to have an extra account to write-off positive as well to post the write-off incomes
Steps To Reproduce” >> “Add Payment in/out” pop-up and filter to look for the purchase invoice created >> select the purchase invoiced created (153,4 €). There is a difference of 2,4 € and mark the radio button “Write off the difference”. Press ok.
3. Financial Account CAIXA >> Transactions >> Button “Matching Using Imported Bank Statement” >> add the payment in amount 201 € >> “Add Transaction” pop-up and filter by: Transaction Type: Payment In/out
 Transaction Date: by default
 Document: Received in
4. Press button “Add Payment in/out” >> “Add Payment in/out” pop-up and filter to look for the sales invoice created >> select the sales invoiced created (205,2 €). There is a difference of 4,2 € and mark the radio button “Write off the difference”. Press ok.
5. Save both lined matched and press button “Reconcile”.
B. Reconciliation Posting Process: transaction Financial Management || Receivables & Payables || Transactions || Financial Account || Account >> Reconciliation tab
1. Select the proper document no. reconciliation (#1000018 in our example) and press “Post” button. You can check the posting document in the pictured attached.
2. As you can check both write-off amounts have been posted against the same loss account configured (669) , the income in credit (2,4) and the loss in debit (4,2). he credit income must be posted in a profit account, for exaploe 759.
Proposed SolutionThere should be the option to configure an income write-off. The application has to differenciate between both: profit and loss write-off.
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0018031 closed eduardo_Argal Wrong accounting for write off amounts 
Attached Files? Wrong Write off posting.bmp (535,758) 2011-06-23 18:29
https://issues.openbravo.com/file_download.php?file_id=4216&type=bug
Issue History
Date ModifiedUsernameFieldChange
2011-06-23 18:29jaime_chamorroNew Issue
2011-06-23 18:29jaime_chamorroAssigned To => eduardo_Argal
2011-06-23 18:29jaime_chamorroFile Added: Wrong Write off posting.bmp
2011-07-04 17:55maitePriorityhigh => immediate
2011-07-04 17:55maiteSeveritymajor => critical
2011-07-04 19:16maiteProjectModules => Openbravo ERP
2011-07-04 19:18maiteModules => Advanced Payables and Receivables Mngmt
2011-07-04 19:18maiteResolution time => 1310076000
2011-07-04 19:18maiteCategoryAdvance Payables and Receivables - es_ES => Z. Others
2011-07-07 10:32eduardo_ArgalStatusnew => scheduled
2011-07-07 10:32eduardo_Argalfix_in_branch => pi
2011-07-15 15:38dmitry_mezentsevNote Added: 0039095
2011-07-15 15:38dmitry_mezentsevPriorityimmediate => urgent
2011-07-15 15:38dmitry_mezentsevSeveritycritical => major
2011-07-15 15:38dmitry_mezentsevfix_in_branchpi =>
2011-07-19 13:33eduardo_ArgalStatusscheduled => resolved
2011-07-19 13:33eduardo_ArgalFixed in SCM revision => .
2011-07-19 13:33eduardo_ArgalResolutionopen => fixed
2011-07-19 13:34eduardo_ArgalStatusresolved => new
2011-07-19 13:34eduardo_ArgalResolutionfixed => open
2011-07-19 13:34eduardo_ArgalStatusnew => scheduled
2011-07-19 13:34eduardo_Argalfix_in_branch => pi
2011-07-19 13:38hgbotCheckin
2011-07-19 13:38hgbotNote Added: 0039226
2011-07-19 13:38hgbotStatusscheduled => resolved
2011-07-19 13:38hgbotResolutionopen => fixed
2011-07-19 13:38hgbotFixed in SCM revision. => http://code.openbravo.com/erp/devel/pi/rev/e622dead28b436553e4d803726dfd3db21f77b82 [^]
2011-07-19 13:40hgbotCheckin
2011-07-19 13:40hgbotNote Added: 0039227
2011-07-19 14:52psanjuanNote Added: 0039232
2011-07-19 15:00psanjuanNote Edited: 0039232bug_revision_view_page.php?bugnote_id=0039232#r2457
2011-07-19 15:08psanjuanNote Edited: 0039232bug_revision_view_page.php?bugnote_id=0039232#r2458
2011-07-19 15:16psanjuanNote Edited: 0039232bug_revision_view_page.php?bugnote_id=0039232#r2459
2011-07-19 15:17psanjuanNote Edited: 0039232bug_revision_view_page.php?bugnote_id=0039232#r2460
2011-07-19 15:35psanjuanNote Edited: 0039232bug_revision_view_page.php?bugnote_id=0039232#r2461
2011-07-19 15:35psanjuanNote Edited: 0039232bug_revision_view_page.php?bugnote_id=0039232#r2462
2011-07-19 17:54eduardo_ArgalNote Added: 0039244
2011-07-19 17:54eduardo_ArgalStatusresolved => new
2011-07-19 17:54eduardo_ArgalResolutionfixed => open
2011-07-19 17:55eduardo_ArgalStatusnew => scheduled
2011-07-19 18:10hgbotCheckin
2011-07-19 18:10hgbotNote Added: 0039247
2011-07-19 18:10hgbotStatusscheduled => resolved
2011-07-19 18:10hgbotResolutionopen => fixed
2011-07-19 18:10hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/e622dead28b436553e4d803726dfd3db21f77b82 [^] => http://code.openbravo.com/erp/devel/pi/rev/7fb2b516c51e5fb6d2b1d0ae333b069d02b22642 [^]
2011-07-19 18:54psanjuanNote Added: 0039251
2011-07-19 18:54psanjuanStatusresolved => closed
2011-07-19 18:54psanjuanfix_in_branchpi =>
2011-08-01 14:20hudsonbotCheckin
2011-08-01 14:20hudsonbotNote Added: 0039626
2011-08-01 14:20hudsonbotCheckin
2011-08-01 14:20hudsonbotNote Added: 0039635

Notes
(0039095)
dmitry_mezentsev   
2011-07-15 15:38   
That is finally proper priority and severity of this ticket.
(0039226)
hgbot   
2011-07-19 13:38   
Repository: erp/devel/pi
Changeset: e622dead28b436553e4d803726dfd3db21f77b82
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Jul 19 13:37:14 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e622dead28b436553e4d803726dfd3db21f77b82 [^]

Fixes bug 0017774: Wrong accounting for write off amounts

---
M src-db/database/model/tables/C_ACCTSCHEMA_DEFAULT.xml
M src-db/database/model/tables/C_BP_GROUP_ACCT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src/org/openbravo/erpCommon/ad_forms/AcctServer.java
M src/org/openbravo/erpCommon/ad_forms/AcctServer_data.xsql
M src/org/openbravo/erpCommon/ad_forms/DocFINFinAccTransaction.java
M src/org/openbravo/erpCommon/ad_forms/DocFINPayment.java
M src/org/openbravo/erpCommon/ad_forms/DocFINReconciliation.java
M src/org/openbravo/erpCommon/ad_forms/DocPayment.java
M src/org/openbravo/erpCommon/businessUtility/InitialSetupUtility.java
---
(0039227)
hgbot   
2011-07-19 13:40   
Repository: erp/mods/org.openbravo.module.remittance
Changeset: 74d99708d397990056b70e229dda1e3402e35e1d
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Jul 19 13:40:15 2011 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/74d99708d397990056b70e229dda1e3402e35e1d [^]

Related to issue 0017774: Wrong accounting for write off amounts

---
M src/org/openbravo/module/remittance/ad_forms/DocREMRemittance.java
M src/org/openbravo/module/remittance/ad_forms/DocREMRemittanceReturn.java
---
(0039232)
psanjuan   
2011-07-19 14:52   
(edited on: 2011-07-19 15:35)
Below scenarios seems to be failing:
scenario 1
Create a sales invoice for a client which belongs to Cliente - Tier 1, which has below accounts as write-off accounts setup in the BP Category: 0-65900- and 0-75900-

Sales invoice amount = 24807.88
Enter a payment in = 24807 and write-off the diference.

A payment in is generated. Payment method is setup in the financial account in a way that it is only posted once reconcilied.

Go to financial account and reconcile that payment. Get it posted.
Accounting shows the write-off account setup in the Accounting Schema - Defaults (0-69400-) and that should not be the case. Account 0-65900- should be used instead.

scenario 2
Create a purchase invoice for a vendor which belongs to Proveedores BP category, which has below accounts as write-off accounts setup in the BP Category: 0-65900- and 0-75900-

Purchase invoice amount = 1352.28
Enter a payment out = 15530.73 and write-off the diference.

A payment out is generated. Payment method is setup in the financial account in a way that it is only posted once reconcilied.

Go to financial account and add that transaction.
Get it post.
Accounting shows the write-off account setup in the Accounting Schema - Defaults (0-79400-) and that should not be the case. Account 0-75900- should be used instead.
(0039244)
eduardo_Argal   
2011-07-19 17:54   
Below scenarios seems to be failing:
scenario 1
Create a sales invoice for a client which belongs to Cliente - Tier 1, which has below accounts as write-off accounts setup in the BP Category: 0-65900- and 0-75900-

Sales invoice amount = 24807.88
Enter a payment in = 24807 and write-off the diference.

A payment in is generated. Payment method is setup in the financial account in a way that it is only posted once reconcilied.

Go to financial account and reconcile that payment. Get it posted.
Accounting shows the write-off account setup in the Accounting Schema - Defaults (0-69400-) and that should not be the case. Account 0-65900- should be used instead.

scenario 2
Create a purchase invoice for a vendor which belongs to Proveedores BP category, which has below accounts as write-off accounts setup in the BP Category: 0-65900- and 0-75900-

Purchase invoice amount = 1352.28
Enter a payment out = 15530.73 and write-off the diference.

A payment out is generated. Payment method is setup in the financial account in a way that it is only posted once reconcilied.

Go to financial account and add that transaction.
Get it post.
Accounting shows the write-off account setup in the Accounting Schema - Defaults (0-79400-) and that should not be the case. Account 0-75900- should be used instead.
(0039247)
hgbot   
2011-07-19 18:10   
Repository: erp/devel/pi
Changeset: 7fb2b516c51e5fb6d2b1d0ae333b069d02b22642
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Jul 19 18:09:14 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7fb2b516c51e5fb6d2b1d0ae333b069d02b22642 [^]

Fixes bug 0017774: Wrong accounting for write off amounts

---
M src/org/openbravo/erpCommon/ad_forms/DocFINReconciliation.java
---
(0039251)
psanjuan   
2011-07-19 18:54   
fixed and working
(0039626)
hudsonbot   
2011-08-01 14:20   
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/cf2afed6e8ef [^]

Maturity status: Test
(0039635)
hudsonbot   
2011-08-01 14:20   
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/cf2afed6e8ef [^]

Maturity status: Test