IMPORTING FILES

Importing files is a quick way of getting data from one system, possibly manipulating it in a third party software and reimporting into CONTROL. The import must adhere to the following headings

STOCK FILE IMPORT

• Stock Number
• Description
• Comment
• Category (Dept/Sub-department)
• Supplier 1,
• Supplier 1 Product Code,
• Supplier Cost in supplier currency
• Duty %
• Other Charges (amount or % of supplier cost in local currency)
• Landed Cost
• Current Sell Price (Inc GST)
• Price Level 1
• Price Level 2
• Price Level 3
• Price Level 4
• Unit (assume buy unit = sell unit, etc.)
• Barcode Number
• Quantity on hand
• Minimum,
• Maximum
• On Internet (y/n)
• Weight
• Volume
• Size run,
• Parent,
• Colour,
• Size

CREDITORS IMPORT

• Supplier code
• main_contact
• main_addr1
• main_addr2
• main_city
• main_state
• main_postcode
• main_country
• main_phone
• main_fax
• main_email
• other_addr1
• other_addr2
• other_city
• other_state
• other_postcode
• abn

CUSTOMERS IMPORT

• Customer Code
• First Name
• Last Name
• Customer Name (Business name or Full Customer name)
• Address 1
• Address 2
• State
• Postcode
• Country
• Main Phone
• A/H Phone
• Mobile Phone
• Fax Number
• Contact
• Group 1
• Group 2

DEPARTMENT

• Department ID
• Department Name

Category

• Department ID
• Category ID
• Category Name