Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0018031
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] Z. Othersmajoralways2011-06-23 18:292011-08-29 12:33
Reporterjaime_chamorroView Statuspublic 
Assigned Toeduardo_Argal 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branch2.50Fixed in SCM revision6a214598625f
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018031: Wrong accounting for write off amounts

DescriptionThe 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
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 a "Write-off Revenue" account. The application has to differenciate between both: profit and loss write-off.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0017774 closededuardo_Argal Wrong accounting for write off amounts 

-  Notes
(0039481)
hgbot (developer)
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 (developer)
2011-08-19 09:39

verified

- Issue History
Date Modified Username Field Change
2011-07-19 13:34 eduardo_Argal Type defect => backport
2011-07-19 13:34 eduardo_Argal fix_in_branch => 2.50
2011-07-28 12:40 hgbot Checkin
2011-07-28 12:40 hgbot Note Added: 0039481
2011-07-28 12:40 hgbot Status scheduled => resolved
2011-07-28 12:40 hgbot Resolution open => fixed
2011-07-28 12:40 hgbot Fixed in SCM revision . => http://code.openbravo.com/erp/stable/2.50/rev/6a214598625f1834341e6137133dd112c8843ac2 [^]
2011-08-19 09:39 maite Note Added: 0040344
2011-08-19 09:39 maite Status resolved => closed
2011-08-29 12:33 psanjuan Description Updated View Revisions
2011-08-29 12:33 psanjuan Proposed Solution updated


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker