Spreadsheet: 270319d1381437209-advanced-data-val-forumhelpdata-val-2-
Sheet: Sales

Date (Right Click-Insert Date) | Payment Status | Invoice  Number | Job Number (Click to see jobs) | Customer | Payment Method | Net (Before VAT) | VAT @ 20% | GROSS (Net + VAT) | CIS  Customer YES/NO | Materials (Only CIS Customers) | CIS Deducted | Amount after CIS Deduction | Payment Terms (In days) | Payment due date
 |  | 14050 | [NAME]
 |  | 14051
 |  | 14052
 |  | 14053
 |  | 14054
 |  | 14055
 |  | 14056
 |  | 14057
 |  | 14058
 |  | 14059
 |  | 14060
 |  | 14061
 |  | 14062
 |  | 14063
 |  | 14064
 |  | 14065
 |  | 14066
 |  | 14067
 |  | 14068
 |  | 14069
 |  | 14070
 |  | 14071
 |  | 14072
 |  | 14073
 |  | 14074
 |  | 14075
 |  | 14076
 |  | 14077
 |  | 14078
 |  | 14079
 |  | 14080
 |  | 14081
 |  | 14082
 |  | 14083
 |  | 14084
 |  | 14085
 |  | 14086
 |  | 14087
 |  | 14088
 |  | 14089
 |  | 14090
 |  | 14091
 |  | 14092
 |  | 14093
 |  | 14094
 |  | 14095
 |  | 14096
 |  | 14097
 |  | 14098
 |  | 14099
 |  | 14100
 |  | 14101
 |  | 14102
 |  | 14103
 |  | 14104
 |  | 14105
 |  | 14106
 |  | 14107
 |  | 14108
 |  | 14109
 |  | 14110
 |  | 14111
 |  | 14112
 |  | 14113
 |  | 14114
 |  | 14115
 |  | 14116
 |  | 14117
 |  | 14118
 |  | 14119
 |  | 14120
 |  | 14121
 |  | 14122
 |  | 14123
 |  | 14124
 |  | 14125
 |  | 14126
 |  | 14127
 |  | 14128
 |  | 14129
 |  | 14130
 |  | 14131
 |  | 14132
 |  | 14133
 |  | 14134
 |  | 14135
 |  | 14136
 |  | 14137
 |  | 14138
 |  | 14139
 |  | 14140
 |  | 14141
 |  | 14142
 |  | 14143
 |  | 14144
 |  | 14145
 |  | 14146
 |  | 14147
 |  | 14148
 |  | 14149
 |  | 14150
 |  | 14151
 |  | 14152
 |  | 14153
 |  | 14154
 |  | 14155
 |  | 14156
 |  | 14157
 |  | 14158
 |  | 14159
 |  | 14160
 |  | 14161
 |  | 14162
 |  | 14163
 |  | 14164
 |  | 14165
 |  | 14166
 |  | 14167
 |  | 14168
 |  | 14169
 |  | 14170
 |  | 14171
 |  | 14172
 |  | 14173
 |  | 14174
 |  | 14175
 |  | 14176
 |  | 14177
 |  | 14178
 |  | 14179
 |  | 14180
 |  | 14181
 |  | 14182
 |  | 14183
 |  | 14184
 |  | 14185
 |  | 14186
 |  | 14187
 |  | 14188
 |  | 14189
 |  | 14190
 |  | 14191
 |  | 14192
 |  | 14193
 |  | 14194
 |  | 14195
 |  | 14196
 |  | 14197
 |  | 14198
 |  | 14199
 |  | 14200
 |  | 14201
 |  | 14202
 |  | 14203
 |  | 14204
 |  | 14205
 |  | 14206
 |  | 14207
 |  | 14208
 |  | 14209
 |  | 14210
 |  | 14211
 |  | 14212
 |  | 14213
 |  | 14214
 |  | 14215
 |  | 14216
 |  | 14217
 |  | 14218
 |  | 14219
 |  | 14220
 |  | 14221
 |  | 14222
 |  | 14223
 |  | 14224
 |  | 14225
 |  | 14226
 |  | 14227
 |  | 14228
 |  | 14229
 |  | 14230
 |  | 14231
 |  | 14232
 |  | 14233
 |  | 14234
 |  | 14235
 |  | 14236
 |  | 14237
 |  | 14238
 |  | 14239
 |  | 14240
 |  | 14241
 |  | 14242
 |  | 14243
 |  | 14244
 |  | 14245
 |  | 14246
 |  | 14247
 |  | 14248
 |  | 14249
 |  | 14250
 |  | 14251
 |  | 14252
 |  | 14253
 |  | 14254
 |  | 14255
 |  | 14256
 |  | 14257
 |  | 14258
 |  | 14259
 |  | 14260
 |  | 14261
 |  | 14262
 |  | 14263
 |  | 14264
 |  | 14265
 |  | 14266
 |  | 14267
 |  | 14268
 |  | 14269
 |  | 14270
 |  | 14271
 |  | 14272
 |  | 14273
 |  | 14274
 |  | 14275
 |  | 14276
 |  | 14277
 |  | 14278
 |  | 14279
 |  | 14280
 |  | 14281
 |  | 14282
 |  | 14283
 |  | 14284
 |  | 14285
 |  | 14286
 |  | 14287
 |  | 14288
 |  | 14289
 |  | 14290
 |  | 14291
 |  | 14292
 |  | 14293
 |  | 14294
 |  | 14295
 |  | 14296
 |  | 14297
 |  | 14298
 |  | 14299
 |  | 14300
 |  | 14301
 |  | 14302
 |  | 14303
 |  | 14304
 |  | 14305
 |  | 14306
 |  | 14307
 |  | 14308
 |  | 14309
 |  | 14310
 |  | 14311
 |  | 14312
 |  | 14313
 |  | 14314
 |  | 14315
 |  | 14316
 |  | 14317
 |  | 14318
 |  | 14319
 |  | 14320
 |  | 14321
 |  | 14322
 |  | 14323
 |  | 14324
 |  | 14325
 |  | 14326
 |  | 14327
 |  | 14328
 |  | 14329
 |  | 14330
 |  | 14331
 |  | 14332
 |  | 14333
 |  | 14334
 |  | 14335
 |  | 14336
 |  | 14337
 |  | 14338
 |  | 14339
 |  | 14340
 |  | 14341
 |  | 14342
 |  | 14343
 |  | 14344
 |  | 14345
 |  | 14346
 |  | 14347
 |  | 14348
 |  | 14349
 |  | 14350
 |  | 14351
 |  | 14352
 |  | 14353
 |  | 14354
 |  | 14355
 |  | 14356
 |  | 14357
 |  | 14358
 |  | 14359
 |  | 14360
 |  | 14361
 |  | 14362
 |  | 14363
 |  | 14364
 |  | 14365
 |  | 14366
 |  | 14367
 |  | 14368
 |  | 14369
 |  | 14370
 |  | 14371
 |  | 14372
 |  | 14373
 |  | 14374
 |  | 14375
 |  | 14376
 |  | 14377
 |  | 14378
 |  | 14379
 |  | 14380
 |  | 14381
 |  | 14382
 |  | 14383
 |  | 14384
 |  | 14385
 |  | 14386
 |  | 14387
 |  | 14388
 |  | 14389
 |  | 14390
 |  | 14391
 |  | 14392
 |  | 14393
 |  | 14394
 |  | 14395
 |  | 14396
 |  | 14397
 |  | 14398
 |  | 14399
 |  | 14400
 |  | 14401
 |  | 14402
 |  | 14403
 |  | 14404
 |  | 14405
 |  | 14406
 |  | 14407
 |  | 14408
 |  | 14409
 |  | 14410
 |  | 14411
 |  | 14412
 |  | 14413
 |  | 14414
 |  | 14415
 |  | 14416
 |  | 14417
 |  | 14418
 |  | 14419
 |  | 14420
 |  | 14421
 |  | 14422
 |  | 14423
 |  | 14424
 |  | 14425
 |  | 14426
 |  | 14427
 |  | 14428
 |  | 14429
 |  | 14430
 |  | 14431
 |  | 14432
 |  | 14433
 |  | 14434
 |  | 14435
 |  | 14436
 |  | 14437
 |  | 14438
 |  | 14439
 |  | 14440
 |  | 14441
 |  | 14442
 |  | 14443
 |  | 14444
 |  | 14445
 |  | 14446
 |  | 14447
 |  | 14448
 |  | 14449
 |  | 14450
 |  | 14451
 |  | 14452
 |  | 14453
 |  | 14454
 |  | 14455
 |  | 14456
 |  | 14457
 |  | 14458
 |  | 14459
 |  | 14460
 |  | 14461
 |  | 14462
 |  | 14463
 |  | 14464
 |  | 14465
 |  | 14466
 |  | 14467
 |  | 14468
 |  | 14469
 |  | 14470
 |  | 14471
 |  | 14472
 |  | 14473
 |  | 14474
 |  | 14475
 |  | 14476
 |  | 14477
 |  | 14478
 |  | 14479
 |  | 14480
 |  | 14481
 |  | 14482
 |  | 14483
 |  | 14484
 |  | 14485
 |  | 14486
 |  | 14487
 |  | 14488
 |  | 14489
 |  | 14490
 |  | 14491
 |  | 14492
 |  | 14493
 |  | 14494
 |  | 14495
 |  | 14496
 |  | 14497
 |  | 14498
 |  | 14499
 |  | 14500
 |  | 14501
 |  | 14502
 |  | 14503
 |  | 14504
 |  | 14505
 |  | 14506
 |  | 14507
 |  | 14508
 |  | 14509
 |  | 14510
 |  | 14511
 |  | 14512
 |  | 14513
 |  | 14514
 |  | 14515
 |  | 14516
 |  | 14517
 |  | 14518
 |  | 14519
 |  | 14520
 |  | 14521
 |  | 14522
 |  | 14523
 |  | 14524
 |  | 14525
 |  | 14526
 |  | 14527
 |  | 14528
 |  | 14529
 |  | 14530
 |  | 14531
 |  | 14532
 |  | 14533
 |  | 14534
 |  | 14535
 |  | 14536
 |  | 14537
 |  | 14538
 |  | 14539
 |  | 14540
 |  | 14541
 |  | 14542
 |  | 14543
 |  | 14544
 |  | 14545
 |  | 14546
 |  | 14547
 |  | 14548