UT System Scripts

You can use these Intrastat/EC Sales system scripts:

1. IEC Load/Update setup data.

   The CSV formats are:

   • IEC_LoadCommodityCodes.csv:

     Code, Description, Use for Intrastat Reporting, Show Net Mass, Show Supplementary Units, Inventory Unit of Measure.

   • IEC_LoadDeliveryTerms.csv:

     Code, Description.

   • IEC_LoadNoTC.csv:

     Code, Description, Reverse sign for reporting, Exclude from a file.

2. IEC Load/Update setup data for masterfile.

   The CSV formats are:

   • IEC_updateCustomers.csv:

     Code, Invoice NoTC, Credit Note NoTC, Invoice Delivery Terms, Return Delivery Terms.

   • IEC_updateCustomersDeliveryAddresses.csv:

     Code, Address #, Invoice NoTC, Credit Note NoTC, Invoice Delivery Terms, Return Delivery Terms.

   • IEC_updateSuppliers.csv:

     Code, Invoice NoTC, Credit Note NoTC, Invoice Delivery Terms, Return Delivery Terms.

   • IEC_updateInventoryItems.csv:

     Code, Commodity Code, Net Mass, EC Sales Indicator.

   • IEC_updateFixedAssets.csv:

     Code, Commodity Code, Net Mass.

   • IEC_updateNSPurchaseCodes.csv:

     Code, SubCode, Commodity Code, Net Mass.

   • IEC_updateNSSalesCodes.csv:

     Code, Commodity Code, Net Mass, EC Sales Indicator.

   • IEC_updateJCActivityCodes.csv:

     Code, Commodity Code, Net Mass.

   • IEC_updateJCSalesCodes.csv:

     Code, Commodity Code, Net Mass, EC Sales Indicator.