Versions Compared

Key

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

...

If you’re using the credit and debit amount fields, check that Workbook WorkBook is recognizing recognising it correctly as they can be interpreted differently. If it’s the wrong way round, you can either swap the debit and credit fields on the import specification or use the ReverseNumericValue script below.

...

ADDITIONAL FORMATTING OPTIONS - SCRIPTS

Scripts are used when additional formatting is required on an import. You can use them to delete extra lines at the bottom of the import or calculate 2 fields.

  • In the bank reconciliation data import go to the settings tab > select the add new script parameter button

  • Complete the fields in the add data import script pop up (see script examples below) > click ok

...

Standard script usage:

DeleteEmptyLines

...

Filter by label (Content by label)
showLabelsfalse
maxCheckboxfalse
showSpacefalse
reversefalse
cqllabel in ( "bank-reconciliation" , "credit-card-expenses" , "bank-import" , "bank" , "bank-rec" ) and space = currentSpace ( )