Question:
How do I adjust the percentages on my MAD ( Multiple Account Distribution) account numbers? I need to add one additional distribution.
Resolution:
1.) From the A/P File Maintenance Menu select Multiple Account Distribution
2.) Selected the distribution code(s) using option 1 (update) that required a percentage change
3.) Add one additional distribution per code and adjusted the existing ones accordingly so that the total percentage amount is 100%
From the Manual:
The Multiple Account Distribution feature of the A/P System allows the user to create an unlimited number of predetermined G/L distributions or allocations that cross Corp/Div./Dept./Job/Acct lines. Whereas the Chart of Accounts - Auto-Distribution feature allows allocation over various corporations, divisions and departments for ONE G/L account, the Multiple Accounts Distribution feature allows for allocation to MULTIPLE accounts over various corporations, divisions, departments and jobs. Each line distribution is assigned a percentage, and the total allocation must equal 100%.
Any transaction (i.e. invoice, hand disbursement, or G/L journal entry) can be automatically allocated according to the multiple account distributions set up in this file. The Multiple Account Distribution feature is activated on an entry by entry basis in the A/P entry programs by entering the appropriate multiple account distribution number at the mad# field. See the note below for additional information.
Upon selection of this menu option, press F10=ADD. The system automatically assigns the first account distribution# and increments by 1 as more are added. Each distribution# refers to a series of allocations equaling 100%. First key the desired description for this distribution. Key in the first corp#, div#, dept# (if any), job# (if any), acct# and distribution% for the first allocation. Continue with the rest of the allocations, making sure the percentages add up to 100%. If you want the system to automatically allocate the 100% based on the number of lines entered here, leave the distribution% field blank for each line and press F7. When all entries have been made for this distribution#, press ENTER to verify. Press F12 to add the next multiple account distribution. See sample screen below.
Apfm10 Multi-Account Distribution Maintenance
Account Distribution Number: 117 Desc: INSURANCE ALLOCATION
Fnd Pgm Dpt Job # Acct# Description Dist% D=Del
1 1 855000 INSURANCE-DISABIL 10.00
1 1 855100 INSURANCE-GENERAL 10.00
1 1 855200 INSURANCE-GROUP H 10.00
1 2 855000 INSURANCE-DISABIL 10.00
1 2 855100 INSURANCE-GENERAL 10.00
1 2 855200 INSURANCE-GROUP H 50.00
Paul Fuller
Comments