Hi Kenneth et al
I have to update allocation with 1's as u c below. One credit can match many debits or just one debit. There can be more than one credit per account in a match period. There is no other way of matching debit vs credit- they do not share a reference code - it is just matching within an account code
I hope this explains better as currently this is done manually!!
rgds Adrian
| Accnt_code | Other_Amt | Conv_code | Allocation | Trans_date | |
| STH002 | 99,315.00 | ZWD | 1 | 5/11/2005 | |
| STH002 | 14,897.25 | ZWD | 1 | 5/11/2005 | |
| STH002 | 192,230.00 | ZWD | 1 | 5/26/2005 | |
| STH002 | 28,834.50 | ZWD | 1 | 5/26/2005 | |
| STH002 | 555,000.00 | ZWD | 1 | 4/7/2005 | |
| STH002 | (890,276.75) | ZWD | 1 | 5/26/2005 | |
| STH002 | 356,715.00 | ZWD | 6/28/2005 | ||
| SUB001 | 27,500.00 | ZWD | 1 | 1/31/2005 | |
| SUB001 | 1,500.00 | ZWD | 1 | 2/28/2005 | |
| SUB001 | (29,000.00) | ZWD | 1 | 6/1/2005 | |
| SUB001 | 400,000.00 | ZWD | 1 | 6/30/2005 | |
| SUB001 | (400,000.00) | ZWD | 1 | 6/30/2005 | |
| SVB001 | 690,000.00 | ZWD | 3/8/2005 | ||
| SVB001 | 10,120,000.00 | ZWD | 1 | 3/16/2005 | |
| SVB001 | 600,000.00 | ZWD | 3/16/2005 | ||
| SVB001 | (10,120,000.00) | ZWD | 1 | 3/30/2005 | |
| SVB001 | (2,025,000.00) | ZWD | 4/1/2005 | ||
| SVB001 | 210,000.00 | ZWD | 4/4/2005 | ||
| SVB001 | (2,760,000.00) | ZWD | 1 | 6/30/2005 | |
| SVB001 | 2,760,000.00 | ZWD | 1 | 6/30/2005 |