Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0017774 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Z. Others | major | always | 2011-06-23 18:29 | 2011-08-01 14:20 | |||
| Reporter | jaime_chamorro | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 7fb2b516c51e | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Advanced Payables and Receivables Mngmt | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0017774: Wrong accounting for write off amounts | |||||||
| Description | The 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 Solution | There should be the option to configure an income write-off. The application has to differenciate between both: profit and loss write-off. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  Wrong Write off posting.bmp [^] (535,758 bytes) 2011-06-23 18:29 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0039095) dmitry_mezentsev (developer) 2011-07-15 15:38 |
That is finally proper priority and severity of this ticket. |
|
(0039226) hgbot (developer) 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 (developer) 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 (manager) 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 (developer) 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 (developer) 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 (manager) 2011-07-19 18:54 |
fixed and working |
|
(0039626) hudsonbot (developer) 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 (developer) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-06-23 18:29 | jaime_chamorro | New Issue | |
| 2011-06-23 18:29 | jaime_chamorro | Assigned To | => eduardo_Argal |
| 2011-06-23 18:29 | jaime_chamorro | File Added: Wrong Write off posting.bmp | |
| 2011-07-04 17:55 | maite | Priority | high => immediate |
| 2011-07-04 17:55 | maite | Severity | major => critical |
| 2011-07-04 19:16 | maite | Project | Modules => Openbravo ERP |
| 2011-07-04 19:18 | maite | Modules | => Advanced Payables and Receivables Mngmt |
| 2011-07-04 19:18 | maite | Resolution time | => 1310076000 |
| 2011-07-04 19:18 | maite | Category | Advance Payables and Receivables - es_ES => Z. Others |
| 2011-07-07 10:32 | eduardo_Argal | Status | new => scheduled |
| 2011-07-07 10:32 | eduardo_Argal | fix_in_branch | => pi |
| 2011-07-15 15:38 | dmitry_mezentsev | Note Added: 0039095 | |
| 2011-07-15 15:38 | dmitry_mezentsev | Priority | immediate => urgent |
| 2011-07-15 15:38 | dmitry_mezentsev | Severity | critical => major |
| 2011-07-15 15:38 | dmitry_mezentsev | fix_in_branch | pi => |
| 2011-07-19 13:33 | eduardo_Argal | Status | scheduled => resolved |
| 2011-07-19 13:33 | eduardo_Argal | Fixed in SCM revision | => . |
| 2011-07-19 13:33 | eduardo_Argal | Resolution | open => fixed |
| 2011-07-19 13:34 | eduardo_Argal | Status | resolved => new |
| 2011-07-19 13:34 | eduardo_Argal | Resolution | fixed => open |
| 2011-07-19 13:34 | eduardo_Argal | Status | new => scheduled |
| 2011-07-19 13:34 | eduardo_Argal | fix_in_branch | => pi |
| 2011-07-19 13:38 | hgbot | Checkin | |
| 2011-07-19 13:38 | hgbot | Note Added: 0039226 | |
| 2011-07-19 13:38 | hgbot | Status | scheduled => resolved |
| 2011-07-19 13:38 | hgbot | Resolution | open => fixed |
| 2011-07-19 13:38 | hgbot | Fixed in SCM revision | . => http://code.openbravo.com/erp/devel/pi/rev/e622dead28b436553e4d803726dfd3db21f77b82 [^] |
| 2011-07-19 13:40 | hgbot | Checkin | |
| 2011-07-19 13:40 | hgbot | Note Added: 0039227 | |
| 2011-07-19 14:52 | psanjuan | Note Added: 0039232 | |
| 2011-07-19 15:00 | psanjuan | Note Edited: 0039232 | View Revisions |
| 2011-07-19 15:08 | psanjuan | Note Edited: 0039232 | View Revisions |
| 2011-07-19 15:16 | psanjuan | Note Edited: 0039232 | View Revisions |
| 2011-07-19 15:17 | psanjuan | Note Edited: 0039232 | View Revisions |
| 2011-07-19 15:35 | psanjuan | Note Edited: 0039232 | View Revisions |
| 2011-07-19 15:35 | psanjuan | Note Edited: 0039232 | View Revisions |
| 2011-07-19 17:54 | eduardo_Argal | Note Added: 0039244 | |
| 2011-07-19 17:54 | eduardo_Argal | Status | resolved => new |
| 2011-07-19 17:54 | eduardo_Argal | Resolution | fixed => open |
| 2011-07-19 17:55 | eduardo_Argal | Status | new => scheduled |
| 2011-07-19 18:10 | hgbot | Checkin | |
| 2011-07-19 18:10 | hgbot | Note Added: 0039247 | |
| 2011-07-19 18:10 | hgbot | Status | scheduled => resolved |
| 2011-07-19 18:10 | hgbot | Resolution | open => fixed |
| 2011-07-19 18:10 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/e622dead28b436553e4d803726dfd3db21f77b82 [^] => http://code.openbravo.com/erp/devel/pi/rev/7fb2b516c51e5fb6d2b1d0ae333b069d02b22642 [^] |
| 2011-07-19 18:54 | psanjuan | Note Added: 0039251 | |
| 2011-07-19 18:54 | psanjuan | Status | resolved => closed |
| 2011-07-19 18:54 | psanjuan | fix_in_branch | pi => |
| 2011-08-01 14:20 | hudsonbot | Checkin | |
| 2011-08-01 14:20 | hudsonbot | Note Added: 0039626 | |
| 2011-08-01 14:20 | hudsonbot | Checkin | |
| 2011-08-01 14:20 | hudsonbot | Note Added: 0039635 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |