Additional Reporting Currency (ACY) (Bevica Power BI)

Report Bevica Power BI values in Additional Reporting Currency (ACY).

Additional Reporting Currency (ACY) (Bevica Power BI)

This applies to Bevica Power BI versions from June 2023 onwards

Where you use Additional Reporting Currencies in Bevica you can report on these in Power BI.

Overview

Business Central ACY postings in the Value Entries are only calculated for the Cost Amounts. The ACY postings also include revaluations to account for the difference in exchange rates from the source item ledger entry.

The Power BI report calculates Cost and Sales Amounts using the prevailing FX rate based on the transactions Posting Date.

ACY calculations for the following posted transactions are available. Note that each measure follows the standard costing mechanism of:

• Actual
• Expected
• Non Invtbl
• Inventory = Actual + Expected
• All = Actual + Expected + Non Invtbl (NB: some values do not have a 'Non Invntbl' cost so 'All' is used instead of 'Inventory')

Source Table	Name	Comments
Item Ledger Entries	Inventory Cost ACY	Cost Amount converted to ACY
	Purchase Amount ACY	Purchase Amount converted to ACY
	Sales ACY	Sales Amount converted to ACY
	Cost of Sales ACY	Sales Cost converted to ACY
	Margin ACY	Sales ACY - Cost of Sales ACY
	Sales Discount Amount ACY