This section provides some useful exports from the system
...
HMRC Export
This allows you to audit the commodity code and tax codes on the system, and is sometimes requested by the customs authority as well for the File Exports from the system
...
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 select a single day, smaller customers you may manage one week or more at a time
If you specify customer/site & product then you are generally safe to request a month at a time and for some low volume products 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 |