|
Size: 1276
Comment:
|
Size: 2652
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 |
* Stock Number * Description * Comment * Category (Dept/Sub-department) * Supplier 1, * Supplier 1 Product Code, |
| Line 8: | Line 12: |
| Description | ---- /!\ '''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 |
| Line 10: | Line 24: |
| Category (Dept/Sub-department) | ---- /!\ '''Edit conflict - your version:''' ---- * Supplier Cost in supplier 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 |
| Line 12: | Line 37: |
| Supplier 1, | ---- /!\ '''End of edit conflict''' ---- * Quantity on hand * Minimum, * Maximum * On Internet (y/n) * Weight * Volume * Size run, |
| Line 14: | Line 46: |
| Supplier 1 Product Code, | ---- /!\ '''Edit conflict - other version:''' ---- * Size run, |
| Line 16: | Line 49: |
| Barcode Number | ---- /!\ '''Edit conflict - your version:''' ---- |
| Line 18: | Line 51: |
| Cost | ---- /!\ '''End of edit conflict''' ---- * Parent, * Colour, * Size |
| Line 20: | Line 56: |
| Sell Price (Inc GST) | ---- /!\ '''Edit conflict - other version:''' ---- |
| Line 22: | Line 58: |
| Unit (assume buy unit = sell unit, etc.) | ---- /!\ '''Edit conflict - your version:''' ---- |
| Line 24: | Line 60: |
| Quantity on hand | ---- /!\ '''End of edit conflict''' ---- = 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 |
| Line 26: | Line 80: |
| Minimum, | ---- /!\ '''Edit conflict - other version:''' ---- |
| Line 28: | Line 82: |
| Maximum | ---- /!\ '''Edit conflict - your version:''' ---- |
| Line 30: | Line 84: |
| Weight | ---- /!\ '''End of edit conflict''' ---- = 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 |
| Line 32: | Line 103: |
| Volume | ---- /!\ '''Edit conflict - other version:''' ---- |
| Line 34: | Line 105: |
| Parent, | ---- /!\ '''Edit conflict - your version:''' ---- |
| Line 36: | Line 107: |
| Colour, | ---- /!\ '''End of edit conflict''' ---- = DEPARTMENT = * Department ID * Department Name |
| Line 38: | Line 112: |
| Size | ---- /!\ '''Edit conflict - other version:''' ---- |
| Line 40: | Line 114: |
| = CREDITORS IMPORT = Supplier code |
---- /!\ '''Edit conflict - your version:''' ---- |
| Line 43: | Line 116: |
| 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 Ph, Fax Number Contact Group 1 Group 2 DEPARTMENT DepartmentDepartment ID Department Name '''Category ''' Department ID Category ID Category |
---- /!\ '''End of edit conflict''' ---- = 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 Number
- Description
- Comment
- Category (Dept/Sub-department)
- Supplier 1,
- Supplier 1 Product Code,
![/!\](/mywiki/moin_static197/modernized/img/alert.png "/!\"){kind=small}
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
- 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
End of edit conflict
- Quantity on hand
- Minimum,
- Maximum
- On Internet (y/n)
- Weight
- Volume
- Size run,
Edit conflict - other version:
- Size run,
Edit conflict - your version:
End of edit conflict
- Parent,
- Colour,
- Size
Edit conflict - other version:
Edit conflict - your version:
End of edit conflict
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
Edit conflict - other version:
Edit conflict - your version:
End of edit conflict
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
Edit conflict - other version:
Edit conflict - your version:
End of edit conflict
DEPARTMENT
- Department ID
- Department Name
Edit conflict - other version:
Edit conflict - your version:
End of edit conflict
Category
- Department ID
- Category ID
- Category Name