Note: If your franchise does not use this program, the menu option may not be visible. This help system contains standard information, some of which might not apply to your franchise. Click the Help button on the relevant forms or menus to see any existing help file specific to your Autoline configuration for that form or menu. Alternatively, a help file may exist in the help system specific to your manufacturer.
Under normal circumstances, Autoline can keep VAT codes and VAT rates in the NOMINAL LEDGER module VAT Options. But there, we can find more than one VAT code with the same VAT rate. Moreover, import files from your manufacturer may only provide VAT as a rate. In that case, you can map the VAT rate to an Autoline VAT code. This program lets you do that.
You keep the relation between the VAT rate and the VAT codes in the VAT Rate Mapping table, 00.MS.aivvm.sq. The import file of a franchise can have the VAT rate on each parts record. This file lets you get the VAT code to be used to populate the standard files in Purchase Invoice Verification.
The VAT rate mapping table must be populated manually via View VAT Rate Mapping before start-up before you upload the source data file from the manufacturer.
After you have started the program and clicked Upload, the program checks whether the table, [Franchise mnemonic].MS.aivvm.sq, exists. If the table does not exist, the program creates it. You are warned to populate the table before trying to upload the source data file again. The following error message is displayed because the table [XX].MS.aivvm.sq is empty. You must therefore type in the records manually:
(See also: Troubleshooting).No records found in the VAT Rate mapping file. Populate the file before uploading file.
To map the manufacturer VAT rate to an Autoline code:
Before you upload the source data file from the manufacturer, select View VAT rate mapping from the PURCHASE INVOICE VERIFICATION MENU.
The PIV Vat Rate Mapping form is displayed.
Click Create, type in the VAT Rate (RATE) and VAT Code (VATCODE), then click Save.
The details are saved.
You can then select Purchase invoice verification from the PURCHASE INVOICE VERIFICATION MENU, select the Stock Management Company number if prompted, then click Upload on the Parts Invoice Verification form. (Also, click this link for help about the PIV form, to proceed with importing and converting the manufacturer source data file.)
VAT rate (RATE): Manufacturer VAT rate to be mapped to the Autoline VAT code.
VAT code (VATCODE): Autoline VAT code to which the manufacturer VAT Rate is to be mapped.