This section is for the File Exports provides some useful exports from the system
...
HMRC Export
This screen is used to export the HMRC file Types - Tax Codes, Commodity Code and Quota/Preferences as a CSV format to the user email address
...
allows you to audit the commodity code and tax codes on the system, and is sometimes requested by the customs authority as well for them to audit your system.
You can chose one or all of the sets of data, all produce CSV reports
Tax Code export
Commodity Code export
Quota / Preferences export
...
Locations Export
If you want to maintain your locations pick routine or simply want a copy of the warehouse locations then you can use this export.
Warehouse Locations are exported as a CSV format and sent to the user email address
...
| Note |
|---|
If you use location check digits, you MUST export the check digits and reimport them. If they are not in the import file the system will recalculate the check digits on import. |
You can use this for the import file for the CREATE → Locations → Import option
Stock Audit Export
A stock audit is to find out all the details about a product between a period of time, the audit is a substantial report which is produced in CSV format, and contains the stock inbound information along with where every item was sent to.
Consider using a date selection in this format as the file contains many fields.
...
This report is not limited in its output nor the information you can request however sometimes it will not work because you have simply asked for too much data at one time.
If you only specify a customer/site then start the date range from one week upwards, smaller customers you may manage three months, larger customers maybe only one week.
If you specify customer/site & product then you are generally safe to start at 3 months and you may be able to get upto 3 years' worth of data.
The limits on this are SQL server memory and the output to CSV abilities.
| Note |
|---|
CSV will not support Non-Latin Characters |