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
After doing that, you can setup the Expense Distribution Tables which is in Accounts Payable Setup>Expense Distribution Table Maintenance
Now, when you are in Accounts Payable Invoice Data Entry, you can select the “Exp. Distribution Table” to use the tables you just setup.
Here is an example already setup that is using the percentages
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:
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!