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.
BTerrell Group Blog
As a Sage client, you may be familiar with the benefits of building and working from call lists in Sage CRM. Often, this functionality provides an efficient methodology for a workflow involving identification of a subset of clients or prospects you may want to call on for a specific purpose (i.e. overdue invoices, recent orders, etc.). And as a salesperson, this concept is often helpful for following up with opportunities that were recently discovered, as in new prospects!
As helpful as this function is within Sage CRM, a close resemblance to it exists in Sage 300 ERP, although many users have been unaware of it – yours truly included. Thankfully, I benefit from a top-shelf team of consultants that often reveal to me new tricks of the trade. I thought you might want to see how this tool functions, so check out the attached video demonstration.
The demo shows how the little-used A/R Customer List, along with Customer Inquiry, Optional Fields and a telephone, can provide customer relationship management functions, although not on the same scale as Sage CRM. The Customer List simply allows a user to construct an actionable list of customers using criteria from the customer master.
Learn how to make the most of Sage Accpac ERP and join us for training this fall.
Sage Accpac ERP Back to School Training Schedule
Bank Services and Financial Reporter - Tuesday, September 15, 2009
Sage FAS Fixed Assets Part I - Wednesday, September 16, 2009
Sage FAS Fixed Assets Part II - Thursday, September 17, 2009
Accounts Payable - Tuesday, September 22, 2009
Accounts Receivable - Wednesday, September 23, 2009
General Ledger - Thursday, September 24, 2009
Check out our training schedule for additional details.
- Meredith Gooch, Marketing Manager
Q: When others log on, will they see my custom settings if I have saved them?
A: No, it is your own personal screen. Each user can have his/her own custom screen saved to their own preferences without having to change settings between users.
Q: Does every Sage Accpac ERP report have this function?
A: No. For example, in the A/R module, only 5 reports have this function:
1. A/R Trial Balance Report
2. A/R Customer Report
3. A/R Statement/Letters/Labels
4. A/R Customer Transaction Report
5. A/R Retainage Report
Q: How do I restore back to the default settings?
A: Under the “Settings” menu, select “Clear Saved Settings.”
- Sheila Zhang, Project Manager
Did you know that when you open the A/R Trial Balance Report in Sage Accpac ERP, you do not need to manually select the aging periods or customer ranges every time? Accpac can remember them for you.
After opening the A/R Trial Balance Report, you will see the default screen. No matter which fields you change, you end up losing your specifications after you have closed the A/R Trial Balance Report. The next time you open it again, all the criteria are restored to the original default values.
There is a way around this!
All you have to do is click on “Settings” at the top of the default screen and select “Save Settings As Defaults.” All the changes you have already made to the default screen will be recorded by Accpac so that the next time you open the A/R Trial Balance Report, you will see your criteria as you have saved them.
Check back later this week for FAQ’s about the this topic.
- Sheila Zhang, Project Manager