Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0018031Openbravo ERPZ. Otherspublic2011-06-23 18:292011-08-29 12:33
jaime_chamorro 
eduardo_Argal 
urgentmajoralways
closedfixed 
5
 
 
Advanced Payables and Receivables Mngmt
No
0018031: Wrong accounting for write off amounts
The application is not properly accounting the write off amounts 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
” >> “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.
There should be the option to configure a "Write-off Revenue" account. The application has to differenciate between both: profit and loss write-off.
No tags attached.
blocks defect 0017774 closed eduardo_Argal Wrong accounting for write off amounts 
Issue History
2011-07-19 13:34eduardo_ArgalTypedefect => backport
2011-07-19 13:34eduardo_Argalfix_in_branch => 2.50
2011-07-28 12:40hgbotCheckin
2011-07-28 12:40hgbotNote Added: 0039481
2011-07-28 12:40hgbotStatusscheduled => resolved
2011-07-28 12:40hgbotResolutionopen => fixed
2011-07-28 12:40hgbotFixed in SCM revision. => http://code.openbravo.com/erp/stable/2.50/rev/6a214598625f1834341e6137133dd112c8843ac2 [^]
2011-08-19 09:39maiteNote Added: 0040344
2011-08-19 09:39maiteStatusresolved => closed
2011-08-29 12:33psanjuanDescription Updatedbug_revision_view_page.php?rev_id=2623#r2623
2011-08-29 12:33psanjuanProposed Solution updated

Notes
(0039481)
hgbot   
2011-07-28 12:40   
Repository: erp/stable/2.50
Changeset: 6a214598625f1834341e6137133dd112c8843ac2
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Jul 19 17:53:25 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/6a214598625f1834341e6137133dd112c8843ac2 [^]

Fixes bug 0018031: 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
---
(0040344)
maite   
2011-08-19 09:39   
verified