I have a list of checks issued and list of bills with a unique tracking numbers and need to match them up (these are in order by transaction ID, which are created sequentially). I sorted both by internal tracking number and need to assign a check number to the bills (or invoice numbers to the check). For instance, once I assigned the first 2 bills for vendor ABC, they total up to the first check amount for ABC. I have 2,000 invoice to match up to 863 checks and going check-by-check visually is going to be a nightmare. Any ideas where to start with this? <BR>
Trans ID Invoice # Vendor Amount Assigned Ck # Trans ID Check # Vendor Name Check Amount
1 INV 123 Acme 300.00 1000 9 1000 Acme 650
2 INV 124 Acme 350.00 1000 13 1001 Other Co. 2,000
3 INV 9183 Other Co. 1,200.00 ??? 18 1002 Test 3,500
4 INV 83 Other Co. 800.00 ??? 28 1003 Acme 50