Setting Up Accounts Payable Expense Distribution Tables in Sage 100 ERP (MAS90, MAS200)

Setting up Templates for Distributing GL Accounts in Accounts Payable

Not everybody is aware that a few years ago Sage added the ability to setup templates so that when you post an AP bill it would get allocated to a variety of GL Accounts on the fly.  I actually designed this enhancement when it was built by Macabe Associates for one of our clients.  Macabe was later acquired by Sage and many of their enhancements were added into base Sage 100 ERP like this one.

To set it up, :

  • First go to the Accounts Payable>Setup>Accounts payable options screen.  From their click on the entry tab.
  • Check the box that says “Allow Total Distribution to be less than 100%” and hit Accept

Sage 100 ERP Consultant Accounts Payable I

 

After doing that, you can setup the Expense Distribution Tables which is in Accounts Payable Setup>Expense Distribution Table Maintenance

Sage 100 ERP Consultant Accounts Payable II

Now, when you are in Accounts Payable Invoice Data Entry, you can select the “Exp. Distribution Table” to use the tables you just setup.

Sage 100 ERP Consultant Accounts Payable III

Here is an example already setup that is using the percentages

Sage 100 ERP Consultant Accounts Payable IV

 

If you setup a table with 0%, you can use it as a template to quickly ‘bang in’ your data with the GL account codes populated:

Sage 100 ERP Consultant Accounts Payable IV

Hopefully you’ve found this tip helpful.  As usual, if you need any assistance with your Sage ERP 100 solution, give us a call or click on the chat box below!

2014-08-29T16:04:36+00:00 August 29th, 2014|SAGE|Comments Off on Setting Up Accounts Payable Expense Distribution Tables in Sage 100 ERP (MAS90, MAS200)