Bank Code translations

The Bank Translations provide the main control over how entries are posted from Concur to Sage300. Each payment type in Concur requires an entry in this table, and each entry specifies which modules the expenses are posted.

Example

Company Paid entries can be processed through the Accounts Payable Module, whereas Employee Paid expenses can be processed through the relevant Payroll module.

It is paramount that each is entry is edited, so entries are posted to the correct module, and to the correct bank account where appropriate.”

  1. Double click each lookup to edit:

  1. ID
    • Refers to the payment type.
  2. Description
    • Recognisable description of the setting.
  3. Bank code
    1. The Bank Account code corresponding to Sage.

  1. Process AP
    • True/False
    • Designates whether an expense with this type will be processed through Accounts Payable or General ledger.
  2. Default Expense G/L Code
    • Default G/L Account to post expenses if an expense has not been assigned within Concur.
  3. Process Payroll
    1. True/False
    2. Designates whether an expense with this type will be processed as an expense through the US or Canadian Payroll products. This setting applies only when an employee is owed by the company.

Additional Bank Translations

Additional Bank Translations may be required for additional company card payment types or when Multi-Currency is enabled.

To enter additional Bank Translations:

  1. Return to the Lookup Table Maintenance grid.
  2. Ensure that 'Concur /Sage300 / Bank Translations' is selected from the drop down.
  3. Double click the top row of the grid to create a new record.

  1. Edit the new record accordingly.
  2. Press the green tick to save.