|
Size: 2652
Comment:
|
Size: 2009
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: |
| * Stock Number | * Stock/Style Number |
| Line 11: | Line 11: |
---- /!\ '''Edit conflict - other version:''' ---- * Supplier Cost (in supplier currency) * Duty % * 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 ---- /!\ '''Edit conflict - your version:''' ---- * Supplier Cost in supplier currency |
* Supplier 1 Cost in SUPPLIER'S currency * Last Supplier Cost in LOCAL currency |
| Line 36: | Line 23: |
---- /!\ '''End of edit conflict''' ---- |
|
| Line 41: | Line 26: |
| * Type (C = Consignment, D = discontinued, G = Gross (no qty), I = Inactive, M = Miscellaneous (fixed GP), S = scalable item, W = whole number only) | |
| Line 45: | Line 31: |
---- /!\ '''Edit conflict - other version:''' ---- * Size run, ---- /!\ '''Edit conflict - your version:''' ---- ---- /!\ '''End of edit conflict''' ---- * Parent, |
* Parent/Style number (this and next two columns are only valid for "child" items), |
| Line 56: | Line 35: |
| ---- /!\ '''Edit conflict - other version:''' ---- ---- /!\ '''Edit conflict - your version:''' ---- ---- /!\ '''End of edit conflict''' ---- |
|
| Line 80: | Line 54: |
| ---- /!\ '''Edit conflict - other version:''' ---- ---- /!\ '''Edit conflict - your version:''' ---- ---- /!\ '''End of edit conflict''' ---- |
|
| Line 103: | Line 72: |
| ---- /!\ '''Edit conflict - other version:''' ---- ---- /!\ '''Edit conflict - your version:''' ---- ---- /!\ '''End of edit conflict''' ---- |
|
| Line 112: | Line 76: |
| ---- /!\ '''Edit conflict - other version:''' ---- ---- /!\ '''Edit conflict - your version:''' ---- ---- /!\ '''End of edit conflict''' ---- |
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
- Size run,
- Parent/Style number (this and next two columns are only valid for "child" items),
- 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