When entering AP it would be helpful for MAS90 to remember multiple GL codes rather than just one.
If we're going to go this route we should also start predetermined allocations of invoices.
Ways to distribute:
1) Fixed amount - Up to a certain amount
2) Percentage split
A) Original Invoice Amount
B) Original Invoice Less: Fixed Amount
One account needs to be able to add any excess amounts that haven't been distributed.
Selecting both would allocate excess evenly.
Ex.
Printer usage is $1,000 for the first 10,000 pages printed; any overages are .02 per page. Our prior 3 month period determines our bill for the next 3 month period.
Our bill is usually $1,100 setup would be:
6100-10-999 Printer Expense |$400 - Fixed Amount
6100-20-999 Printer Expense |$525 - Percentage 75%: Less Fixed
6100-30-999 Printer Expense |$175 - Percentage 25%: Less Fixed
So, if our invoice were to be $900 we would distribute as follows:
6100-10-999 Printer Expense |$400 - Fixed Amount
6100-20-999 Printer Expense |$375 - Percentage 75%: Less Fixed
6100-30-999 Printer Expense |$125 - Percentage 25%: Less Fixed
by: Michael H. | over a year ago | General Enhancements
Comments
This has already been added to MAS 90/200 under the Expense Distribution Tables feature.