Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 09. Financial managementmajorhave not tried2018-04-11 18:322019-05-21 15:16
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PrioritynormalResolutionfixedFixed in Version3.0PR19Q3
StatusclosedFix in branchFixed in SCM revisionb5f2a6f4813a
ProjectionnoneETAnoneTarget Version3.0PR19Q3
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0038339: Multicurrency customer statement report

DescriptionThis 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.
Steps To ReproduceN/A
TagsNo tags attached.
Attached Filesdiff file icon customerstatement.diff [^] (29,822 bytes) 2019-03-15 13:54 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00405053.0PR19Q3 closedadrianromero API change: New parameters in Customer Statement report 
related to defect 00405063.0PR19Q3 closedadrianromero API change: Adding private constructor in ReportsUtility class 

-  Notes
dmiguelez (developer)
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
hgbot (developer)
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
dmiguelez (developer)
2019-04-24 16:16

Code Review + Testing Ok
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2018-04-11 18:32 adrianromero New Issue
2018-04-11 18:32 adrianromero Assigned To => adrianromero
2018-04-11 18:32 adrianromero Modules => Core
2018-04-11 18:32 adrianromero Triggers an Emergency Pack => No
2018-04-11 18:33 adrianromero Status new => scheduled
2019-03-13 12:54 adrianromero File Added: customerstatement (1).export
2019-03-15 13:54 adrianromero File Deleted: customerstatement (1).export
2019-03-15 13:54 adrianromero File Added: customerstatement.diff
2019-03-21 10:27 dmiguelez Note Added: 0110533
2019-03-27 14:51 adrianromero Target Version => 3.0PR19Q3
2019-04-02 10:32 adrianromero Relationship added related to 0040505
2019-04-02 10:38 adrianromero Relationship added related to 0040506
2019-04-17 12:23 hgbot Checkin
2019-04-17 12:23 hgbot Note Added: 0111185
2019-04-17 12:23 hgbot Status scheduled => resolved
2019-04-17 12:23 hgbot Resolution open => fixed
2019-04-17 12:23 hgbot Fixed in SCM revision => [^]
2019-04-17 12:27 adrianromero Review Assigned To => dmiguelez
2019-04-24 16:16 dmiguelez Note Added: 0111286
2019-04-24 16:16 dmiguelez Status resolved => closed
2019-04-24 16:16 dmiguelez Fixed in Version => 3.0PR19Q3
2019-05-21 15:16 hudsonbot Checkin
2019-05-21 15:16 hudsonbot Note Added: 0111983

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker