A/P Expense Distribution Entry (APDT) allows the user to simplify and automate frequently utilized General Ledger Distributions for A/P Invoice Data Entry. (This feature is also implemented in Manual Check Invoice Distribution Entry for a new invoice). Where standard Sage 100 ERP allow for only one default General Ledger Account to be assigned to a Vendor, which then defaults to 100% of the Invoice Amount, Distribution Table Codes allow for multiple General Ledger Accounts to be assigned on a percentage basis of the total Invoice Amount. Distribution Table Codes can be maintained on the Accounts Payable Setup Menu, in Distribution Table Maintenance. Within each Code, multiple Distribution Lines and individual percentages of distribution can be assigned to each Code. Two types of Distribution Table Lines are supported:
- Multiple discrete General Ledger accounts can be assigned to a Distribution Table Code, each with their own percentage. These override the default Vendor General Ledger Account.
- A General Ledger Segment can be indicated and percentages assigned to values for that segment. These are applied to the default Vendor General Ledger Account. Default Distribution Table Codes can be assigned to each Vendor on the Main tab in Vendor Maintenance.
In AP Invoice Entry, if a Distribution Table is assigned in the Header panel, the Lines panel is calculated based on the Table Type and General Ledger Accounts. The Line Panel Distribution can then be manually edited if desired.
In AP Manual Check Entry, if a Distribution Table is assigned in the Header panel, the Lines panel is calculated based on the Table Type and General Ledger Accounts for a new not-on-file invoice. The Line Panel Distribution can then be manually edited if desired.
A new feature for APDT starting with version 4.20, allows the entry of a Distribution Table by detail line if the Table is defined by Segment. A UDF is defined using the Distribution Table Code, and added to the G/L Distribution panels for AP Invoice Entry and AP Manual Check Entry through Custom Office.