• 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 )