ERP Consultant Blog

Sage 100 ERP Consultant Tip: How to Setup AP Expense Distribution Tables

Written by Christy Pfleger | Tue, Aug 19, 2014

As Sage 100 ERP consultants, resellers and solution providers we get a lot of questions from our clients on how to use Sage 100 ERP (formerly MAS 90 and MAS 200) more efficiently. In this blog we will cover a popular question we get on how to enable and setup Accounts Payable Expense Distribution Tables. Using Sage 100 ERP Accounts Payable Distribution Tables will speed up invoice data entry and efficiently allocate expenses.

Whenever you plan to activate a feature in Sage 100 ERP or upgrade or add functionality, be sure to consult with your Sage 100 ERP reseller before making any changes. If you have questions about a feature, they are available to assist. If you do not work with a Sage 100 ERP consultant, our contact information is below and we are happy to spend time with you to learn more about your situation.

Sage 100 ERP Consultant Tip: How to Enable and Setup Accounts Payable Expense Distribution Tables

First, go to the Accounts Payable/Setup/Accounts Payable Options and select the Entry tab:
•    Check the Enable Expense Distribution Tables checkbox.
•    Check the Allow Total Distribution to be Less Than 100 Percent checkbox and Accept.

Next, setup the Expense Distribution Tables from Accounts Payable Setup, Expense Distribution Table Maintenance:

 

During Accounts Payable Invoice Data Entry, select the Exp. Distribution Table to use the tables.

 

Example of Expense Distribution Table setup with percentages:

Example of Expense Distribution Table setup with 0%.

 

For more helpful tips CLICK on this link: Sage 100 ERP Consultant (formerly MAS 90 and MAS 200) Tips 

Business Software Solutions is a certified Sage 100 ERP reseller providing services for the past 13 years to Western & Central Oregon, Salem, Eugene, Springfield, Albany, Corvallis, Roseburg, Grants Pass, Medford, Ashland, Bend and Redmond, Oregon Sage 100 ERP customers. CONTACT US at 888-995-6464, EMAIL US at info@bss.us.com or visit our website at: www.bss.us.com to learn more about how we can help you with your Sage 100 ERP solution. If you are outgrowing your current business software, we offer a free consultation to discuss your options.

For more helpful Sage 100 ERP tips and resources, visit: http://www.businesssoftwaresolutions.info/links.html