Internationalization Enhancements
Golden Tax Enhancements
There have been several enhancements to Golden Tax:
• Remove the blocking of the operational process that happened in earlier versions
• Golden Tax Invoice File Create
• Golden Tax Browse and Report
• Payment of Golden Tax Invoices
• AR reports for Golden Tax Invoices
Note: The full functionality is available as of QAD 2014 EE Patch 3 by installing a Financials patch and operational program updates.
Removing the Blocking of the Operational Process
Golden Tax invoice data is generated when an invoice is posted by the following programs:
• Invoice Post and Print (7.13.4)
• Pre-Shipper/Shipper Confirm (7.9.5)
• Shipper Unconfirm (7.9.21)
Therefore, the Golden Tax workflow can be processed without blocking any SO shipments.
Golden Tax invoice File Create
You can export the Golden Tax invoice file in CSV as well as TXT format. The activity now happens at entity level, rather than at domain level.
Golden Tax Browse and Report
An enhanced browse and report are available for Golden Tax:
• Golden Tax Invoice Browse (7.13.20.1.4)
• Golden Tax Invoice Report (7.13.20.1.6)
Obsolete Golden Tax Program
Pending Invoice Extract (7.13.20.1.1) is now obsolete.
Customer Invoice Modify
In the customer invoice, the system keeps track of the Golden Tax invoice numbers associated with the QAD invoice. After loading the Golden Tax file back into QAD, the VAT Invoice numbers (the real Golden Tax invoice numbers) become available on the Operational Info Tab. You can optionally update or input the Golden Tax invoice number manually.
Payment of Golden Tax Invoices
In the payment programs listed below, you can now search invoices based on the Golden Tax invoice number by entering the Golden Tax invoice number in the Shipper field:
• Customer Payment Create (27.6.4.1)
• Banking Entry Create (31.1.1) / Petty Cash Create (31.2.1)
• Open Item Adjustment Create (25.13.5)
AR Reports for Golden Tax
Several reports have the Golden Tax invoice number available in the data set so that it can be added to the report by customization. For the AR module:
Customer Invoice Extended View
In Customer Invoice Extended View (27.18.4), you can search the Golden Tax invoice number to find the related QAD invoice. There is a Shipper Number column to show the Golden Tax invoice number.
Customer Activity Dashboard
In Customer Activity Dashboard (27.18.1), on the Invoice tab, a new Shipper field (hidden by default) contains the customer shipper ID, legal document ID, or Golden Tax invoice number.
Other AR Reports
The Golden Tax invoice number field is available in the data set of the following programs, so that it can be made visible through customization:
• Customer Aging Analysis History (27.17.7)
• Reminder Letter (27.17.10)
• Customer Reminder Overview (27.17.11)
• Customer Statement of Account (27.17.19)
ERS Processor
In Brazil, companies need to create supplier invoices from legal documents. When this process takes place automatically, accounting entries are created immediately and the user saves the time spent performing the step manually.
When a user creates a legal document, ERS runs automatically to process the lines on the legal document when it is confirmed and create a supplier invoice. This process has been implemented for the following programs:
• Fiscal Confirmation (5.20.2)
• Fiscal Receiving (5.20.1)
• Purchase Order Returns (5.13.7)
• Purchase Order Receipts (5.13.1)
In ERS Control (28.10.24), four fields enable you to auto run ERS in these four programs. When you select these fields and run the relevant program, an information message is displayed to inform you that ERS will run automatically on confirmation of a legal document. The messages in each program are the same.
When you click Yes, the legal document is sent to the ERS processor. When complete, a message is displayed informing you that the supplier invoice has been created. You can view the invoice in Supplier Invoice View.
This approach ensures that Periodic Costing values inventory correctly.
Legal Document Number in Reports and Views
In Brazil, transportation of merchandise requires a document to prove legality and possession of the inventory being moved. Legal documents include shipping information, such as item and tax. Legal documents are generated along with the shipper.
The legal document number needs to be shown in some AR financial reports and stored in related GL transaction posting lines.
In Simultaneous Operation Maintenance (7.10.13), two legal documents are created for a single shipper separately. One is the sales legal document and the other is the shipping legal document. Both legal documents are posted to the invoice and posting lines.
Legal document numbers are available in the following programs:
• Customer Payment Selection Create (27.6.4.6)
• Customer Payment Selection Modify (27.6.6.6)
• Customer Payment Selection View (27.6.6.7)
• Customer Open Item Report (27.17.1)
• Customer Open Item Basic Report (27.17.15)
• Customer Invoice Activity View (27.18.2)
For these programs, the legal document number is added in the Shipper field. New layouts of these programs are also available. These new layouts contain the LD suffix in the name; for example, Customer Open Item Report - LD. When there are multiple legal documents for the same invoice, they can be listed as a comma-separated list. The Excel layout also has an LD variant.
Legal document numbers are also available in the following GL transaction reports and views:
• Customer Account Activity (27.17.3)
• GL Transaction Report (25.15.1.1)
• GL Transactions by Account (25.15.1.2)
• GL Transactions by Sub-Account 25.15.1.3)
• GL Transactions by Daybook (25.15.1.4)
• GL Transactions View (25.15.2.1)
• GL Transactions by Sub-Account View (25.15.2.3)
• GL Transactions View Extended (25.15.2.10)
• Cost Center Trans Detail Report (25.15.3.2)
• Project Trans Detail Report (25.15.3.4)
• Transactions by Cost Center View (25.15.4.2)
• Transactions by Project View (25.15.4.3)
Withholding Tax
There are three withholding tax enhancements in QAD 2015 EE.
• Due to a requirement in Thailand, you can now configure a domain to post withholding tax when a payment of an invoice is created and set to For Collection, rather than when the invoice is paid. If the payment bounces, then the withholding tax posting automatically reverses. This is also the case for payment selections that are unconfirmed.
• You can now make cross-company payments for invoices with withholding tax regardless of the exchange rate shared sets. Supplier Payment Selection Create (28.9.4.1) and Customer Payment Selection Create (27.6.4.6) allow you to search for invoices in all entities, regardless of the domain shared set.
• You can now create manual entries on withholding tax accounts using withholding tax codes to close off withholding tax balances or register payments of withholding tax to the government. This manual withholding tax settlement can apply to the following programs:
• Journal Entry Create (25.13.1.1)
• Banking Entry Create (31.1.1)
• Petty Cash Create (31.2.1)
• Open Item Adjustment Create (25.13.5)
Alternate Description for AP Tax Register
Due to a new legal requirement in Italy, it is now necessary to display an alternate description for EU tax registers in the EU Sales Linked to EU Purchases (29.6.3.14) report. A new field in Tax Register Create (29.1.16), Alternate Description, allows you to provide an alternate description for a tax register.
Currency-Dependent Rounding
A few countries have currencies with three decimals; for example, the Jordanian dinar, the Tunisian dinar, and the Omani rial. Beginning with QAD 2015 EE, the system correctly calculates and displays amounts expressed in currencies with three decimals from transaction creation to report generation. You can input amounts with three decimals in fields and view amounts accurately displayed in the forms, browses, and reports.
The limitations of currency-dependent rounding support are as follows:
• The logistics accounting module is not included.
• For add-on products included in the Compatibility Guide, please contact QAD if you require support for currency-dependent rounding.
• Amounts in transaction currency are not shown with three decimals in Financials reports that use Crystal Reports.
• Not all Fixed Assets reports display the third decimal where the third decimal is zero.
Note: The Customer Management QRF Reports package is available at the end of March 2015. You need to install this package into your QAD 2015 EE environment to have Customer Management Reports that support currency-dependent rounding.
Financial Translation Maintenance
You can maintain label and message translations in the financial programs by using Financial Translation Maintenance (36.24.10). This program enables you to:
• Search for financial translations using different filters.
• Edit original translations while keeping a record of the original.
The program also marks a record as updated when it is modified and records the last modified user ID and date.