Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0014845Openbravo ERPZ. Otherspublic2010-10-08 17:132011-05-19 13:51
rmorley 
eduardo_Argal 
urgentmajoralways
closedfixed 
20Community Appliance
2.50 
2.50 
Advanced Payables and Receivables Mngmt
No
0014845: Wrong accounting workflow used "On Deposit"
When depositing received funds into a Financial Account the system uses the "Upon Withdrawal" account.
Set the Accounting Configuration for a Financial Account with the following:
IN:
55500 Transit
56000 Deposit
57000 Cleared
OUT
47500 Transit
47510 Withdrawal
47600 Cleared
It doesn't matter which accounts are used as long as they are all different (so that you can see which is used where).
Set the Payment Method configuration as follows:
IN:
NO AUTOMATIC RECEIPT OR DEPOSIT
Upon Receipt = Transit
Upon Deposit = Deposit
Upon Clearing = Cleared
OUT
NO AUTOMATIC PAYMENT OR WITHDRAWAL
Upon Payment = Transit
Upon Withdrawal = Withdrawal
Upon Clearing = Cleared

Enter a Sales Invoice and receive payment against it.
Go to General Ledger Journal and filter by today's date and the Organization.
You will see transaction for
Dr 55500 Transit
Cr 43000 AR account
THIS IS CORRECT.

Go to Financial Account > Transactions. Click on Add Transaction and select the receipt that you made above (in order to Deposit the receipt into the Financial Account). Click on OK and check that the line is visible in the Transactions screen.
Go to General Ledger Journal and filter by today's date and the Organization.
You will see transaction for
Dr 47510 THIS IS NOT CORRECT. SHOULD BE 56000 IT HAS USED THE WITHDRAWAL ACCOUNT (NOT DEPOSIT)
Cr 55500 Transit account THIS IS CORRECT.

The good news is that when you match the transaction (i.e., you clear it in the Financial Account) then the correct transaction is created
Dr 57000 Cleared account THIS IS CORRECT
CR 56000 Deposit account THIS IS CORRECT
System should use the "Upon Deposit" account.
No tags attached.
Issue History
2010-10-08 17:13rmorleyNew Issue
2010-10-08 17:13rmorleyAssigned To => eduardo_Argal
2010-10-08 17:23rmorleySteps to Reproduce Updatedbug_revision_view_page.php?rev_id=1037#r1037
2010-10-11 12:48eduardo_ArgalStatusnew => scheduled
2010-10-11 12:48eduardo_Argalfix_in_branch => pi
2010-10-13 12:31hgbotCheckin
2010-10-13 12:31hgbotNote Added: 0031803
2010-10-13 12:31hgbotStatusscheduled => resolved
2010-10-13 12:31hgbotResolutionopen => fixed
2010-10-13 12:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/488f3922c1fa8ab68a91c66707ea26dfa33d8600 [^]
2010-10-13 23:38hudsonbotCheckin
2010-10-13 23:38hudsonbotNote Added: 0031839
2011-05-19 13:51miruritaNote Added: 0037224
2011-05-19 13:51miruritaStatusresolved => closed

Notes
(0031803)
hgbot   
2010-10-13 12:31   
Repository: erp/devel/pi
Changeset: 488f3922c1fa8ab68a91c66707ea26dfa33d8600
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed Oct 13 11:33:36 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/488f3922c1fa8ab68a91c66707ea26dfa33d8600 [^]

Fixes bug 0014845: Wrong accounting workflow

---
M src/org/openbravo/erpCommon/ad_forms/DocFINFinAccTransaction.java
---
(0031839)
hudsonbot   
2010-10-13 23:38   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/488f3922c1fa [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/c531f0a7334b [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18531.obx [^]
(0037224)
mirurita   
2011-05-19 13:51   
Verified.