Only if multi-currency functionality is enabled, your reports will display correct data if you have events in different currencies.
Reports in pixi Reports application
The table below includes all standard reports that were changed in AVA Update 7 (multi-currency), with the explanation in which currency the results are displayed.
Customized reports could also be affected if they use the same database stored procedure as standard reports.
Report group |
Report name |
Report currency |
Exchange rate |
Accounting |
Customer Account Cash Flow |
Home currency (or shop currency, if "shop" is provided as a parameter) |
Exchange rate is taken from the events in the customer account. |
Deleted Invoices / Credits |
Order currency |
The report does not re-calculate the values. |
|
International VAT* |
Home currency |
For the VAT limit, it takes the current exchange rate. For the "net total" it takes the exchange rates from the included invoices. |
|
Invoices/Credits |
Home currency (or shop currency, if "shop" is provided as a parameter) |
Exchange rates from the included invoices are used. |
|
Turnover by Payment Type |
Home currency (or shop currency, if "shop" is provided as a parameter) |
Exchange rates from the included invoices are used. |
|
Customer Service |
Customer Account Cash Flow Controlling |
Home currency (or shop currency, if "shop" is provided as a parameter) |
Exchange rate is taken from the events in the customer account. |
Customer Account Turnover Controlling |
Shop currency |
Exchange rates from the included invoices are used. |
|
Customer Orders For Period |
Shop currency |
Totals of included orders are recalculated into the currency of the concerning shop. |
|
New Customers |
Home currency (or shop currency, if "shop" is provided as a parameter) |
Exchange rates from the included invoices are used. |
|
Not Paid Invoices List |
Shop currency |
Exchange rates from the included invoices are used. |
|
Logistics |
Bin Takeouts for Location |
Shop currency |
Prices of the included items are recalculated into the currency of the concerning shop, using the exchange rates from invoices. |
Sales |
Gross Profit |
Home currency (or shop currency, if "shop" is provided as a parameter) |
Exchange rates from the included invoices are used. |
Gross Profit Hist |
Home currency (or shop currency, if "shop" is provided as a parameter) |
Exchange rates from the included invoices are used. |
|
Order Size Distribution |
Home currency |
Exchange rates from the included invoices are used. |
|
Turnover by Categories |
Home currency (or shop currency, if "shop" is provided as a parameter) |
Exchange rates from the included invoices are used. |
|
Turnover By Categories Overview |
Home currency |
Exchange rates from the included invoices are used. |
|
Turnover by Customers |
Shop currency |
Exchange rates from the included invoices are used. |
|
Turnover by Items |
Home currency (or shop currency, if "shop" is provided as a parameter) |
Exchange rates from the included invoices are used. |
|
Turnover by Items Variants |
Home currency (or shop currency, if "shop" is provided as a parameter) |
Exchange rates from the included invoices are used. |
|
Turnover by Suppliers |
Home currency (or shop currency, if "shop" is provided as a parameter) |
Exchange rates from the included invoices are used. |