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

AR Customer List: Little Known/Little-Used Function in Sage 300 ERP

Posted by Anthony Cox on Wed, Jun 19, 2013

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. 

Read More

Tags: Sage 300 ERP, A/R, Accounts Receivable, AR customer list

Announcing Accpac Back to School Training

Posted by Meredith Gooch on Mon, Aug 10, 2009

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

Read More

Tags: Sage Accpac ERP, Accpac, A/R, AP, accounts payable, Accounts Receivable, bank services, training, GL, general ledger, FAS Fixed Assets, Financial Reporter

Sage Accpac ERP Tip: Save Settings as Defaults FAQ

Posted by Meredith Gooch on Thu, May 28, 2009

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

Read More

Tags: Sage Accpac ERP, A/R, Accounts Receivable, Trial Balance Report, default settings, customer report, customer transaction report, retainage report, AR Troubleshooting

Sage Accpac ERP Tip: Save Settings as Defaults

Posted by Meredith Gooch on Mon, May 25, 2009

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

Read More

Tags: Sage Accpac ERP, A/R, Accounts Receivable, save settings as default, Trial Balance Report