In this release, Expedient has introduced a load function that enables users to create/update/delete export TLF via the load process.
The function can be accessed via the path below. You can load the TLF file by csv, xls or xlsx format.
Forwarding -> Export Air -> Tools -> Load Export TLF File
Forwarding -> Export Sea -> Tools -> Load Export TLF File
Features
- The process allows you to have a column heading. If you contain a column heading on the load file, the process will ignore line 1 (column heading line).
- The process is able to assign a new TLF code automatically when TLF record is created. In order to do that, you have to ensure the “Auto generate TLF code” option is clicked. The TLF will be created with the format “Tariff Head + 3 characters”. e.g. 3919AAB.
- You can create your own load template by
- clicking “Edit” and modify the template
- clicking “OK” to go to the main Load screen.
- clicking “Save” or “Save As” to save your template.
-
- The process will validate the following fields and automatically add “leading 0” if it’s not included on the file.
- AHECC
| The field in Load Screen | The field in TLF Masterfile | Mandatory/Optional | Mapping Rules |
| *TLF Code | Export TLF | Mandatory | Max 7 characters are allowed as TLF Code. No space or special characters are allowed on the field. |
| *TLF Description | Description | Mandatory | This is a free text field. |
| *AHECC | AHECC Code | Mandatory | The process validates AHECC. Only the valid AHECC (The value is in the customs reference file) is allowed to load into TLF Masterfile. The field will ignore any space or special characters, and also the process will add “leading 0” if it’s not included on the load file. |
| Approved By | Approved | Optional | You can enter approved user on the field. |
| Approved Date | Date | Optional | You can enter the approved date on the field. The following date format is accepted. DD/MM/YYYY (With or without leading 0 on Day or Month) DD/MM/YY (With or without leading 0 on Day or Month) DD-MM-YYYY (With or without leading 0 on Day or Month) DD-MM-YY (With or without leading 0 on Day or Month) |
| Delete TLF Indicator | Optional | When the value is (Y)es, the process will delete TLF Record. |