Universal
Universal in 365 business Banking: import and apply transactions from the CSV file of a payment service provider or upstream system.
The Universal connection is meant for payment service providers and upstream systems that 365 business Banking does not connect to directly but that supply their transactions as a CSV file. You describe the layout of this file once. After that, Business Central imports every further file as bank transactions into the payment reconciliation journal.
Functions
| Function | Supported |
|---|---|
| Retrieve transactions (from a CSV file that a user selects) | yes |
| Map columns of the file to fields of the bank transaction, calculate values or set fixed ones | yes |
| Combine several rows into one transaction (sum, first or last value, concatenate) | yes |
| Select rows with a filter expression | yes |
| Split one row into several transactions, for example for a fee | yes |
| Automatic retrieval via the job queue | no |
| Send or collect payments | no |
Prerequisites
- A transaction file in CSV format supplied by your payment service provider or upstream system.
- For each transaction, a value or combination of values that identifies it uniquely. Business Central builds the transaction ID from it.
- A sample file to check the setup before the first import.
Set up
You set up Universal with the Connect Bank Account wizard: you choose the bank account and describe your CSV transaction file, including format, numbers, dates and column mappings. Step by step and every field: Set up Universal.
Retrieve transactions
You import the transaction file with Retrieve Bank Transactions. In doing so, you select the file: Retrieve Universal transactions.