|
Size: 1293
Comment:
|
Size: 2408
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 2: | Line 2: |
| 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 | Importing files is a quick way of getting data from one system, possibly manipulating it with third party software and (re)importing into CONTROL. The data must have columns in the following sequence and all columns with data in them will be assumed to match the columns defined below. All columns defined below past the last column with actual data in the import file, will be given the currently defined "default value". |
| Line 5: | Line 5: |
| == Here are the fields currently supported on our standard stock import program. == Stock Number Description Category (Dept/Sub-department) Supplier 1, Supplier 1 Product Code, Barcode Number Cost Sell Price (Inc GST) Unit (assume buy unit = sell unit, etc.) Quantity on hand Minimum, Maximum Weight Volume Parent, Colour, Size |
* Stock/Style Number * Description * Comment * Category (Dept/Sub-department) * Supplier 1 * Supplier 1 Product Code, * Supplier 1 Cost in SUPPLIER'S currency * Last Supplier Cost in LOCAL 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 * Type (C = Consignment, D = discontinued, G = Gross (no qty), I = Inactive, M = Miscellaneous (fixed GP), S = scalable item, W = whole number only) * On Internet (y/n) * Weight * Volume * Colour palette * Size run * Parent/Style number (this and next two columns are only valid for "child" items) * Attribute * Colour * Size * Season |
| Line 41: | Line 38: |
| 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 |
* Supplier_code * Supplier_name * main_contact * main_addr1 * main_addr2 * main_addr3 (City, State, Postcode) * main_country * main_phone * main_fax * main_email * accounts_email * other_addr1 * other_addr2 * other_addr3 (City, State, Postcode) * Supplier_ABN * Supplier_Group * Payment_Type (E for eft, C for cheque) * BSB_Number * Account_Number * Credit Terms (in days) * Past End of Month * GL Sundry Invoice Expense Account |
| Line 80: | Line 61: |
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 Ph, Fax Number Contact Group 1 Group 2 DepartmentDepartment ID Department Name Category Department ID Category ID Category |
* Customer Code * First Name * Last Name * Title (Mr, Mrs, Miss, Dr, etc) * Customer Name (Business name or Full Customer name) * Address 1 * Address 2 * Address 3 (City, State) * Postcode * Zone (delivery zone or postcode) * Country (3 character country code) * Main Phone * A/H Phone * Mobile Phone * Fax Number * Email Address * Contact Person * Group 1 * Group 2 = CATEGORY/DEPARTMENT IMPORT = * Category ID (Category code including department prefix, or just department prefix) * Category Name |
IMPORTING FILES
Importing files is a quick way of getting data from one system, possibly manipulating it with third party software and (re)importing into CONTROL. The data must have columns in the following sequence and all columns with data in them will be assumed to match the columns defined below. All columns defined below past the last column with actual data in the import file, will be given the currently defined "default value".
STOCK FILE IMPORT
- Stock/Style Number
- Description
- Comment
- Category (Dept/Sub-department)
- Supplier 1
- Supplier 1 Product Code,
- Supplier 1 Cost in SUPPLIER'S currency
- Last Supplier Cost in LOCAL 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
- Type (C = Consignment, D = discontinued, G = Gross (no qty), I = Inactive, M = Miscellaneous (fixed GP), S = scalable item, W = whole number only)
- On Internet (y/n)
- Weight
- Volume
- Colour palette
- Size run
- Parent/Style number (this and next two columns are only valid for "child" items)
- Attribute
- Colour
- Size
- Season
CREDITORS IMPORT
- Supplier_code
- Supplier_name
- main_contact
- main_addr1
- main_addr2
- main_addr3 (City, State, Postcode)
- main_country
- main_phone
- main_fax
- main_email
- accounts_email
- other_addr1
- other_addr2
- other_addr3 (City, State, Postcode)
- Supplier_ABN
- Supplier_Group
- Payment_Type (E for eft, C for cheque)
- BSB_Number
- Account_Number
- Credit Terms (in days)
- Past End of Month
- GL Sundry Invoice Expense Account
CUSTOMERS IMPORT
- Customer Code
- First Name
- Last Name
- Title (Mr, Mrs, Miss, Dr, etc)
- Customer Name (Business name or Full Customer name)
- Address 1
- Address 2
- Address 3 (City, State)
- Postcode
- Zone (delivery zone or postcode)
- Country (3 character country code)
- Main Phone
- A/H Phone
- Mobile Phone
- Fax Number
- Email Address
- Contact Person
- Group 1
- Group 2
CATEGORY/DEPARTMENT IMPORT
- Category ID (Category code including department prefix, or just department prefix)
- Category Name