CRM › Utility Cashiering & Payments
Lockbox & Bank Files
A lockbox or bank file of payments: each line posted once by its reference, duplicates and bad lines named.
Where to find it
- Module: CRM
- Group: Utilities
- Section: Utility Cashiering & Payments
- Screen: Lockbox & Bank Files
Address in the console: /crm/util-payment-imports
Read-only list · 9 columns · 1 action
This list is read-only: its records are written by the work that produces them. A correction, where one is possible at all, is made where the record was created.
What the list shows
These are the columns of the list, in the order they are drawn. Any of them can be sorted on, filtered on, hidden, or exported.
| Column | Kind | Field name |
|---|---|---|
| File | Code | import_no |
| Name | Text | file_name |
| From | Status | channel |
| Loaded | Date and time | created_at |
| Lines | Number | rows_total |
| Posted | Number | rows_posted |
| Already posted | Number | rows_duplicate |
| Rejected | Number | rows_rejected |
| Amount | Amount | amount_posted |
What you can do here
Load a payment file primary
Asks for: File name From CSV (account_no, amount, reference)*
* required
The rules that apply here
Everything on this screen obeys the platform rules rather than rules of its own. The ones worth knowing before you use it:
- Narrowing a list — search, conditions, sort, totals, export and saved views.
- What may be changed — the five grounds a record may not be edited on.
- Companies and business units — what the switcher above this list is doing to it.