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 :
Microsoft Dynamics GP (Archived)

Batch Totals by Month

(0) ShareShare
ReportReport
Posted on by 30

Hello

Daily we have a batch imported behind the scenes from another program to GP.  I was wondering if there is a way to produce a Smartlist or report that has the total for each batch instead of showing each transaction in the batch.  Ideally I would like to have the dates and the batch total on a spreadsheet by month.  I was unable to find the correct parameters under the Smartlist builder to produce that information.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,619 Super User 2025 Season 2 on at
    RE: Batch Totals by Month

    Because batch info is not maintained in the database, only at the transaction level, you would have to develop queries that sum transaction totals by Batch ID, for each module.  You could do this with Excel refreshable reports and dump them into Pivot tables for summarizing.

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

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans