EXPEDIENT SOFTWARE

Going beyond software performance.

Product Stewardship (AU)

The Product Stewardship reports provide a breakdown of the shipments per client of specific television and computer tariff codes. Product Stewardship reports are within the Customs folder..

Applicable Clients/Parts CSV

This report lists the clients who have shipped television and computer tariff codes over the last two years. The report can be filtered to a specific Client and Supplier. 

Historical Quantities

This report lists the quantities per client shipped of the television and computer tariff codes within the selected Lodgement Date range and sorted into Financial Year. The original Lodgement Date is used for each entry. This report can be filtered to a specific client.

Maintenance

This screen allows users to add and update the Tariff Stat combinations, Conversion Factor and the validity dates for the Conversion Factors.

The toolbar button allows you to output the contents of the screen to a spread sheet. Any update to the information can be entered in a CSV file.

The updated CSV file can then be loaded back into the Maintenance screen by Updating and using the toolbar button. This will output a file that matches the format required to load Product Stewardship data into Expedient.

To load a file of Product Stewardship Tariff and Stats the following file format must be used

  • A comma separated values (.csv) file (easily created in Microsoft Excel)

The data must be in the following order: 

Column Description Validation Field Format
A Tariff Mandatory General
B Stat Mandatory General
C Conversion Factor Optional General
D Effective from Optional Date
E Effective to Optional Date

Some file examples:

“22030069”,”20″,3,13/06/2013,”14/05/2013″

“8443310”,”61″

Updated: March 28, 2016 — 10:43 pm
EXPEDIENT SOFTWARE GUIDE © 2015