Hey,
Hope some of you can help please.
Is there any way to run a TB up to and including a specified GL entry number?
We have our BC linked to a live P2P system so invoices are always coming through for prior periods which changes our management accounts. YTD figures will obviously be ok but the monthly splits are always changing.
Is is possible to do this by any chance?
Cheers
Richard
It depends on how the report is created. If you are using the GL function, there is no way to specify entry numbers as a filter.
The only way would be to use the NL(SUM) function on the GL Entry table with a filter for up to the specified entry number, however this will be an extremely slow report because to get the balance each time, it has to sum up all records for all time. It is a very inefficient report but sometimes I've been surprised so you could give it a try.
