|
Size: 1280
Comment:
|
Size: 1429
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 7: | Line 7: |
| * Comment | |
| Line 10: | Line 11: |
| * 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.) |
|
| Line 11: | Line 21: |
| * Cost * Current Sell Price (Inc GST) * Unit (assume buy unit = sell unit, etc.) |
|
| Line 20: | Line 27: |
| * Size run, | |
| Line 23: | Line 31: |
| Line 42: | Line 49: |
| Line 60: | Line 66: |
| Line 64: | Line 69: |
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 %
- 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