|
Size: 2652
Comment:
|
Size: 1779
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| 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 in a third party software and reimporting into CONTROL. The import must adhere to the following headings
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