Line ActionsAdministration > Maintenance > Distribution Group
A pre-defined set of General Ledger account allocations can be defined here as well as setting up rules to automatically default them in the Requisition/Check Request and Purchase Order modules based on LocationSite ID, Vendor, Item and/or Department. Distribution Groups will default to Expense Sheet lines based on Department. Automatic selection of a Distribution Group is based on the most specific being applied first. The following is a example of the defaulting logic:
Distribution Group Setup for Example:
Group ID |
Vendor |
Item |
SiteLocation |
Department |
DG-A |
ACME |
|
|
|
DG-B |
ACME |
|
NORTH |
DIST |
DG-C |
|
|
NORTH |
|
Distribution Groups Defaulted for Requisition Example:
RQ Vendor |
RQ Item |
RQ SiteLocation |
RQ Department |
Distribution Group Found |
ACME |
100XLG |
SOUTH |
IT |
DG-A |
ACME |
100XLG |
NORTH |
DIST |
DG-B |
As a user changes the LocationSite ID, Vendor and/or Item fields on a Requisition/Check Request line item, any appropriate distributions will automatically be applied to that line. If the Manual checkbox is selected on the Requisition/Check Request lines GL Distribution page, automatic application will be suspended, but Distribution Groups can still be selected manually if desired.
On the Receiving / Invoice Matching pages, the GL Distributions control is available to view or edit the GL accounts that were carried over from the corresponding Purchase Order. Therefore, if you edit fields or create a non-PO type transactions on the Receiving / Invoice Matching pages, distributions groups will not be applied automatically upon Save/Submit. In this case, if desirable, you still have the option to select a Distribution group using the GL Distributions control to manually apply pre-determined distributions.
As a user changes the Department on an Expense line item, any appropriate distributions will automatically be applied to that line. If the Manual checkbox is selected on the Expense lines GL Distribution page, automatic application will be suspended, but Distribution Groups can still be selected manually if desired.
G/L Distributions are only available when the Expense solution has been scripted to integrate with Accounts Payable and is not applicable for the Dynamics GP Project Accounting interface
The Analytical Accounting button available at the bottom of the Distribution Group page will allow users to assign values to Dimensions applicable for the selected G/L Account Distribution line. The Dimensions displayed will be based on the assignments made within the Analytical Accounting configuration within Dynamics GP. Analytical Accounting allocations assigned within a Distribution Group will default to the line G/L Distributions upon selection of a G/L Distribution Group. Users will be able to override the default Analytical Accounting allocations using existing functionality.
This field is only available when Intercompany is registered to identify the target company for the Distribution Group.
Enter up to twenty (20) alphanumeric characters as an identifiable name or code for the Distribution Group.
Enter up to sixty (60) alphanumeric characters for a corresponding description for the Distribution Group.
This field is only available when Intercompany is registered to identify a specific company when selecting Location.
If specified and a transaction line matches this value then the Distribution Group will be automatically defaulted unless a more specific Distribution Group is found or other entry fields specified on this Distribution Group do not match the transaction.
This field is only available when Intercompany is registered to identify a specific company when selecting Vendor.
If specified and a transaction matches this value then the Distribution Group will be automatically defaulted unless a more specific Distribution Group is found or other entry fields specified on this Distribution Group do not match the transaction.
This field is only available when Intercompany is registered to identify a specific company when selecting Item.
If specified and a transaction line matches this value then the Distribution Group will be automatically defaulted unless a more specific Distribution Group is found or other entry fields specified on this Distribution Group do not match the transaction.
If specified and a Requisition/Check Request or Expense line matches this value then the Distribution Group will be automatically defaulted on the line unless a more specific Distribution Group is found or other entry fields specified on this Distribution Group do not match the Requisition/Check Request.
If LocationSite ID, Vendor, Item and Department are blank then the Distribution Group will not be defaulted onto any Requisitions or Check Requests.
Sum of Assigned Distribution Percentages. This value must equal 100 in order to save.
Amount of Distributions that remain unassigned. This value must be 0 in order to save.
Click this box to permanently remove a distribution line from the group.
This field will accept a format such as ”R1853-?????”, when a user select this group the values in the ? marks will be replaced with the corresponding values from the Requisition/Check Request G/L Account. So if the user enters a GL of ”Z8888-1234” on the Requisition line, then the resulting Account code will be ”R1852-1234”.
If any of the resulting GL Accounts for the Distribution Group are not valid then NO distribution group will used.
This field will only be available when the 'Enable G/L Analysis on Distribution' System Setting has been enabled to select a G/L Analysis code for purchasing distributions. This field will not be restricted since the G/L Account is defined as an overlay for Distribution Groups and actual values will be validated upon transaction save when Distributions are applied.
Identifies the percentage that will be distributed to the assigned account.
Line Actions
