Spreadsheet: 167365d1341963429-how-to-stop-calculating-based-on-criteria-sample1-1-
Sheet: Sheet1

Vendor# | Location #   (do not put LOC or DC or name) | PO # or WV #              (put WV in front of 5 digit #) | Vendor Invoice/Credit Date | Vendor Invoice/Credit Number | Vendor MFG # | AAP SKU | Item Quantity Negative for Credit Positive for inv | Item Unit Cost per Each always positive amt | [NAME] Cost per Each always positive amt | Allowance or Charge Code | Allowance or Charge Amount  this can be a helper column | if all charges will be combined to show only in one row | Allowance or Charge Code 2 | Allowance or Charge Amount 2 | Allowance or Charge Code 3 | Allowance or Charge Amount 3 | Allowance or Charge Code 4 | Allowance or Charge Amount 4 | Allowance or Charge Code 5 | Allowance or Charge Amount 5 | Line Total | Running Total
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-1282-02 | 17150391 | -1 | 8.44
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-3210-00 | 17150489 | -1 | 48.17
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-3221-90 | 17150500 | -1 | 76.26
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-3238-01 | 17150506 | -1 | 29.71
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-5129-01 | 17150555 | -1 | 34.08
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-5173-01 | 17150575 | -1 | 20.51
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-5228-91 | 17150590 | -1 | 54.21
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 12-1429-00 | 17150718 | -1 | 18.18
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 12-1457-00 | 17150736 | -1 | 13.35
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 12-1458-00 | 17150737 | -1 | 13.35
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 12-1515-01 | 17150771 | -1 | 11.06
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 12-1521-91 | 17150777 | -1 | 18.56
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 12-1522-91 | 17150778 | -2 | 18.56
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 12-5034-01 | 17150873 | -1 | 19.78
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 12-5124-01 | 17150932 | -1 | 8.54
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 12-5152-01 | 17150943 | -1 | 17.3
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 17-1156-00 | 17150979 | -2 | 21.53
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 17-5030-01 | 17150983 | -1 | 15.17
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 17-5031-01 | 17150984 | -1 | 9.53
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 18-1476-62 | 17151063 | -1 | 24.8
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 18-1477-62 | 17151066 | -1 | 24.8
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 18-1989-01 | 17151151 | -1 | 15.86
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 18-3200-00 | 17151226 | -1 | 11.09
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 18-3215-01 | 17151227 | -1 | 13.37
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 18-5030-01 | 17151314 | -1 | 25.97
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 18-5040-01 | 17151320 | -1 | 19.68
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 18-5377-01 | 17151443 | -1 | 5.06
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 18-5506-01 | 17151476 | -1 | 40.34
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 18-5699-00 | 17151505 | -1 | 22.63
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 19-5265-00 | 17151532 | -1 | 32.22
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 19-5266-00 | 17151533 | -3 | 32.22
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 19-5347-01 | 17151552 | -1 | 34.56
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 19-5348-01 | 17151553 | -1 | 34.56
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 19-5353-01 | 17151557 | -1 | 19.14
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 19-5359-01 | 17151559 | -1 | 21.99
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 19-5360-01 | 17151560 | -2 | 21.99
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-3004-00 | 17151707 | -1 | 39.91
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-3098-00 | 17151732 | -1 | 31.69
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-3169-00 | 17151746 | -1 | 59.13
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-3170-90 | 17151749 | -1 | 85
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-3598-00 | 17151810 | -1 | 23.81
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-5188-01 | 17151895 | -1 | 66.3
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-5219-00 | 17151916 | -1 | 25.87
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-5225-00 | 17151922 | -1 | 23.08
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-5673-00 | 17152014 | -1 | 132.45
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-5827-00 | 17152048 | -1 | 55.28
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-5828-00 | 17152049 | -1 | 55.28
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-6014-00 | 17152077 | -1 | 47.9
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-6127-00 | 20706580 | -1 | 40.82
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-6125-00 | 20706598 | -1 | 97.69
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-6097-00 | 20706605 | -1 | 49.02
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-6098-00 | 20706606 | -1 | 49.02
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-6713-00 | 20706770 | -1 | 156.16
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 17-5184-00 | 20708179 | -1 | 5.31
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 18-5959-01 | 20708235 | -1 | 6.2
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 18-5960-01 | 20708236 | -2 | 6.2
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 18-5975-01 | 20708249 | -1 | 22.74
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 18-5987-00 | 20708257 | -1 | 13.58
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-5375-81 | 20708336 | -1 | 53.05
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-6027-00 | 20708358 | -1 | 46.6
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-6034-01 | 20708364 | -1 | 20.92
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-5994-01 | 20708389 | -1 | 42.82
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-6461-00 | 20708423 | -1 | 88.52
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-6462-00 | 20708452 | -1 | 88.52
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 99-1019-00 | 20708478 | -1 | 23.64
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 19-5659-00 | 20708579 | -1 | 48.9
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 19-5660-00 | 20708580 | -1 | 48.9
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 18-5923-00 | 22700034 | -1 | 45.53
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 19-5553-00 | 22700072 | -1 | 32.36
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 19-5554-00 | 22700073 | -1 | 32.36
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 19-5561-00 | 22700077 | -1 | 28.04
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 19-5451-80 | 22700102 | -1 | 38.5
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 19-5539-90 | 22700109 | -1 | 33.19
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-5877-01 | 22700131 | -2 | 55.84
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-5878-01 | 22700132 | -1 | 55.84
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-5885-01 | 22700133 | -1 | 59.21
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-5701-00 | 22700160 | -1 | 55.49
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 11-6002-00 | 22700172 | -1 | 65.37
89206 | 23 | WV68792 | 2012-06-25 00:00:00 | PSCM-71383 | 20-6408-00 | 22700301 | -1 | 97.79
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 11-1348-00 | 17150412 | -1 | 50.1
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 11-1869-01 | 17150452 | -1 | 34.46
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 11-5060-01 | 17150541 | -1 | 24.97
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 11-5129-01 | 17150555 | -1 | 34.08
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 11-5227-91 | 17150588 | -1 | 54.21
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 11-5358-00 | 17150624 | -1 | 50.96
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 11-5434-00 | 17150652 | -1 | 43.61
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 11-5451-01 | 17150653 | -1 | 50.74
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 12-1398-01 | 17150695 | -1 | 15.46
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 12-1410-01 | 17150707 | -1 | 7.95
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 12-1459-00 | 17150738 | -1 | 15.95
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 12-5100-01 | 17150915 | -1 | 11.23
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 12-5122-01 | 17150930 | -1 | 9.11
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 17-1105-01 | 17150959 | -1 | 2.89
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 17-1142-00 | 17150974 | -1 | 24.78
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 17-1143-00 | 17150975 | -1 | 24.78
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 17-1155-00 | 17150978 | -1 | 21.53
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 18-1200-01 | 17151001 | -1 | 3.3
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 18-1201-01 | 17151003 | -1 | 3.3
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 18-1922-00 | 17151122 | -1 | 39.21
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 18-3371-61 | 17151252 | -1 | 18.21
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 18-5019-00 | 17151307 | -1 | 16.89
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 18-5090-01 | 17151360 | -1 | 4.79
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 18-5234-01 | 17151411 | -1 | 16.55
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 20-1751-00 | 17151650 | -1 | 27.67
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 20-1840-00 | 17151669 | -1 | 29.36
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 20-3083-00 | 17151729 | -1 | 25.87
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 20-3547-00 | 17151781 | -1 | 105.8
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 20-3593-00 | 17151805 | -1 | 50.86
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 20-3598-00 | 17151810 | -1 | 23.81
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 20-5122-09 | 17151851 | -1 | 97.4
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 20-6627-01 | 20706668 | -1 | 80.71
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 20-6628-01 | 20706669 | -1 | 80.71
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 11-6078-00 | 20708205 | -1 | 46.43
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 18-5975-01 | 20708249 | -1 | 22.74
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 11-5372-80 | 20708335 | -1 | 49.81
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 20-6015-00 | 20708474 | -1 | 93.35
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 19-5637-00 | 20708574 | -1 | 83.99
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 18-5897-01 | 22700005 | -1 | 24.62
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 18-5928-00 | 22700016 | -1 | 32.88
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 19-5558-00 | 22700075 | -1 | 28.23
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 11-5353-91 | 22700144 | -1 | 62.16
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 11-5604-00 | 22700159 | -1 | 80.89
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 11-5702-00 | 22700161 | -1 | 51.61
89206 | 25 | WV68170 | 2012-06-25 00:00:00 | PSCM-71386 | 11-5978-00 | 22700168 | -1 | 42.32
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 2320011 | 10032578 | -1 | 35.22
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 5700431 | 10033889 | -1 | 52.27
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 1820122 | 10071081 | -1 | 24.66
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 11-1643-09 | 17150431 | -1 | 30.69
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 18-1321-00 | 17151037 | -1 | 25.07
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 18-1858-01 | 17151101 | -1 | 15.07
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 18-3171-01 | 17151202 | -1 | 35.27
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 18-3371-61 | 17151252 | -1 | 18.21
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 18-3372-61 | 17151254 | -1 | 18.21
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 18-3533-91 | 17151300 | -1 | 16.33
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 20-3082-00 | 17151728 | -1 | 25.87
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 20-3519-80 | 17151774 | -1 | 26.9
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 20-5143-00 | 17151864 | -1 | 83.92
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 20-5811-00 | 17152038 | -1 | 36.47
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 20-5827-00 | 17152048 | -1 | 55.28
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 11-6094-01 | 20706602 | -1 | 16.11
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 20-6453-01 | 20706651 | -1 | 177.38
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 12-5068-91 | 20708216 | -1 | 35.36
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 18-5918-01 | 20708277 | -1 | 20.5
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 11-5008-81 | 20708325 | -1 | 18.6
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 11-6034-01 | 20708364 | -1 | 20.92
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 20-6586-00 | 20708473 | -1 | 140.76
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | SDT-102 | 22271492 | -1 | 12.37
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 18-3120-91 | 22700049 | -1 | 12.82
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 18-5942-00 | 22700097 | -1 | 3.18
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 19-5461-00 | 22700104 | -1 | 49.52
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 11-5866-01 | 22700115 | -1 | 42.73
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 11-5832-01 | 22700118 | -1 | 23.64
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 11-5836-00 | 22700120 | -1 | 81.11
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 11-5863-01 | 22700125 | -1 | 48.9
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 11-5886-01 | 22700134 | -1 | 59.21
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 11-5491-01 | 22700148 | -1 | 66.01
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 11-5912-01 | 22700196 | -1 | 87.23
46965 | 11 | WV02117 | 2012-07-06 00:00:00 | PSCM-71506 | 20-6291-00 | 22700220 | -1 | 135.98