Reporting: GP Top 5 AP

Reporting: GP Top 5 AP

How to build a top x report, using BI360

About this course

Jim Hummer of Solver Support builds a Dynamics GP top 5 AP report in BI360. These concepts apply to other types of transactions, such as sales, and a differing number of "top" results.

Topics include:

  • Using Report Composer to validate the Payable Transaction summary amounts in Dynamics GP
  • Building a Vendor report in Report Designer with document related fields
  • Filtering the document type: work, open, and/or history
  • Period parameters and custom Period Calc syntax
  • Drilldown to transactions
  • Part 2 continues with adding a graph to the design

Posted 12/18

Curriculum~ 30 minutes

  • Dynamics GP Top 5 AP Report, part 1a
  • Dynamics GP Top 5 AP Report, part 1b
  • Dynamics GP Top 5 AP Report, part 2

About this course

Jim Hummer of Solver Support builds a Dynamics GP top 5 AP report in BI360. These concepts apply to other types of transactions, such as sales, and a differing number of "top" results.

Topics include:

  • Using Report Composer to validate the Payable Transaction summary amounts in Dynamics GP
  • Building a Vendor report in Report Designer with document related fields
  • Filtering the document type: work, open, and/or history
  • Period parameters and custom Period Calc syntax
  • Drilldown to transactions
  • Part 2 continues with adding a graph to the design

Posted 12/18

Curriculum~ 30 minutes

  • Dynamics GP Top 5 AP Report, part 1a
  • Dynamics GP Top 5 AP Report, part 1b
  • Dynamics GP Top 5 AP Report, part 2