Enable Expense Distribution Tables
- Open Accounts Payable, Setup, Accounts Payable Options.
- Select the Entry tab.
- Select the Enable Expense Distribution Tables checkbox.
- Decide whether to select the Allow Total Distribution to be Less Than 100 Percent checkbox.
- Click Accept.
Note: This option isn't available when Accounts Payable integrates with Job Cost. If you select
Enable Expense Distribution Tables, you can't select the Job Cost integration option.
[Writing Style Agent | Word] Note: When you select Allow Total Distribution to be Less Than 100 Percent, table totals can remain below 100 percent. Manually distribute the remaining balance during data entry.
Note: When you don't select this option, the distribution percentages must equal 100 percent during table setup.
Create Expense Distribution Tables
- Open Accounts Payable, Setup, Expense Distribution Table Maintenance.
- In Table Code, enter up to six alphanumeric characters.
- In the Description, enter up to 30 characters.
- Enter one or more G/L Account and Percent values.
- Click Accept.
Example: Create a table with three General Ledger accounts. Assign 30% to the first account, 30% to the second account, and 40% to the third account.
Note: If you enabled Allow Total Distribution to be Less Than 100 Percent, the table totals can remain below 100 percent. You can manually distribute the remaining balance during data entry.
Note: You can also create tables without distribution percentages and manually distribute the entire balance.
Note: Total distribution percentages can't exceed 100 percent. When you don't allow totals below 100 percent, the total must equal 100 percent.
Use Expense Distribution Tables for invoices
- Open Accounts Payable, Main, Invoice Data Entry or Repetitive Invoice Entry.
- On the Header tab, enter or select a Table Code in the Exp Distribution Table.
- Complete the invoice entry.
The system automatically distributes the invoice amount on the Lines tab using the table's G/L accounts and percentages.
Note: The Exp Distribution Table field becomes unavailable after distribution occurs or after you enter G/L accounts on the Lines tab. Delete the existing lines before selecting a different table.
Use Expense Distribution Tables for manual checks
- Open Accounts Payable, Main, Manual Check and Payment Entry.
- Create an invoice on the Lines tab.
- Enter a Table Code in the Exp Dist Table column.
The system applies the predefined distribution to the invoice.
Note: For additional information about invoice entry, repetitive invoices, or manual check entry, see the related product documentation.