ABCDEFGHIJKL
1
IMPORTED IDLINE SEQUENCEITEM CODEITEM DESCRIPTION
ITEM DESCRIPTION 2
QUANTITY SOLD
LINE ITEM AMOUNTLINE ITEM COSTUNIT PRICEUNIT GST
COMMENT
JOB CARD COMMENT
2
5000110Major ServiceMajor Service carry out on 10 000k service0.542.58508.5
3
Must Not Exceed 255 Characters
Must be Numeric
Must Not Exceed 50 Characters
Must Not Exceed 255 CharactersMax 255 Characters
Must be Numeric
Must Not Exceed 10 Characters
Must Not Exceed 10 Characters
Must Not Exceed 10 Characters
Must Not Exceed 10 Characters
4
Imported ID Can Be Same As Invoice Number
5
6
History Lines Are Mostly the Number Of Lines On Each Invoice. Copy the Invoice Numbers from HISTORY HEADER File and Insert Them On This Sheet In a New Column. Match The Invoice Numbers Using a Formula =IF(ISNUMBER(MATCH(A1,B$1:B$XYZ,0)),1,0) In A New Column.
Delete the Lines That Do not Match, where result will be '0'.
7
8
9
NB: Column Names Highlighted In Yellow Are Mandatory (Do Not Leave Blank)
10
MUST NOT use Special Characters, Symbols, Abbreviations for Mathematical Measruing terms, Icons. Characters Can Be Alpha-Numeric
11
File Format Must Always be .CSV (Comma Delimited)
12
Max Records That Can Be Imported at A Time Are No More Than 5000 Lines(Rows)
13
14
**IMPORTANT: We Do Not Provide Any Support For Imports. Please Ensure All Of The Above Stated Conditions Are Met and Fields Are Correctly Set, In Order To Carry Successful Import.
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100