- The first two lines must be deleted
- The green column (B, D, E, G, H, I) are ready to be imported for the lines: 4, 5, 6, 7, 8
- The client in column A is in the wrong format (see cell B14 for the formula; =TEXT(A14,”0000000000”). Depending of the GEM-CAR setup it could be V8.x.
- We can't use the column C
- Column D is a fictive number
- The column J, K, L, M, N must be transferred to column G, H, I from 30 October for this sample. "30jours" became a date 30/09/2015, the amount is duplicate in column "Montant" AND "Sold"
NOTE: Save the file on your desktop using a short name.... the maximum length in characters as to be less than 50 int the path name.
Good: Desktop\AR.xls ( short path )
Bad: C:\HP_LaserJet_CP1020_Series_Full_Solution\DotNetFX35.xls ( long path )