Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

On this page you will find information about the option to add custom columns to the pop-up that will help you to determine which transactions to select in order to reconcile the bank statement line.

Table of Contents

...

General pop-up information

The Bank Reconciliation tool uses a pop-up window to show the user potential transactions the that can be selected to reconcile. The pop-up shows by default the following columns:

  • Select
  • Transaction ID
  • Date
  • Type
  • Remaining
  • Disc date (if enabled)
  • Disc available (if enabled)
  • Disc. taken (if enabled)
  • Discount (if enabled)
  • Payment
  • Total
  • Memo
  • Percentage paid
  • Payment difference reason (if enabled)
  • Payment discount (if enabled)

To get better insights in the transactions available for reconciliation we offer the user the option to include additional columns that display data from the transaction 

Adding a custom column

To add a custom column navigate to CUSTOMIZATIONSETUP→BANK RECONCILIATION SETUP→BANK ACCOUNT CONFIGUATIONCONFIGURATION. At the bottom of the page go to the sub tab named "Additional Parameters & Fields""Bank Statement Additional Columns". Press on the button named "New Bank Statement Additional Columns"

...

Now save the configuration. You should see the newly create configuration in the sublist.

Result in the pop-up

If you open the pop-up on a statement that is related to this bank account configuration then you should see the additional columns

...