Location
Tools >> Setup >> Financial >> Advanced Bank Reconciliation >> Deposit Groups
Layout
Overview
The Deposit Group Maintenance window provides the ability to create and maintain grouping information used to consolidate transactions during the Extract Transactions process. Multiple groups can be created.
Note: Transactions will always be grouped by date first before any other grouping criteria are applied.
Fields
Deposit Group ID – A unique ID for each Group created
Description – A Description for the Group ID
Next Deposit Number – The next Transaction Number to be used for the consolidated transaction. This will appear in the Reconcile window in the Document Number field.
Deposit Ref. Date Mask – Used when creating the reference for the consolidated transactions that appears in the Reference field in the Reconcile window.
• M – Month
• D – Day
• Y - Year
Deposit Ref Separator – Used when creating the reference for the consolidated transactions that appears in the Reference field in the Reconcile window.
Available Fields – Shows the fields that are available to group transactions by. To add a group, select it and click Insert.
Group Fields – Show the fields used when grouping transactions together in the reconcile window. The fields are listed in the order that the grouping will occur. Use the arrows on the right to move a field up or down.
Buttons
Save – Saves the Deposit Group
Clear – Clears all fields
Delete – Deletes the Deposit Group
Insert – Inserts an item into the Group Fields column
Remove – Removes an item from the Group Fields column
Source Documents – Opens a window which allows the selection of Dynamics GP document origins that the specified Deposit Group will be used for. This is required for each Deposit Group.
Field Expansion
The expansion button opens the Field Expansion window for the highlighted field in the Group Fields column.
Note: If the highlighted field is RM Cash Receipt Type, then the Expansion button will open the Fixed List Field Expansion. (see below for details)
Fields
First Character – Defines the beginning range of characters to use for grouping.
Last Character – Defines the ending range of characters to use for grouping.
Group By Specific Value – Allows the grouping to be based on some specific values and catch-all group for all other values.
Group On Values – Specific values are entered here. The “catch-all” group is specified by adding a ‘*’ to the start of the name.
Transactions not matching above values:
Process as blank value – This will still process transactions in a group.
Do not process – This will not process the transaction in a separate group.
Fixed Line Field Expansion
The expansion button opens the Field Expansion window for the highlighted field in the Group Fields column; when the highlighted field is RM Cash Receipt Type, it opens the Fixed List Field Expansion.
Fields:
Field Value – The Dynamics GP Value that will be grouped upon.
Group As – The name of the grouping in the Reconcile window.
Utilities
Utilities are the procedures used to maintain the data in the ABR system.
