Skip to Content
0
Former Member
Sep 18, 2009 at 03:16 PM

Problem with business partner cumulative balance

194 Views

Hi

I used to used the business partner balance enqury to quickly tell customers what they were due to pay up to the start of the month. I just looked at the cumulative balance of the last transaction of the previous month and that was it. I know I could run an aged credit report but this was quicker and easier. However since upgrade to 2007A the cumulative balance does not give the amount due for a part paid invoice so this does not work any more.

Question is has anyone writen a fast query or other report that calculates the cumulative balance based on outstanding amount?

Thanks in advance

Derek