1 min read

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

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

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.

Sage 100 ERP Consultant Accounts Payable I

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

Sage 100 ERP Consultant Accounts Payable II 

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

Sage 100 ERP Consultant Accounts Payable III 

Example of Expense Distribution Table setup with percentages:

Sage 100 ERP Consultant Accounts Payable IV

Example of Expense Distribution Table setup with 0%.

Sage 100 ERP Consultant Accounts Payable V 

Sage 100 ERP Consultant Accounts Payable VI

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


Sage 100 ERP (MAS90): How to Autocreate POs from Sales Order Entry

Sage 100 ERP (MAS90): How to Autocreate POs from Sales Order Entry

Written By Sage 100 ERP Consultant Oasis Solutions Group Louisville, KY In Sage 100 ERP (MAS 90), Purchase Order offers multiple options related to...

Read More
Sage 100 ERP (MAS 90): How to Correct an Unbalanced Trial Balance

Sage 100 ERP (MAS 90): How to Correct an Unbalanced Trial Balance

If you are having trouble identifying what is unsettling your Sage 100 ERP (MAS 90) Trial Balance please find our Sage 100 ERP quick tip below to...

Read More