BTerrell Group Blog

Sage 300 ERP: AR Aged Trial Balance Reporting using PowerPivot

Posted by Tony Zhang on Wed, Jun 26, 2013

This blog introduces the Sage 300 ERP A/R Aged Trial Balance Report, and presents solutions to address challenges like adding more Aging Periods, grouping by National Account, filtering by the Account Set (AR control account) at transaction level, and performance issue - using PowerPivot. PowerPivot is a free add-in to Excel 2010 and is a built-in functionality of Excel 2013.

Read More

Tags: Sage 300 ERP, A/R, Accounts Receivable, AR aged trial balance report