Will create Unit Main Details, plus if in stock or a Sales Date is supplied, it will also create a Unit sales detail record.
Will also create Unit Type and Model Template records if they do not exist, so it can be better to import Model templates before this to have them better populated.
Enter Units in a spreadsheet and re-arrange the data into the following column order, then save as CSV Type. Fields in red are optional.
|
Column |
Field |
Description |
|---|---|---|
|
A |
Type |
Eg: Motorcycle |
|
B |
Make |
Eg: Honda |
|
C |
Model |
Eg: CBR600 (Will create a Model Template if not found) |
|
D |
Colour |
Eg: RED |
|
E |
Year |
Eg: 2012 |
|
F |
RegNo |
Eg: ABC123 |
|
G |
VIN |
Eg: 12345678901234567 (If Model and VIN same as existing record will use that) |
|
H |
EngNo |
Eg: 12345678901234567 |
|
I |
SizeCode |
Eg: 0250 |
|
J |
Odometer |
Eg: 10500 |
|
K |
New |
1, T, TRUE, Y, YES = New (anything else = Used) |
|
L |
InStock |
1, T, TRUE, Y, YES = In Stock (anything else = Sold). If in stock or a valid Sell Date will also create a Unit sales detail record |
|
M |
BuyExcl |
Buy Price (excluding Tax) |
|
N |
SpentExcl |
Amount spent on Unit (excluding Tax) |
|
O |
SellExcl |
Sell Price (excluding Tax) |
|
P |
SalesSummary |
Sales information |
|
Q |
SalesFeatures |
Additional sales features |
|
R |
Warranty |
Warranty information |
|
S |
Security |
Security information (KeyNo, Datatag etc) |
|
T |
BuyDate |
Date Purchased |
|
U |
BuyCustNo |
Customer number of the customer was bought from |
|
V |
PartNo |
Will create one based on the Model if blank |
|
W |
SellDate |
Date Sold (Leave blank if in stock or do not want a Unit Sales record) |
|
X |
SellCustNo |
Customer number or Name of the contact sold to (will also use for last keeper) |
|
Y |
SellInvNo |
Invoice Number of sale |
Import Units
If you have a Model Template file you would normally import this first (There are ones for certain Industries on our Portal).
-
Prepare file as above. See general information on importing
-
In Evopos select Items, Units, Maintenance and Import Units.
-
Select the file to import
Special Features
If the file name contains 'PROMPT' and the Model is Blank it will prompt for a Model, Make and Type
If the file name DOES NOT contains 'PROMPT' and the Model is Blank, it will not import that record, but create a new file \Evopos\Import\ConvertedUnits.CSV with the details and attempted Make, Model and Type match by looking in the Model Templates for words contained in the Part Number and the Item Description for that Part Number in the Stock file or Price Book PF_02 (If a Part Number isspecified)
If the file name contains 'NOTEMPLATE' it will not create a Model Template
To import Units for Unit Main Details (for Jobs etc) but not create a Unit Sales Details record, then set IsStock to 0 and leave SellDate and SellInvNo Blank.
If you set a SellCustno Evopos will search for that CustNo in Contacts and if found allocate that unit to that Contact,