Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0025886Openbravo ERPZ. Otherspublic2014-03-04 00:052014-05-07 18:10
ngarcia 
AtulOpenbravo 
urgentmajoralways
closedfixed 
5
 
3.0PR14Q33.0PR14Q3 
ngarcia
Core
No
0025886: When posting a payment using credit and multi-currency, Bank Revaluation Gain and Loss Accounts are used at the same time
When posting a payment using credit and multi-currency, Bank Revaluation Gain and Loss Accounts are used at the same time
As 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
No tags attached.
depends on defect 0025895 closed Sandrahuguet Is impossible to pay a invoice with generated credit 
Issue History
2014-03-04 00:05ngarciaNew Issue
2014-03-04 00:05ngarciaAssigned To => jonalegriaesarte
2014-03-04 00:05ngarciaModules => Core
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