Differences between revisions 6 and 23 (spanning 17 versions)
⇤ ← Revision 6 as of 2007-05-14 07:45:26 →
Size: 2652
Editor: bernie
Comment:
← Revision 23 as of 2008-09-22 05:39:08 → ⇥
Size: 2931
Editor: julius
Comment:
Deletions are marked like this. Additions are marked like this.
Line 2: Line 2:
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 Importing files is a quick way of getting data from one system, possibly manipulating it with third party software and (re)importing into CONTROL. The data must have columns in the following sequence and all columns with data in them will be assumed to match the columns defined below. All columns defined below past the last column with actual data in the import file, will be given the currently defined "default value".
Line 5: Line 5:
 * Stock Number  * Stock/Style Number
Line 8: Line 8:
 * Category (Dept/Sub-department)
 * Supplier 1,		  * Category (Dept/Sub-department - maximum of 8 characters)
 * Supplier 1 (supplier code - maximum of 8 characters)
Line 11: Line 11:

---- /!\ '''Edit conflict - other version:''' ----
 * Supplier Cost (in supplier currency)		  * Supplier 1 Cost in SUPPLIER'S currency
 * Supplier 2
 * Last Supplier Cost in LOCAL currency
Line 15: Line 15:
 * Other Charges (amount or % of supplier cost in local currency)
Line 17: Line 18:
 * Promotional Sell Price (Inc GST)
 * Promotional Start Date
 * Promotional End Date
Line 23: Line 27:

---- /!\ '''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''' ----
Line 39: Line 28:
 * Minimum,  * Minimum
Line 41: Line 30:
 * Type (C = Consignment, D = discontinued, G = Gross (no qty), I = Inactive, M = Miscellaneous (fixed GP), S = scalable item, W = whole number only)
 * Statistical / Temporary (should be marked as a S or T)
Line 44: Line 35:
 * Size run,  * Attribute Group
 * Colour palette
 * Size run
 * Parent/Style number (this and next two columns are only valid for "child" items)
 * Attribute
 * Colour
 * Size
 * Season
 * Rebate 1
 * Rebate 2
Line 46: Line 46:
---- /!\ '''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''' ----
Line 62: Line 47:
 * Supplier code  * Supplier_code
 * Supplier_name
Line 66: Line 52:
 * main_city
 * main_state
 * main_postcode		  * main_addr3 (City, State, Postcode)
Line 73: Line 57:
 * accounts_email
Line 75: Line 60:
 * other_city
 * other_state
 * other_postcode
 * abn

---- /!\ '''Edit conflict - other version:''' ----

---- /!\ '''Edit conflict - your version:''' ----

---- /!\ '''End of edit conflict''' ----		  * other_addr3 (City, State, Postcode)
 * Supplier_ABN
 * Supplier_Group
 * Payment_Type (E for eft, C for cheque)
 * BSB_Number
 * Account_Number
 * Credit Terms (in days)
 * Past End of Month
 * GL Sundry Invoice Expense Account
Line 89: Line 73:
 * Title (Mr, Mrs, Miss, Dr, etc)
Line 92: Line 77:
 * State  * Address 3 (City, State)
Line 94: Line 79:
 * Country  * Zone (delivery zone or postcode)
 * Country (3 character country code)
Line 99: Line 85:
 * Contact  * Email Address
 * Contact Person
Line 102: Line 89:
 * Credit Limit
 * Delivery Address 1
 * Delivery Address 2
 * Delivery Address 3
= CATEGORY/DEPARTMENT IMPORT =
 * Category ID (Category code including department prefix, or just department prefix)
 * Category Name
Line 103: Line 97:
---- /!\ '''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		 = GENERAL LEDGER IMPORT =
 * GL code
 * GL Description
 * Post / No post
 * P/L or B/S
 * Debit / Credit
 * Level
 * Prime Parent
 * Second Parent

IMPORTING FILES

Importing files is a quick way of getting data from one system, possibly manipulating it with third party software and (re)importing into CONTROL. The data must have columns in the following sequence and all columns with data in them will be assumed to match the columns defined below. All columns defined below past the last column with actual data in the import file, will be given the currently defined "default value".

STOCK FILE IMPORT

  • Stock/Style Number
  • Description
  • Comment
  • Category (Dept/Sub-department - maximum of 8 characters)
  • Supplier 1 (supplier code - maximum of 8 characters)
  • Supplier 1 Product Code,
  • Supplier 1 Cost in SUPPLIER'S currency
  • Supplier 2
  • Last Supplier Cost in LOCAL currency
  • Duty %
  • Other Charges (amount or % of supplier cost in local currency)
  • Landed Cost
  • Current Sell Price (Inc GST)
  • Promotional Sell Price (Inc GST)
  • Promotional Start Date
  • Promotional End Date
  • 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)
  • Statistical / Temporary (should be marked as a S or T)
  • On Internet (y/n)
  • Weight
  • Volume
  • Attribute Group
  • Colour palette
  • Size run
  • Parent/Style number (this and next two columns are only valid for "child" items)
  • Attribute
  • Colour
  • Size
  • Season
  • Rebate 1
  • Rebate 2

CREDITORS IMPORT

  • Supplier_code
  • Supplier_name
  • main_contact
  • main_addr1
  • main_addr2
  • main_addr3 (City, State, Postcode)
  • main_country
  • main_phone
  • main_fax
  • main_email
  • accounts_email
  • other_addr1
  • other_addr2
  • other_addr3 (City, State, Postcode)
  • Supplier_ABN
  • Supplier_Group
  • Payment_Type (E for eft, C for cheque)
  • BSB_Number
  • Account_Number
  • Credit Terms (in days)
  • Past End of Month
  • GL Sundry Invoice Expense Account

CUSTOMERS IMPORT

  • Customer Code
  • First Name
  • Last Name
  • Title (Mr, Mrs, Miss, Dr, etc)
  • Customer Name (Business name or Full Customer name)
  • Address 1
  • Address 2
  • Address 3 (City, State)
  • Postcode
  • Zone (delivery zone or postcode)
  • Country (3 character country code)
  • Main Phone
  • A/H Phone
  • Mobile Phone
  • Fax Number
  • Email Address
  • Contact Person
  • Group 1
  • Group 2
  • Credit Limit
  • Delivery Address 1
  • Delivery Address 2
  • Delivery Address 3

CATEGORY/DEPARTMENT IMPORT

  • Category ID (Category code including department prefix, or just department prefix)
  • Category Name

GENERAL LEDGER IMPORT

  • GL code
  • GL Description
  • Post / No post
  • P/L or B/S
  • Debit / Credit
  • Level
  • Prime Parent
  • Second Parent

Import (last edited 2024-11-08 05:38:48 by JennyTinsey)