Page Comparison

...

In some situations bank statement lines are desired to be grouped either for reconciliation reasons - or to hide the detail (eg salary payments).

Image Added

1. Bank Reconciliation (Statement-centric):
   1. Any bank lines that are in a group will not show in the bank rec.
   2. The group will show on a line with:
      1. 'Group' in the Bank Balance column.
      2. The group Date in the Bank Date column.
      3. The group Description in the Bank Description column.
      4. The sum of the debit amounts of the bank lines in the group in the Bank Out-DR column.
      5. The sum of the credit amounts of the bank lines in the group in the Bank In-CR column.
   3. The group line will have all of the same functionality of a bank line:
      1. Match to an existing journal or batch.
      2. Be reconciled to an existing journal or batch.
      3. Create a journal according to the DR or CR amount.
      4. Create a new Journal Template (bank rec rule).
      5. Show a draft journal according to a bank rec rule.
2. If the user has secure feature Secure Features#CanPerformBankReconciliation with a qualifier greater than 0:
   1. On a bank line that has not been reconciled and is not a group, new right click option 'Add to new group':
      1. A new group will be created, with the Date and Description from the bank line.
      2. The bank line will be added to the group.
      3. A popup window will show the group and list the bank lines in the group.
   2. On a bank line that has not been reconciled and is not a group, new right click option 'Add to Date Description':
      1. One option for each unreconciled group shown in the bank rec.
      2. Multiple groups will be listed in order of the number of days difference between the bank line date and the group date.
      3. The bank line will be added to the group and contribute to its amount.
   3. On a group line a new right click option 'Show bank transaction group':
      1. A popup window will show the group and list the bank lines in the group.
   4. In the group popup window:
      1. The Date and/or Description for the group can be changed, and click Save in the popup.
      2. If the group has not been reconciled then a new right click option 'Remove from group'.
3. Right click option 'Delete all bank lines from here on' is not available if any of the lines that would be deleted are in a group. Remove from the group first.

...