Hello there
I need help with the grouping here int his matrix, each line need to match by journal, also I am listing how it needs to look
Thank you
TYPE | JOURNAL | OBJECT | TITLE | AMOUNT | TYPE | JOURNAL | OBJECT | TITLE | AMOUNT |
E | 1121 | 010105511229 | ON BEHALF PENSION STATE | 550,000 | R | 1121 | 010312510 | FIRE INSURANCE | -550,000 |
E | 1122 | 010105511229 | ON BEHALF PENSION STATE | 550,000 | R | 1122 | 010312520 | CASUALTY INSURANCE | -500,000 |
E | 1123 | 410900533957 | CONTRIBUTION FUND | 0 | R | 1123 | 010382410 | CONTRIBUTION FROM WATER | 0 |
E | 1124 | 010400513240 | WORKER COMPESANTION | 2616 | R | 1124 | 050381100 | TR FROM FUND 010 | -10416 |
E | 1124 | 010440513240 | WORKER COMPESANTION | 1500 | R | 1124 | 050381100 | TR FROM FUND 011 | -10417 |
E | 1124 | 010470513240 | WORKER COMPESANTION | 1300 | R | 1124 | 050381100 | TR FROM FUND 012 | -10418 |
E | 1124 | 010500521240 | WORKER COMPESANTION | 5000 | R | 1124 | 050381100 | TR FROM FUND 013 | -10419 |