web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Report Writer help wit...
Microsoft Dynamics GP (Archived)

Report Writer help with SOP Sales History Register

(0) ShareShare
ReportReport
Posted on by Mayra Humprey 3,125

Good day,

 License = GP 10 BE SP4

I have been requested to add a column adding all the subtotals, trade discount, tax amount.

Originally the report only contains the column of total document amount, but i had to include the other ones, now is the problem that i don't know how to do the formula on the report writer.

Like excel just =sum(f2: f38)

 Thanks in advance for your suggestions.

*This post is locked for comments

I have the same question (0)
  • Mayra Humprey Profile Picture
    Mayra Humprey 3,125 on at
    Re: Re: Report Writer help with SOP Sales History Register

    Good day Mariano,

    Thank you very much but Could you please widen up my limited knowledge on report writer.

    I did the following I open up Sop sales history register report on report writer.Then went to calculated "campos" and then created a new one. Wrote a name example = C Subtotals Docs, Results: Money in resourcers picked historical sales transaction and looked up for subtotal. so in the calculated expression do i have to add all the subtotals. The problem is that what if i miss a subtotal cell.

     Thank you very much in advance for your advice :) Have a nice day

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Report Writer help with SOP Sales History Register

    You will also need to include the field in the total band, then double-click to change the field property to Sum.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans