|
Size: 1293
Comment:
|
Size: 1779
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| 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 * Size run, * Parent/Style number (this and next two columns are only valid for "child" items), * Colour, * Size |
| Line 41: | Line 36: |
| 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 * 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 |
| Line 80: | Line 55: |
| * 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 |
|
| Line 81: | Line 72: |
| = DEPARTMENT = * Department ID * Department Name |
|
| Line 82: | Line 76: |
| 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 |
= Category = * Department ID * Category ID * Category Name |
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