Skip to the main content.

 

FREE ASSESSMENT

StarShip

 


Paya Nuvei Logo 2

 

AvidXchange Logo USE

 

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


ERP Implementation Partner Selection Tips and eBook

ERP Implementation Partner Selection Tips and eBook

How to Find the Right ERP Implementation Partner Working with the right ERP implementation partner will be critical to the success of your ERP...

Read More
Are You Outgrowing Your ERP Manufacturing Software?

Are You Outgrowing Your ERP Manufacturing Software?

3 Tips for Finding the Best ERP Manufacturing Software for Your Business If your manufacturing company is outgrowing your software the search for...

Read More
5 Ways a New Manufacturing ERP Helps Your Business Grow

5 Ways a New Manufacturing ERP Helps Your Business Grow

Grow Your Business with a New Manufacturing ERP Solution The economy is constantly changing, and manufacturing companies have been hit hard by recent...

Read More