Stock Code
|
Unique stock code
|
String
|
24
|
LTO.99.6221.COMP
Characters that can be used are 0-9 A-Z '.' '/' '-'. Please ensure there are no spaces.
|
Stock Description
|
Description of stock
|
String
|
1000
|
LTO Ultrium 1 drive
|
Long Description
|
Longer description, which does not appear on system invoices.
|
String
|
-
|
Longer description
|
Short Description
|
Shorter description, which does not appear on system invoices.
|
String
|
-
|
Shorter description
|
Stock Type
|
Choose this from Jim2 stock types eg. dynamic kitting, static kitting, depleting, etc.
Note: You cannot import manufacturing stock.
|
String
|
15
|
Depleting
|
GL Group
|
Indicates stock on hand, cost of goods sold, and income accounts to update.
|
String
|
30
|
Electrical
|
Measure Unit 1
|
Smallest unit of measure purchased and sold.
|
String
|
4
|
Each
|
Measure Qty 1
|
This field must equal 1
|
String
|
1
|
1
|
Measure Description 1
|
Additional description which will be added to stock description on jobs/invoices etc.
|
String
|
-
|
Single unit
|
Barcode 1
|
Use this field if barcodes will be used, ie. scan stock at point of sale.
|
Decimal
|
24
|
9132323500017
|
Measure Unit 2
|
Smallest unit of measure purchased and sold.
|
String
|
4
|
Pack
|
Measure Qty 2
|
This field must equal 1
|
String
|
1
|
3
|
Measure Description 2
|
Additional description which will be added to stock description on jobs/invoice,s etc.
|
String
|
-
|
100Metre Roll
|
Barcode 2
|
Use this field to add a different barcode for a different type of packaging, ie. a pack of 2.
|
String
|
24
|
9132323500018
|
Measure Unit 3
|
Smallest unit of measure purchased and sold.
|
String
|
4
|
Carton
|
Measure Qty 3
|
This field must equal 1
|
String
|
1
|
12
|
Measure Description 3
|
Additional description which will be added to stock description on jobs/invoice,s etc.
|
String
|
-
|
100Metre Roll
|
Barcode 3
|
Use this field to add a different barcode for a different type of packaging, ie. box of 12.
|
String
|
24
|
9132323500019
|
Buy Unit
|
This must appear exactly as one of the measure unit fields (see above).
|
String
|
4
|
Box
|
Sell Unit
|
This must appear exactly as one of the measure unit fields (see above).
|
String
|
4
|
Box
|
Qty Decimal Places
|
Number of decimal places allowed in Qty.
|
Integer from 1-4
|
1
|
2
|
Tax Code on Purch
|
Tax code of stock on purchase
|
String
|
1
|
G
|
Tax Code on Sell
|
Tax code of stock on sell
|
String
|
1
|
G
|
I Buy This Stock
|
I buy this stock?
|
Boolean
|
T/F
|
T
|
I Sell This Stock
|
I sell this stock?
|
Boolean
|
T/F
|
T
|
Serial #
|
Use serial numbers (on purchase/on sell/not required).
|
String
|
50
|
On Purchase
|
Warranty
|
Warranty (in months)
|
Decimal
|
-
|
24
|
Warranty Description
|
Enter warranty details
|
String
|
|
2 years warranty
|
Price Level 1
|
Price level 1
|
String
|
15
|
Retail
|
Price Calc Method 1
|
Price calculation method 1
|
String
|
20
|
Avg PO COGS + Markup
|
Percent 1 (%)
|
Percent 1 (%)
|
Decimal
|
-
|
10
|
Price Level 2
|
Price level 2
|
String
|
15
|
Government
|
Price Calc Method 2
|
Price calculation method 2
|
String
|
20
|
List Percent
|
Percent 2 (%)
|
Percent 1 (%) – only if above two fields are populated.
|
Decimal
|
-
|
10
|
List Price (excluding GST)
|
List price excluding GST
|
Decimal
|
-
|
1900.00
|
List Price (including GST)
|
List price including GST
|
Decimal
|
-
|
2090.00
|
Minimum Sale Price (excluding GST)
|
Sale price tax free 1
|
Decimal
|
-
|
2000.00
|
Minimum Sale Price (incl GST)
|
Sale price tax paid 1
|
Decimal
|
-
|
2200.00
|
Price Calculation Min Sale
|
If above fields are not populated, enter the minimum sale price calculation method.
|
String
|
-
|
List – Percent
|
Min Sale Pcnt
|
Based on minimum sale price calculation method chosen.
|
String
|
-
|
40
|
Price Template
|
Price template already configured in database.
|
String
|
-
|
Contract Toner
|
Vendor (Card Code)
|
Must appear exactly as entered in cardfile.
|
String
|
10
|
ELEC.IMPorT
|
Vendor Stock Code
|
Vendor stock code
|
String
|
24
|
WE2CorE
|
Vendor List Price (Ex GST)
|
Vendor list price ex gst
|
Decimal
|
-
|
500.00
|
Vendor List Price (including GST)
|
Vendor list price inc gst
|
Decimal
|
-
|
550.00
|
Vendor Currency Code
|
Currency according to vendor list price
|
String
|
|
AUD
|
Vendor Exchange Rate
|
Expressed in $ and cents in AUD
|
String
|
-
|
$1.25
|
Vendor Discount %
|
Vendor discount %
|
Decimal
|
-
|
10.00
|
Vendor Extra Percent
|
Use of on-costs associated with purchasing overseas (percent).
|
Decimal
|
-
|
5.00
|
Vendor Extra Dollars
|
Use of on-costs associated with purchasing overseas (dollars).
|
String
|
-
|
5.00
|
Vendor Unit
|
Way products are sold by vendor. Must choose one of the 3 unit measures specified above.
|
String
|
-
|
Box
|
Vendor Last Cost
|
Enter last cost if vendor list price has not been entered.
|
String
|
-
|
$12.00
|
Vendor Last Updated
|
Date vendor list price or last cost was effective from.
|
String
|
-
|
Date
|
Report Level 1
|
Report level 1
|
String
|
30
|
Global
|
Report Level 2
|
Report level 2
|
String
|
30
|
ADIC
|
Report Level 3
|
Report level 3
|
String
|
30
|
Hardware
|
Report Level 4
|
Report level 4
|
String
|
30
|
Stand Alone Drive
|
Report Level 5
|
Report level 5
|
String
|
30
|
LTO
|
Brand
|
Enter brand name of stock
|
String
|
-
|
Sony
|
Publish Price
|
Is this record to appear in price list, web, etc. or don't publish.
|
String
|
-
|
Price List and Web
|
Weight
|
Weight of stock
|
Decimal
|
-
|
0
|
Height
|
Height of stock
|
Decimal
|
-
|
0
|
Length
|
Length of stock
|
Decimal
|
-
|
0
|
Width
|
Width of stock
|
Decimal
|
-
|
0
|
Hide on Invoice
|
Allows for hiding stock code on invoice
|
Boolean
|
T/F
|
T
|
Primary Bin Location
|
Discuss with Happen Business
|
|
|
|
Min Qty
|
Discuss with Happen Business
|
|
|
|
Min Qty High
|
Discuss with Happen Business
|
|
|
|
Loc reorder Qty
|
Discuss with Happen Business
|
|
|
|
Primary Bin Name
|
Discuss with Happen Business
|
|
|
|
Primary Bin Name 2
|
Discuss with Happen Business
|
|
|
|
Non Report Group
|
Discuss with Happen Business
|
|
|
|
Vendor Quantity in Stock
|
Discuss with Happen Business
|
|
|
|