BTerrell Group Blog

Docassist, A/P workflow, and G/L close

Posted by Brian Terrell on Thu, Jun 26, 2014

Yesterday, a prospect asked how Docassist, a cloud based document management and workflow automation application, could help his company discover and account for unapproved Accounts Payable bills received in the first days of one fiscal period but belonging in the prior period's results. In other words, these bills would be added to the A/P workflow in the first few days of a month and remain unapproved and unposted up to the moment the accounting department would be ready to close the books. As our prospect noted, "We don't want to close out a month and omit an invoice while the invoice may still be in the approval process."  

6 26image1

I referred this question to Don Lyman, Chief Executive Officer at Docassist, and received this reply:

This question highlights many advantages Docassist brings to the A/P business process. Instead of losing visibility to paper bills as they route manually from one approver to the next, Docassist users may check on those documents' progress in multiple ways. For instance, the Docassist Workflows Dashboard indicates unapproved A/P bills. Also, Docassist allows users to easily create, save, and run a document search to quickly find unprocessed bills meeting certain criteria, such as a bill dated in the last few days of the prior month or the first few days of the current month. Finally, Docassist includes a configurable email notification feature informing users of the status of pending A/P bills.


Many Docassist functions run directly from the Intacct desktop, such as data and document entry, A/P bill review, and transaction lookups.  For reports that currently only run directly from Docassist, the Docassist Professional Services Group can tweak those to make them accessible directly from Intacct. This would add reporting to those mechanisms mentioned previously by which a bill could be highlighted for General Ledger accrual or other special treatment. Of course, accruals could be automatically reversed in subsequent months by using Intacct's standard functionality. The bottom line is that Docassist's multiple features for ensuring transaction visibility make month end smoother and more accurate.

Since 2002, Docassist has provided market leadership in cloud document management and workflow automation.  They serve many industries, including financial services, hospitality, not-for-profit, education, manufacturing, technology and healthcare.  In addition to tight integration with Intacct, Docassist has similar connectivity to Sage 300 ERP.  To find out more about Docassist, please contact me at or request additional information from

Tags: accounts payable, general ledger, docAssist

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

Top TEN Reasons to Upgrade to Sage 300 ERP 2012

Posted by Meredith Gooch on Tue, Nov 06, 2012

Simplify Processes. Improve Visibility. Stay Connected.

1. Reduce time navigating through your system with Visual Process Flows, which you can customize by user roles and for your business.

2. Improve productivity with enhancements throughout the system such as: Entered By, On Hold Reason, and Requested By fields in Order Entry; copy order and create PO directly from order entry; and reverse GL batches.

3. Enhance usability with easier to read tables, an improved Finder, and improved end-user

4. Get the information you need, faster! New Inquiries for operations modules facilitate quick
access to customized lists, which provide the answers you need and lower custom reporting costs.

5. Simplify update processes using the new Sage Advisor Update.

6. Save time when processing payments - capture pre-authorized payments during shipment entry or invoice entry, and invoice multiple pre-authorized payments in a single batch.

7. Make informed decisions with comprehensive reporting utilizing the new Sage Intelligence
Reporting financial report designer and reporting tree capabilities.

8. Expand customized reporting capabilities with the updated SAP Crystal Reports® runtime engine for .NET Framework 4, and new options in several standard reports.

9. Accelerate growth and stay connected with Sage CRM enhancements that improve information flow between the front and back offices.

10. Efficiently and cost effectively manage the shipping process and rate shop with an optional service that streamlines shipping and reduces costs.

Tags: Accpac ERP, accounts payable, Accpac 6, Accpac 6.0, accpac 5.4 payroll, accpac 6.0 security, accpac 6.0 security settings, Accpac 6 FAQ, accpac 5.4, accpac 5.6 update, accpac 6.0 features, accpac 6 features

What happened to my Accpac?

Posted by Meredith Gooch on Mon, Oct 22, 2012

Sage renamed all of the Accpac products:

o       Sage ERP Accpac 100 is now Sage 300 Standard ERP.
o       Sage ERP Accpac 200 is now Sage 300 Advanced ERP.
o       Sage ERP Accpac 500 is now Sage 300 Premium ERP.

Sage now has a simpler way to present the increasing levels of product capability available to you. Like luxury automobiles, the numbers associated indicates the sophistication level of the product. For example, a BMW 135 has fewer features than the 5 series.


So Sage renamed its core product offerings under the Sage 50, Sage 100, Sage 300, and Sage 500 banners, which in turn helps simplify finding additional Sage solutions that are the right fit for your business, when and if you need them, at any stage in your business growth cycle.

Contact Anthony Cox for more information at 866-647-2611 ext 127 or email

Tags: Sage Accpac ERP, accounts payable, Accounts Receivable, ERP Accpac, ERP, Accounts Payable challenges, Accpac Accounts Payable, SageCRM for Accpac

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