Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025886Openbravo ERPZ. Otherspublic2014-03-04 00:052014-05-07 18:10
Reporterngarcia 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q3Fixed in Version3.0PR14Q3 
Merge Request Status
Review Assigned Tongarcia
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket27029
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025886: When posting a payment using credit and multi-currency, Bank Revaluation Gain and Loss Accounts are used at the same time
DescriptionWhen posting a payment using credit and multi-currency, Bank Revaluation Gain and Loss Accounts are used at the same time
Steps To ReproduceAs group admin role:
   Create a Financial Account for F&B España S.A.:
      Currency: USD
   Add a Payment Method to it configured to post the payment in/out
      Upon Receipt/Payment Use: In Transit Payment Account
   (Cheque fulfill the requirement)
   Create a Price List in USD, add a Version and a Product to it
   Configure the already created Financial Account, Price List and Payment Method to a Business Partner set as Customer
   Create two Payments In for that Business Partner leaving the amount as credit and with different exchange rate. Example:
      Payment 1 - Amount: 400, Exchange Rate: 0.5
      Payment 2 - Amount: 800, Exchange Rate: 1.3
   ** Due to a possible regression, you should update through database the isinvoicepaid column of the related records in the fin_payment_scheduledetail to 'Y' in order to see the available credit
   Create a Sales Invoice for that business partner. Example:
      Line Net Amount: 1200
      Tax: Ventas exentas
   Select the already generated credit when completing the invoice
   Post the Payment In and check there is one entry in the Bank Revaluation Gain Account and another one in the Bank Revaluation Loss Account
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0025895 closed Sandrahuguet Is impossible to pay a invoice with generated credit 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-03-04 00:05ngarciaNew Issue
2014-03-04 00:05ngarciaAssigned To => jonalegriaesarte
2014-03-04 00:05ngarciaModules => Core
2014-03-04 00:05ngarciaOBNetwork customer => Yes
2014-03-04 00:05ngarciaSupport ticket => 27029
2014-03-04 00:05ngarciaResolution time => 1396821600
2014-03-04 00:05ngarciaTriggers an Emergency Pack => No
2014-03-04 00:05ngarciaIssue Monitored: ngarcia
2014-03-04 00:07ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=5521#r5521
2014-03-06 12:25ngarciaTarget Version => PR14Q2
2014-03-06 12:44jonalegriaesarteAssigned Tojonalegriaesarte => pramakrishnan
2014-03-06 12:45daniOpenbravoIssue Monitored: daniOpenbravo
2014-03-07 08:29AtulOpenbravoAssigned Topramakrishnan => AtulOpenbravo
2014-03-07 08:31AtulOpenbravoStatusnew => scheduled
2014-03-07 08:31AtulOpenbravofix_in_branch => pi
2014-03-07 10:16ngarciaRelationship addeddepends on 0025895
2014-03-12 09:35AtulOpenbravoNote Added: 0065083
2014-03-20 09:31AtulOpenbravoNote Added: 0065297
2014-03-31 16:17jonalegriaesarteTarget VersionPR14Q2 => PR14Q3
2014-04-01 14:49hgbotCheckin
2014-04-01 14:49hgbotNote Added: 0065667
2014-04-01 14:49hgbotStatusscheduled => resolved
2014-04-01 14:49hgbotResolutionopen => fixed
2014-04-01 14:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5494e746e052bc598b2f6bb16adee4c699accdc4 [^]
2014-04-01 14:54AtulOpenbravoNote Added: 0065668
2014-04-01 14:54AtulOpenbravoStatusresolved => new
2014-04-01 14:54AtulOpenbravoResolutionfixed => open
2014-04-01 14:54AtulOpenbravoReview Assigned To => ngarcia
2014-04-01 14:54AtulOpenbravoStatusnew => scheduled
2014-04-01 14:54AtulOpenbravofix_in_branchpi =>
2014-04-01 14:55AtulOpenbravoStatusscheduled => resolved
2014-04-01 14:55AtulOpenbravoFixed in Version => pi
2014-04-01 14:55AtulOpenbravoResolutionopen => fixed
2014-04-02 09:04plujanNote Added: 0066000
2014-04-02 09:04plujanStatusresolved => closed
2014-04-02 09:11plujanStatusclosed => new
2014-04-02 09:11plujanNote Added: 0066049
2014-04-02 09:12plujanStatusnew => scheduled
2014-04-02 09:13plujanStatusscheduled => resolved
2014-04-02 10:44ngarciaStatusresolved => closed
2014-04-02 10:44ngarciaFixed in Versionpi => PR14Q3
2014-05-07 18:10hudsonbotCheckin
2014-05-07 18:10hudsonbotNote Added: 0066868

Notes
(0065083)
AtulOpenbravo   
2014-03-12 09:35   
Test Plan
- Login as F&B International Group Admin Role.
- Create a Financial Account for F&B España S.A keeping currency as USD.
- Add a Payment Method to it configured to post the payment in/out
  Upon Receipt/Payment Use: In Transit Payment Account.
- Create a Price List in USD, add a Version and a Product to it
- Configure the already created Financial Account, Price List and Payment Method to a Business Partner set as Customer.
- Create two Payments In for that Business Partner leaving the amount as credit and with different exchange rate. Example:
      Payment 1 - Amount: 400, Exchange Rate: 0.5
      Payment 2 - Amount: 800, Exchange Rate: 1.3
- Create a Sales Invoice for that business partner. Example:
      Line Net Amount: 1200
      Tax: Ventas exentas
- Select the already generated credit when completing the invoice. Notice that payment in is generated.
- Post the Payment In and check there is one entry in either Bank Revaluation Gain Account or Bank Revaluation Loss Account as applicable depending on the net effect of exchange rates on payment amount.
(0065297)
AtulOpenbravo   
2014-03-20 09:31   
Alternate Test Plan
- Login as F&B International Group Admin Role.
- Create a Financial Account for F&B España S.A keeping currency as USD.
- Add a Payment Method to it configured to disable the payment in/out & enable finacial account transaction posting.
  Upon Receipt/Payment Use: Keep blank.
  Upon Deposit/Withdrawal Use: In Transit Payment Account.
- Create a Price List in USD, add a Version and a Product to it
- Configure the already created Financial Account, Price List and Payment Method to a Business Partner set as Customer.
- Create two Payments In for that Business Partner leaving the amount as credit and with different exchange rate. Example:
      Payment 1 - Amount: 400, Exchange Rate: 0.5
      Payment 2 - Amount: 800, Exchange Rate: 1.3
- Create a Sales Invoice for that business partner. Example:
      Line Net Amount: 1300
      Tax: Ventas exentas
- Select the already generated credit when completing the invoice. Notice that payment in is generated.
- Reactivate the Payment, and add additional 100 so that the sales invoice gets completely paid.
- Post the Transaction entry in the Financial Account Transaction Tab and check there is one entry in either Bank Revaluation Gain Account or Bank Revaluation Loss Account as applicable depending on the net effect of exchange rates on payment amount.
(0065667)
hgbot   
2014-04-01 14:49   
Repository: erp/devel/pi
Changeset: 5494e746e052bc598b2f6bb16adee4c699accdc4
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Apr 01 18:06:18 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/5494e746e052bc598b2f6bb16adee4c699accdc4 [^]

Fixes Issue 25886 When posting a payment using credit and multi-currency,
Bank Revaluation Gain and Loss Accounts are used at the same time

---
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
---
(0065668)
AtulOpenbravo   
2014-04-01 14:54   
Re-opened to assign "Review Assigned To".
(0066000)
plujan   
2014-04-02 09:04   
Closed as it was in Resolved for too long
(0066049)
plujan   
2014-04-02 09:11   
Wrongly closed
(0066868)
hudsonbot   
2014-05-07 18:10   
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/02ca2648bcdc [^]
Maturity status: Test