Use this procedure to set up expense distribution
tables with general ledger accounts and corresponding percentage
amounts. You can then select the tables in Invoice
Data Entry, Repetitive
Invoice Entry, and Manual
Check and Payment Entry to distribute invoice balances and
payments to the selected accounts based on the defined percentage
amounts. A table can be selected for any invoice with no existing
lines in Invoice Data Entry and Repetitive Invoice Entry and when
entering a new invoice in Manual Check and Payment Entry.
-
Select Accounts Payable Setup
menu > Accounts Payable Options. The Accounts
Payable Options window appears.
-
In Accounts Payable Options,
on the Entry tab, select the Enable Expense Distribution Tables
check box. For more information, see Accounts
Payable Options - Fields.
-
To allow the total distribution
amount for all accounts in each table to be less than 100 percent,
select the Allow Total Distribution to be Less than 100 Percent
check box. When tables with a distribution percentage total less
than 100 percent are selected in data entry tasks, the remaining
balance must be manually distributed. Click Accept.
-
Select Accounts Payable Setup
menu > Expense Distribution Table Maintenance. The Expense
Distribution Table Maintenance window appears.
-
In Expense Distribution Table
Maintenance, type a code and a description for the table. For
more information, see Expense
Distribution Table Maintenance - Fields.
-
Enter the general ledger account
numbers and the percentage amount that you want to be distributed
to each account. The total distribution amount appears in the
Total Percent field.
-
If the total distribution
percentage is less than 100 percent, you can click a line with
an account number and then click Apply Balance to allocate the
remaining balance to the account on the current line.
-
After entering all of the
accounts, click Accept.
The distribution table is now set up and ready
for use in data entry tasks.
Show/Hide All