Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Running/Cumulative total for Report Writer

Posted on by 3,055

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

  • Sunneil Chaudhary Profile Picture
    Sunneil Chaudhary 330 on at
    RE: Running/Cumulative total for Report Writer

    Tim,

    It was great solution for the problem. Helped me to resolve my problem.

    Best Regards,

    Sunneil

  • Dale Coulthard Profile Picture
    Dale Coulthard 3,055 on at
    Re: Running/Cumulative total for Report Writer

    Tim,

    Thank you for the details.  It now works!

    Have a great holiday weekend.

    Best regards,

    Dale

  • Tim W Profile Picture
    Tim W 2,925 on at
    Re: Running/Cumulative total for Report Writer

    I'd say nothing is easy with Report Writer but this is actually quite easy.

    If you open this report in RW:

    • You add the PaymentAmount calculated field into the footer 1 (F1) section (drag it to this section)
    • Line it up under PaymentAmount field in the body
    • Double click the field and set the Display Type to SUM and you will sum the payment values for each checkbook group as you would expect.

    A couple more housekeeping items to consider:

    • I would also add the DepositAmount calcualted field under the deposit column and set it to sum also just for consistancy.
    • You might add a line of dashes "-------" above the fields you add so you readily see them as totals.
    • I would also be sure I line the field up vertically with the existing Check field (which is set to COUNT so as to count the records so your footer values all line up.
    • Be sure you set security to the modified report

    Good luck

    Tim  

  • Dale Coulthard Profile Picture
    Dale Coulthard 3,055 on at
    Re: Running/Cumulative total for Report Writer

    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

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Running/Cumulative total for Report Writer

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans