VAT report for a specific VAT regime currency
We have a requirement to generate a VAT report for a specific VAT regime currency (e.g., DKK), with potential extension to additional currencies in the future.
For example, if an invoice is entered in USD (functional currency of the BU) but is associated with a VAT regime configured for DKK, we need the VAT report to display the tax amounts converted into DKK.
We are aware that configuring a reporting currency could address this; however, we would prefer to avoid this approach as there may be a need to support multiple VAT regime currencies going forward.
Could you advise on the best approach in Oracle Cloud to achieve VAT reporting in the VAT regime currency when transactions are recorded in different currencies, without relying on reporting currency configuration?