I know that there are other options (like using SmartList), but for audit purposes, I would like to modify the Checkbook Register report to include the total of the the amounts displayed. I specifically would like to use the checkbook register to not only reflect the individual checks issued on a given date, but to also show the total amount of all the checks for a given checkbook (we are a multi-curency company, so I would need to report to reflect the totals by checkbook). The unmodified report gives the check number, vendor, and amount which I need, so all I need added is the total value of the checks issued by checkbook. Is this easy? I am not proficient with Report Writer, but I hope this has been blogged about by a GP guru so i can just readup on how to update the Report Writer report.
Thanks,
Dale
*This post is locked for comments
Tim,
It was great solution for the problem. Helped me to resolve my problem.
Best Regards,
Sunneil
Tim,
Thank you for the details. It now works!
Have a great holiday weekend.
Best regards,
Dale
I'd say nothing is easy with Report Writer but this is actually quite easy.
If you open this report in RW:
A couple more housekeeping items to consider:
Good luck
Tim
Leslie,
Thanks for the response and sorry that I was not clear. I just need a cumulative total/subtotal by check book id for the date range specified. So, if I ran a check book report for May 1 - 23, I would like the report to provide a cumulative total for May 1-23 (ie, I do not need a daily subtotal buried within the cumulative total).
Best regards,
Dale
So, do you need a subtotal for every day? From reading your requirements, I don't get exactly what you mean but I've modified that checkbook register report many, many times. in a perfect world, what would the checkbook register look like?
Kind regards,
leslie
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156