Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013604Openbravo ERPZ. Otherspublic2010-06-10 10:562010-12-09 16:02
Reportersureshbabu 
Assigned Tomirurita 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
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
Summary0013604: Same payment method can be assigned more than once to a financial account
DescriptionSame payment method can be assigned more than once to a financial account
Steps To ReproduceDeposit record not appear in the Financial account || Transaction tab

1) Created a Payment method (Financial Management || Receivables & Payables || Setup || Payment Method || Payment Method ) with the below details

Name: SimpleExecutionPrcoess_AutomaticManual

Defaults payment In (Section)

Allowed: Checked
Automatic Receipt: Checked
Automatic Deposit: Checked
Execution Type: Manual

Upon receipt use: In Transit payment account
Upon Deposit use: Deposited Payment account
Upon clearing use: Cleared Payment account


Defaults payment OUT (Section)

Allowed: Checked
Automatic Payment: Checked
Automatic Withdrawn: Checked
Execution Type: Manual

Upon Payment use: In Transit payment account
Upon Withdrawn use: Deposited Payment account
Upon clearing use: Cleared Payment account

And click save


2) Navigate to Financial account tab (Financial Management || Receivables & Payables || Transactions || Financial Account || Account ) and create a new

account

Click new and enter the below details
Name: OB_Bank_Account
Currency : Eur
Type : Bank
Bank code: 2054
Branch code: 0218
partial account no: 9129249788

3) navigate to Payment method tab and click new
4) Select the above created payment method: ExecutionType_Manual
5) Click save then click new
6) Try to select the above created payment method: ExecutionType_Manual once again.

Error: System allowing the user to select the payment method more than once.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-06-10 10:56sureshbabuNew Issue
2010-06-10 10:56sureshbabuAssigned To => adrianromero
2010-06-10 10:56sureshbabuOBNetwork customer => No
2010-06-10 10:56sureshbabuAssigned Toadrianromero => gorkaion
2010-06-14 12:57gorkaionStatusnew => scheduled
2010-06-14 12:57gorkaionfix_in_branch => pi
2010-06-15 19:06hgbotCheckin
2010-06-15 19:06hgbotNote Added: 0028466
2010-06-15 19:06hgbotStatusscheduled => resolved
2010-06-15 19:06hgbotResolutionopen => fixed
2010-06-15 19:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e75b2e4209d78e383e146535a4548610d5c4496c [^]
2010-06-16 17:54hudsonbotCheckin
2010-06-16 17:54hudsonbotNote Added: 0028520
2010-06-22 08:22sureshbabuNote Added: 0028647
2010-06-22 08:22sureshbabuStatusresolved => new
2010-06-22 08:22sureshbabuResolutionfixed => open
2010-07-22 12:19miruritaStatusnew => scheduled
2010-07-22 12:19miruritaAssigned Togorkaion => mirurita
2010-07-27 10:13hgbotCheckin
2010-07-27 10:13hgbotNote Added: 0029575
2010-07-27 10:13hgbotStatusscheduled => resolved
2010-07-27 10:13hgbotResolutionopen => fixed
2010-07-27 10:13hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/e75b2e4209d78e383e146535a4548610d5c4496c [^] => http://code.openbravo.com/erp/devel/pi/rev/6834c46944991b0e2897c2c66be87aba8377b85d [^]
2010-07-27 10:14hgbotCheckin
2010-07-27 10:14hgbotNote Added: 0029576
2010-07-27 10:14hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/6834c46944991b0e2897c2c66be87aba8377b85d [^] => http://code.openbravo.com/erp/devel/api-checks/rev/0628a7ed412632e8b9780cae5ded5478f2f511be [^]
2010-07-27 15:41hudsonbotCheckin
2010-07-27 15:41hudsonbotNote Added: 0029611
2010-08-13 05:20sureshbabuNote Added: 0029935
2010-08-13 05:20sureshbabuStatusresolved => closed
2010-12-09 16:02anonymoussf_bug_id0 => 3133243

Notes
(0028466)
hgbot   
2010-06-15 19:06   
Repository: erp/devel/pi
Changeset: e75b2e4209d78e383e146535a4548610d5c4496c
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Mon Jun 14 13:40:53 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e75b2e4209d78e383e146535a4548610d5c4496c [^]

Fixed issue 13604. Added new index on FIN_FINACC_PAYMENTMETHOD table.

---
M src-db/database/model/tables/FIN_FINACC_PAYMENTMETHOD.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0028520)
hudsonbot   
2010-06-16 17:54   
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/e75b2e4209d7 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/56352f289d38 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17673.obx [^]
(0028647)
sureshbabu   
2010-06-22 08:22   
In postgres..below message appears when i try to assign the same payment method more than once..
ERROR: duplicate key value violates unique constraint "fin_finacc_paymethod_uniquekey"

Its better to change the error message more meaningful as Error: Payment method already assigned to this Financial account.
(0029575)
hgbot   
2010-07-27 10:13   
Repository: erp/devel/pi
Changeset: 6834c46944991b0e2897c2c66be87aba8377b85d
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Tue Jul 27 10:12:49 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6834c46944991b0e2897c2c66be87aba8377b85d [^]

Fixes issue 13604: payment method - financial account assignment
Changed name of the message (FIN_FINACC_PAYMETHOD_UN)
More meaningful message is shown now when you try to assign the same
method twice to the same financial account.

---
M src-db/database/model/tables/FIN_FINACC_PAYMENTMETHOD.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0029576)
hgbot   
2010-07-27 10:14   
Repository: erp/devel/api-checks
Changeset: 0628a7ed412632e8b9780cae5ded5478f2f511be
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Tue Jul 27 10:12:12 2010 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/0628a7ed412632e8b9780cae5ded5478f2f511be [^]

Fixes issue 13604: payment method - financial account assignment
Changed name of the message (FIN_FINACC_PAYMETHOD_UN)
More meaningful message is shown now when you try to assign the same
method twice to the same financial account.

---
M model/model/tables/FIN_FINACC_PAYMENTMETHOD.xml
M model/sourcedata/AD_MESSAGE.xml
---
(0029611)
hudsonbot   
2010-07-27 15:41   
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/6834c4694499 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/634cc0909ed2 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17922.obx [^]
(0029935)
sureshbabu   
2010-08-13 05:20   
verified in postgres getting error message as "There already exists a configuration defined for this Financial Account and Payment Method."