Need help with a DTB report

jackies

Hi all

I have been checking our customized reports and found an error which is common in all our (subsidiary) DTB reports that has to be fixed. This probably requires coding something I'm not familiar with.

The Vendor/Customer/Bank account DTB reports have been modified to exclude reverse entries (included in default report). We did this in to filter the mistakes and show to our clients only the actual movement. However, there is a problem with the code. Here is an example of how the report works:

Run for the period 01/01/10..31/01/10

01/01/10 Starting balance        100
10/01/10 Entry                    50    (Balance 150)      Entry no. 5
31/01/10 Entry                    60    (Balance 210)      Entry no. 6
31/01/10 Entry                    40    (Balance 250)      Entry no. 7
31/01/10 Reverse entry (of 6)    -60    (Balance 190)      Entry no. 8

The report will calculate the balance after each entry but will stop at entry no.7
The ending balance of the report will correctly show 190 but the balance on the line will show 250 because it stops at that point and does not calculate the reversed entry made afterwards. The main problem is that eventhough entry 6 is not shown, it is calculated in the line balance. As a result the report looks like this:

Run for the period 01/01/10..31/01/10

01/01/10 Starting balance        100
10/01/10 Entry                    50    (Balance 150)      Entry no. 5
31/01/10 Entry                    40    (Balance 250)      Entry no. 7

Please advice how to make the report calculate all the entries made on that date and not to stop when it finds the last posted.

Thanks in advance!

jackies

Any help experts

jackies

Anyone...

jackies

The problem just became worse when I realised that this also happens when the first entry or entries are reversed and/or reversals...
](*,) ](*,) ](*,)