This is a generic program to enter banking details for all creditors and debtors who use the payment and collections processing in IP1 system. The information captured for the bank details are user configurable and can be set-up in control files ********/PMBNKV1, 2, and 3.
Enter Bank details for a Customer
- In the menu, expand Base Modules > Distribution > Masterfiles> Database Management> Database Management > Customer Masterfiles menu and then double-click CM Customer Masterfile Maintenance. DSM005 Customer Masterfile Maintenance panel appears.
- Enter an existing customer number whose bank account detail you wish to update.
- Click function Bank dtl to access XAO660.
- Select the relevant bank code for auto collection. The bank codes are defined by function in control file ********/PM-BNKV1.
XAO660 Bank Details panel is displayed. The input fields displayed are dependent on entered bank code and is specified in control file ********/PM-BNKV3. For Bank code =ID IBAN (DD), the following input fields will display.
| Field | Description |
| Bank number | Unique Bank number. |
| Mandate ref | An agreement reference between the bank and the client. It is a unique free form text, either randomly generated based on specific logic or manually entered. |
| Mandate date | Date when the mandate was signed by the parties concerned. |
| Bank BIC | Business Identifier Code; unique identification code for each bank and branch. |
| IBAN | International Bank Account Number: ISO 13616 international standard for numbering bank accounts across national borders in Europe to facilitate the communications and processing of cross-border transactions. This is the bank account number standard used in SEPA. The structure of the IBAN is made up of 2 letter ISO 3166 country code, 2 check digits, and up to 30 alphanumeric characters in BBAN format made up of bank-branch code, and the account number. |
| Mandate seq | The mandate sequence determines if it is a one-off collection, recurring or it has been closed. The mandate sequence is updated by the function keys only. |
| Last mand ref |
Reference for the last mandate. |
| Last collectn | Date of the last collection. |
| Last bank BIC | If the BIC has been changed since the last collection, then this would the BIC for the previous collection. |
| Last IBAN | The IBAN that was used in the last collection for this customer. |
| Function | Description |
| Once | If it’s a one off collection as opposed to recurring, then click this function to register is as a one off collection. The mandate sequence will be updated to one off. After the collection has been received the mandate sequence would be updated to Closed. |
| First | If it’s a recurring collection then use this function to initialise it as the first collection. |
| Delete | On deletion the mandate sequence will be updated to Closed and no more auto collections would be allowed. |
| Final | Use this function to register the final collection for the recurring collection sequence. After the collection has been received the mandate sequence would be updated to Closed. |
Note: Authorised users as per ********/PM-BNKV5 can change bank details. Bank details can be masked and protected based on control file settings in ********/PM-BNKV3.
- Enter the required data and click the relevant function to confirm.
