You’re offline. This is a read only version of the page.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,188
Super User 2024 Season 2
#2
Martin Dráb
230,030
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (