Spreadsheet: 734929d1622592171-copying-fixed-data-on-multi-line-transactions-excel-question
Sheet: Sheet1

Report Name: | Sales Register
Created On: | 2021-02-21 00:00:00
Date | Customer | Inv#/Adjustment# | Due date | GL Account | Organization | Amount | Amount paid
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.34 | 0.34
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 11.75 | 11.75
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.2 | 0.2
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.06 | 0.06
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 40020--Revenue – Materials | LS | 11.41 | 11.41
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 3.43 | 3.43
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 40020--Revenue – Materials | LS | 3.04 | 3.04
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.06 | 0.06
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 40020--Revenue – Materials | LS | 8.89 | 8.89
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.62 | 0.62
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.12 | 0.12
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.22 | 0.22
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 40020--Revenue – Materials | LS | 14.84 | 14.84
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.28 | 0.28
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 40020--Revenue – Materials | LS | 180.75 | 180.75
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 40020--Revenue – Materials | LS | 16.28 | 16.28
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.09 | 0.09
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.17 | 0.17
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 40020--Revenue – Materials | LS | -271.89 | -271.89
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 40020--Revenue – Materials | LS | 3.3 | 3.3
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 40020--Revenue – Materials | LS | 4.48 | 4.48
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.58 | 0.58
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.96 | 0.96
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 40020--Revenue – Materials | LS | 17.79 | 17.79
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.41 | 0.41
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 11.47 | 11.47
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 40020--Revenue – Materials | LS | 6.24 | 6.24
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 1.16 | 1.16
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 40020--Revenue – Materials | LS | 16.28 | 16.28
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 39.26 | 39.26
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.29 | 0.29
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.21 | 0.21
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 2.12 | 2.12
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 25300--Sales Tax Payable | LS | 0.74 | 0.74
2019-06-11 00:00:00 | CUST00150 | IN14669 | 2019-07-11 00:00:00 | 40010--Revenue – Labor | LS | 603.93 | 603.93
 |  |  |  |  |  | 689.88 | 689.88
2019-06-11 00:00:00 | CUST00150 | IN14718 | 2019-07-11 00:00:00 | 40020--Revenue – Materials | LS | 8.62 | 8.62
 |  |  |  | 25300--Sales Tax Payable | LS | 0.09 | 0.09
 |  |  |  | 25300--Sales Tax Payable | LS | 1.38 | 1.38
 |  |  |  | 25300--Sales Tax Payable | LS | 3.38 | 3.38
 |  |  |  | 25300--Sales Tax Payable | LS | 0.15 | 0.15
 |  |  |  | 40020--Revenue – Materials | LS | 35.14 | 35.14
 |  |  |  | 25300--Sales Tax Payable | LS | 1.18 | 1.18
 |  |  |  | 25300--Sales Tax Payable | LS | 6.18 | 6.18
 |  |  |  | 40020--Revenue – Materials | LS | 9.96 | 9.96
 |  |  |  | 40020--Revenue – Materials | LS | 17.28 | 17.28
 |  |  |  | 40020--Revenue – Materials | LS | -642.04 | -642.04
 |  |  |  | 25300--Sales Tax Payable | LS | 2.2 | 2.2
 |  |  |  | 25300--Sales Tax Payable | LS | 0.68 | 0.68
 |  |  |  | 25300--Sales Tax Payable | LS | 4.23 | 4.23
 |  |  |  | 25300--Sales Tax Payable | LS | 3.26 | 3.26
 |  |  |  | 25300--Sales Tax Payable | LS | 5.7 | 5.7
 |  |  |  | 40020--Revenue – Materials | LS | 67.62 | 67.62
 |  |  |  | 25300--Sales Tax Payable | LS | 0.17 | 0.17
 |  |  |  | 25300--Sales Tax Payable | LS | 0.35 | 0.35
 |  |  |  | 25300--Sales Tax Payable | LS | 0.54 | 0.54
 |  |  |  | 25300--Sales Tax Payable | LS | 1.08 | 1.08
 |  |  |  | 40020--Revenue – Materials | LS | 162.8 | 162.8
 |  |  |  | 25300--Sales Tax Payable | LS | 38.64 | 38.64
 |  |  |  | 25300--Sales Tax Payable | LS | 0.39 | 0.39
 |  |  |  | 25300--Sales Tax Payable | LS | 0.09 | 0.09
 |  |  |  | 25300--Sales Tax Payable | LS | 1.93 | 1.93
 |  |  |  | 25300--Sales Tax Payable | LS | 10.82 | 10.82
 |  |  |  | 25300--Sales Tax Payable | LS | 0.22 | 0.22
 |  |  |  | 25300--Sales Tax Payable | LS | 0.3 | 0.3
 |  |  |  | 25300--Sales Tax Payable | LS | 0.35 | 0.35
 |  |  |  | 25300--Sales Tax Payable | LS | 3.26 | 3.26
 |  |  |  | 25300--Sales Tax Payable | LS | 20.36 | 20.36
 |  |  |  | 25300--Sales Tax Payable | LS | 6.18 | 6.18
 |  |  |  | 40010--Revenue – Labor | LS | 618.19 | 618.19
 |  |  |  | 40020--Revenue – Materials | LS | 193.04 | 193.04
 |  |  |  | 25300--Sales Tax Payable | LS | 0.61 | 0.61
 |  |  |  | 40020--Revenue – Materials | LS | 162.8 | 162.8
 |  |  |  | 25300--Sales Tax Payable | LS | 0.3 | 0.3
 |  |  |  | 40020--Revenue – Materials | LS | 22.12 | 22.12
 |  |  |  | 25300--Sales Tax Payable | LS | 0.52 | 0.52
 |  |  |  | 40020--Revenue – Materials | LS | 19.92 | 19.92
 |  |  |  | 25300--Sales Tax Payable | LS | 0.22 | 0.22
 |  |  |  | 25300--Sales Tax Payable | LS | 12.07 | 12.07
 |  |  |  | 25300--Sales Tax Payable | LS | 0.3 | 0.3
 |  |  |  | 25300--Sales Tax Payable | LS | 1.93 | 1.93
 |  |  |  | 25300--Sales Tax Payable | LS | 0.68 | 0.68
 |  |  |  | 25300--Sales Tax Payable | LS | 0.17 | 0.17
 |  |  |  | 25300--Sales Tax Payable | LS | 1.87 | 1.87
 |  |  |  |  |  | 807.23 | 807.23