Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

How to Create a calculation field in Report Writer

Posted on by 210

How to Create a calculation field in Report Writer that Sum per column, for example:

Currency USD
200.00
300.00
500.00

Total Curr: 1,000

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: How to Create a calculation field in Report Writer

    Hi,

    If you drag the data field into the footer, you'll need to change the Display Type to 'Sum' because I think the default is 'Last Occurrence'.

    Kind regards,

    Leslie

  • Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: How to Create a calculation field in Report Writer

    Hello!

    One thing that I would like to point out about the Article that Abdallah had mentioned is that the Report Writer KB articles should be used as a guide. This one in particular is for Bank Rec and Payroll however, it does explain how to create a Calculated field in report writer. You just need to know the information you are looking for.

    ~Thomas Newcomb

    ------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Create a calculation field in Report Writer

    Dear Leslie

    thank you for mention i edit it https://www.dropbox.com/s/dk959piniq9wtbi/Capture22.PNG?dl=0

    thank you

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: How to Create a calculation field in Report Writer

    Abdallah,

    When I clicked your link I went to the article numbered 857086, but it was about

    "Error message when you try to log on to Microsoft Dynamics GP or open a window or a report in Microsoft Dynamics GP: "You don't have security privileges to this window. Contact your system administrator for assistance" "

    I don't think this will help us with a calculated field. You probably had a different KB in mind; do you recall its number?

    Kind regards,

    Leslie

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Create a calculation field in Report Writer

    Dear Vielka Colon

    you didn't need to make a calculated field to calculate the sum of the prices there is already filed ready made you just only drag it and drop in the footer of the invoice

    but if you want to make another one you can go to https://support.microsoft.com/en-us/kb/950780

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans