Export

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 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

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.

CSV will not support Non-Latin Characters