|
⇤ ← Revision 1 as of 2007-05-11 05:52:39
Size: 1293
Comment:
|
Size: 1276
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 75: | Line 75: |
| Line 80: | Line 76: |
| Line 114: | Line 108: |
| DEPARTMENT | |
| Line 120: | Line 114: |
Category |
'''Category ''' |
| Line 131: | Line 121: |
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
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
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 Ph,
Fax Number
Contact
Group 1
Group 2
DEPARTMENT
Department Name
Category
Department ID
Category ID
Category