CID (1281) To Print Total Invoice Tax Amount In Site Currency In Invoice Prints

Reference No: AHI-27

Version No: 06.01.03-00

The current feature has been converted into a custom enhancement for a specific business requirement.
The revised feature has been given in release 06.01.07-00 with Reference No: R2-15892.

Details

Support to print total Invoice Tax Amount in Site Currency in Invoice prints.

This is supported only when Multi-currency = True.
Total Invoice Tax Amount in Site Currency will be as per the Conversion Rate (1/Site to Transaction Currency) applicable for the date set in UDF named ‘Exchange Rate Date’.

CID	Description	Invoice Type
1281	Print total Invoice Tax Amount by tax rate in Site Currency in Invoice prints	All Types

Pre-requisites

Do the Form setup in the Maintenance Module.
Ensure Currency Conversion is set for Site Currency to Transaction Currency. (Path: Configuration > Multi Currency > Currency Conversion Setup).

In Accounts module, add the items, enter Unit Price and discount (if needed) for each item line in the order.

Ensure to tag Tax region (20% tax is considered for the sample workflow).

Invoice the order.
In the Invoicing module, enter the UDF, ‘Exchange Rate Date’ value for the generated Invoice.

CID 1281 always looks for Conversion Rate applicable for the Date set in respective invoice UDF named ‘Exchange Rate Date’ to print.

Add the invoice to a batch and then post the batch.
In Accounts module, Go to View > Invoices.
Search the Invoice and click Print button.
Select the form and then click the Print button.
Open the Invoice print and it displays the Total Invoice Tax in Site Currency using the Conversion Rate (1/Site Currency to Transaction Currency) as applicable for the Date set in respective invoice UDF named ‘Exchange Rate Date’.

Exchange Rate will be picked based on the Currency Conversion Table (Site: Transaction Currency)currency conversion (See Figure 1.0))
When multi-currency is not enabled, system prints blank.
When CID 1281 in Credit/Summary Credit memo, it prints in negative formatting of the Site Currency.
When Conversion Rate as applicable for the 'Exchange Rate Date' is blank or null, CID 1281 will print blank/no value.
CID 1281 rounds up the Site Tax Amount to 2 decimal places.
CID 1281 prints the Invoice Tax Amount in Site Currency of the invoice irrespective of the Currency chosen in Form Type Options dialog.
To ensure that the CID prints the Currency Symbol and Currency Formatting as per Site Currency following parameter has to be mentioned in 39th column OVERRIDE_CURRENCY_TYPE=SITE.
- This parameter can also have values like BASE/TRANSACTION, but it does not make sense to use these values for CID 1281 since the value it prints is always in Site Currency. It supported this for any future CID supports which would always print value in specific currency but not based on currency chosen in Form Type Options.
CID 1281 when used in summary invoices forms, it prints the invoice total tax of the Summary Invoice in Site Currency of Summary Invoice.