Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0038339Openbravo ERP09. Financial managementpublic2018-04-11 18:322019-05-21 15:16
normalmajorhave not tried
0038339: Multicurrency customer statement report
This feature improves the Customer Statement report adding a new parameter "Multicurrency". In case of unchecked the report generated will be the current report but in case of checked it will group records based on the currency records and display original currency amounts instead of ledger currency amounts.
No tags attached.
related to defect 00405053.0PR19Q3 closed adrianromero API change: New parameters in Customer Statement report 
related to defect 00405063.0PR19Q3 closed adrianromero API change: Adding private constructor in ReportsUtility class 
diff customerstatement.diff (29,822) 2019-03-15 13:54
Issue History
2018-04-11 18:32adrianromeroNew Issue
2018-04-11 18:32adrianromeroAssigned To => adrianromero
2018-04-11 18:32adrianromeroModules => Core
2018-04-11 18:32adrianromeroTriggers an Emergency Pack => No
2018-04-11 18:33adrianromeroStatusnew => scheduled
2019-03-13 12:54adrianromeroFile Added: customerstatement (1).export
2019-03-15 13:54adrianromeroFile Deleted: customerstatement (1).export
2019-03-15 13:54adrianromeroFile Added: customerstatement.diff
2019-03-21 10:27dmiguelezNote Added: 0110533
2019-03-27 14:51adrianromeroTarget Version => 3.0PR19Q3
2019-04-02 10:32adrianromeroRelationship addedrelated to 0040505
2019-04-02 10:38adrianromeroRelationship addedrelated to 0040506
2019-04-17 12:23hgbotCheckin
2019-04-17 12:23hgbotNote Added: 0111185
2019-04-17 12:23hgbotStatusscheduled => resolved
2019-04-17 12:23hgbotResolutionopen => fixed
2019-04-17 12:23hgbotFixed in SCM revision => [^]
2019-04-17 12:27adrianromeroReview Assigned To => dmiguelez
2019-04-24 16:16dmiguelezNote Added: 0111286
2019-04-24 16:16dmiguelezStatusresolved => closed
2019-04-24 16:16dmiguelezFixed in Version => 3.0PR19Q3
2019-05-21 15:16hudsonbotCheckin
2019-05-21 15:16hudsonbotNote Added: 0111983

2019-03-21 10:27   
Test Plan:

Log in as F&B Admin

Go to Pice List Window and select Tarifa de Ventas Price List
Change the currency from EUR to USD and save

Go to Financial Account Window and select Caja Financial Account
Move to Payment Method Tab and select Al Contado
Check the flag Make Payments in Multiple Currencies and save

Go to Sales Invoice Window and crate a new record with:
  - Organization: España Región Norte
  - Business PartnerL Alimentos y supermercados
  - Price List: Tarifa de ventas
  - Payment Method: Al contado
Check in the header of the Invoice that the Currency is USD
Create a new line with:
  - Product: Cerveza Ale
  - Invoiced Quantity: 100
Complete the Invoice
Post the Invoice

Go to Customer Statement process and launch it with:
  - Report Type: Customer
  - Organization: F&B España Región Norte
  - General Ledger: F&B España, S.A. US/A/Euro
  - Business Partner: Alimentos y Supermercados
  - Starting Date: 01/01/2018
  - Ending Date: empty
  - Multicurrency: Yes
  - Sum Initial Balance: No
  - Ouput Type: Html

Check that the output of the Report is split in two by currencies (USD and EUR)
And each one has a different Initial Balance
2019-04-17 12:23   
Repository: erp/devel/pi
Changeset: b5f2a6f4813af2cb324ca58fa438fff4f1cd6086
Author: Adrián Romero <adrianromero <at>>
Date: Wed Mar 27 12:38:33 2019 +0100
URL: [^]

Fixes issue 38339: Customer Statement. Multicurrency

M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/
M src/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml
2019-04-24 16:16   
Code Review + Testing Ok
2019-05-21 15:16   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: [^]
Maturity status: Test