BTerrell Group Blog

Document Management in Intacct

Posted by Binbin Zhai on Tue, Apr 28, 2015

Are you tired of digging the invoices from piles of document? Are you desperate to go paperless and to save some trees?

Intacct provides a simple and convenient attachment management solution. You can simply and effortlessly attach invoices, contracts and bank statements in every transactions and in every dimensions (i.e. customer, vendors and projects).

First of all, we need to create several folders for our attachments. In this way, the thousands of documents will not crowd together. You also can create subfolders.


Afterwards, you can freely add attachments by using the Select Attachment screen. You even can drag the file into the screen if you do not like the Choose Files from your computer's complex folder organizing tree.


What you need to attach multiple documents in one place? For example, the AR team likes to keep records of customer contracts and tax forms. Even though there is only one field for attachments, you actually can attach multiple documents in one attachment.

And, your employees can attach their receipts for their expenses, which will save the accounting team a lot of time on filing receipts.

If these out-of-the-box attachment functions cannot satisfy your passion and requirements on document management, there are multiple add-on services on the market place, such as Nexonia and Docassist. If you are interested in, and would like to know more about them, please subscribe to our blog or contact us!

Tags: AP, document management

Sage 300 ERP (Accpac) AP Aging Report Using PowerPivot

Posted by Tony Zhang on Wed, Sep 18, 2013

Following my previous blog about creating AR aging reports using PowerPivot in Excel, I’d like to cover AP (Accounts Payable) in this blog.

The Excel data model for AP aging is similar to that of AR. The caveat is, unlike AR where you can use an invoice and/or document  number to join the invoice and receipts tables, in AP you have to combine vendor and invoice to join the invoice and payment tables since you could potentially have the same invoice number from different vendors.

Let’s take a look at the out-of-the-box AP aged payable report first. As the screenshot below shows, it is very sophisticated report.

Sage 300 ERP AP Report

Sage 300 ERP A/P Aged Payables Detail Report

When you use an Excel data model using PowerPivot to this table, you get the benefits of flexibility to let you look at things such as aging bucket and filter by a host of different factors. You also get an improvement in the report performance. As circled in the screenshots below, users can edit or add the aging bucket as needed. In the same worksheet, there is a statistics by document types update when you change the Cut-Off year and period.

PowerPivot Table for AP Aging Using Sage 300 ERP Data


AP Graphs and Statistics from PowerPivot Using Sage 300 ERP Data

Such a report can be uploaded to Office 365 and shared with others in your organization. In this example, I shared it with everyone.

Click here to get a static version of the report to get a sense of the look and feel. However, you cannot interact with the slicers, etc. from this version.

If you are interested in playing with the report, you can download a copy from this link. Please note, this report is developed in Excel 2013 Professional Plus and you need the same Excel version to interact with the worksheet. Also note that this worksheet is protected, so you'll be unable to modify it or connect with your Sage 300 ERP instance.

If you would like to get an unprotected version of the worksheet and/or connect to your Sage 300 ERP system, don't hesitate to ask for a FREE 30-minute consultation from BTerrell Group...we'd be happy to help!

Free Consultation

Tags: Sage Accpac, Sage 300 ERP, AP, accounts payable, AP aging

Sage Fas Fixed Assets Training

Posted by Meredith Gooch on Mon, Aug 31, 2009

Learn how you can gain complete control over your entire fixed asset lifecycle - from acquisition to disposal. Join Terrell & Terrell for hands-on training with Sage FAS Fixed Assets on September 16-17. To register, simply send an email to Meredith Gooch. If you want to learn more about this solution that will help you reduce the costs associated with incorrect asset management, please visit our solutions page or contact Rufus Vernon. Each day is approved for 8 hours of CPE credit.

- Meredith Gooch, Marketing Manager

Tags: Sage Accpac ERP, AP, accounts payable, Sage FAS Fixed Assets, training, GL, PO, general ledger, purchase order, inventory

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

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

Sage FAS Fixed Assets

Posted by Meredith Gooch on Thu, Jul 30, 2009

Sage FAS Fixed Assets gives companies complete control over their entire fixed asset lifecycle - from acquisition to disposal. With this increasing control comes the peace of mind that companies are properly managing and depreciating their fixed assets, which affects insurance and tax costs. Features include an intuitive interface, seamless integration with the Inventory, PO, AP, and GL modules, comprehensive reporting, and asset reconciliation. You may recall that Sage Accpac version 5.5 comes with an integration to Sage FAS that is better than ever before.

We will be attending training to learn even more about the latest and greatest enhancements and features in Sage FAS and hope to share that knowledge with you in a formal client training session toward the end of August. Please contact Meredith Gooch if you are interested in attending Sage FAS training or Rufus Vernon if you would like to know more about Sage FAS. You can also view a recorded Webcast introducing Sage FAS on our Web site.

- Rufus Vernon, Director of Sales

Tags: Sage Accpac ERP, AP, accounts payable, Sage FAS Fixed Assets, training, GL, PO, general ledger, purchase order, inventory