Related topics
- About the Imported bank statement functionality
- Setting up the Imported bank statement functionality
On this level you set up/maintain the applicable bank account header data for the selected Cash Management scheme to be used in the Work with imported bank statements routine, and subsequently in the Work with open batches routine.
Options
Delete | Select this option to delete selected records in this table and in all sub-tables. |
Bank account details | Select this option to access the Work the Cash Management schemes, Bank account details panel where you define bank account detail data for the selected Cash Management scheme. |
Selection fields
- Scheme ID
- Displays the selected scheme ID and description for the bank account.
- Bank account number
- This column displays the bank account number.
- Bank account description
- This column displays the bank account description.
- Active
- This column denotes if the scheme is active.
- Bank statement ID
- This column displays the Bank statement identification from the latest imported bank statement that has been transferred from Work with imported bank statements to Work with open batches.
- Electronic seq no
- This column displays the electronic sequence number from the latest imported bank statement that has been transferred from Work with imported bank statements to Work with open batches.
- Check electronic seq
- This column denotes if the electronic sequence should be checked. If set to yes, the imported bank statement will be approved if it is in sequential order.
Work with Cash Management schemes, Bank accounts (FSR71204)
On this panel you enter new or maintain bank account header parameters for a Cash Management scheme.
Function keys
Change bank statement data | Access the Change bank statement data window where you must change the applicable data in the event that you would like to re-import the bank statement, or you have imported a bank statement in the wrong electronic sequence order. This requires that you have System administration authority. |
- Scheme ID
- Displays the selected scheme ID and description for the bank account.
- Bank account number
- Enter the bank account number from Work with banks.
- Bank account no desc
- Displays the bank account number description from Work with banks.
- Active
- Set this flag to YES to activate the bank account. This flag impacts the subsequent processing of approved imported bank statements.
Bank statement data
- Message ID
- Displays the ISO message identification. This field is updated each time an imported bank statement has been transferred to Work with open batches.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Group header or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Group header.
For the Netstore/Teller Settlement Report, the file name is displayed.
- Creation date/time
- Displays the creation date and time from the latest imported bank statement that has been transferred from Work with imported bank statements to Work with open batches.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Group header or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Group header.
For the Netstore/Teller Settlement Report, the date from the file name and time when the XML was imported to DC1 is displayed.
- Bank statement ID
- Displays the Bank statement identification from the latest imported bank statement that has been transferred from Work with imported bank statements to Work with open batches.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Statement (Identification) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Notification (Identification).
- Electronic seq no
- Displays the electronic sequence number from the latest imported bank statement that has been transferred from Work with imported bank statements to Work with open batches.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Statement or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Notification.
For Netstore/Teller Settlement Report, the Payments info/Settlement number is displayed.
- Check electronic seq
- Indicate if the electronic sequence should be checked. If this flag is set to YES, the system will only allow the transfer of the imported bank statement from Work with imported bank statements to Work with open batches if the latest received bank statement’s electronic sequence number is greater than the previous number (i.e. it will be approved for transfer if it is in sequential order).
If this flag is set to NO, the system will allow the transfer from Work with imported bank statements to Work with open batches without controlling the latest received Bank statement’s electronic sequence number.
- Save number of days
- Enter the number of days that the imported bank statement should be saved from the XML’s creation date after the transfer to Work with open batches.
Click Next to access an additional panel where you can enter more bank account header information for the scheme.
Work with Cash Management schemes, Bank accounts, Copy (FSR71205)
- Scheme ID
- Displays the selected scheme ID and description for the bank account.
- Bank account number
- Displays the bank account number(s) you selected to copy.
- New bank account number
- Enter the new bank account number that you are creating from Work with banks.
Work with Cash Management schemes, Bank accounts, Deletion (FSR71208)
Work with Cash Management schemes, Bank accounts (FSR71211)
On this panel you enter voucher type, document type and open batch details information for the current scheme and bank account.
- Scheme ID
- Displays the selected scheme ID and description for the bank account.
- System identity
- Displays the user’s language code for System identity A/R.
- Voucher type
- Enter a voucher type from Work with voucher types for this type of payment. The voucher type must be defined to be used for the routines ARP and ARS. This voucher type can be overridden on Work with Cash Management schemes, Bank account details level.
- Document type
- Enter an A/R payment document type from Work with documents for this type of payment. This document type can be overridden on Work with Cash Management schemes, Bank account details level.
Open batch details
- Origin code
- Enter an origin code to be used when importing transactions to Work with open batches. This origin code must be defined for the Batch import option code you select (below) in Work with batch import options.
- Batch import option
- Enter a batch import option from Work with batch import options to be used when importing transactions to Work with open batches. The selected origin code (above) must be defined for this Batch import option.
- Settlement option
- Enter a settlement option from Work with settlement options to be used when importing transactions to Work with open batches. The settlement option controls the settlement rules between the payment and the found invoice(s)/credit note(s). For more information see Work with settlement options. This settlement option can be overridden on Work with Cash Management schemes, Bank account details level.
- Settlement option 2
- This field is defaulted with *NOREF. This field must be left as *NOREF or blank. The settlement option 2 is used when importing transactions to Work with open batches, and controls the settlement rules for on account payments. For more information see Work with settlement options. This settlement option 2 can be overridden on Work with Cash Management schemes, Bank account details level.
- Automatic transfer
- Set this flag to YES if you want Integrator to import the bank statement to Work with imported bank statements, which in turn, automatically transfers it further to Work with open batches if no error is found. Otherwise it ends in Work with imported bank statements and you need to manually transfer them further to Work with open batches. Set this flag to NO if you do not want Integrator to automatically transfer the bank statement to Work with open batches after it imports the bank statement to Work with imported bank statements. You want to manually transfer to Work with open batches instead.
Change bank statement data (FSR71219)
On this panel you must change the applicable data in the event that you would like to re-import the bank statement, or you have imported a bank statement in the wrong electronic sequence order. This requires that you have system administration authority. Nothing is changed in Work with imported bank statements or in Work with open batches. Click OK to confirm the update.
- Message ID
- Enter the ISO message identification. For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Group header or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Group header.
For the Netstore/Teller Settlement Report, enter the file name.
- Creation date/time
- Enter the creation date and time for the imported bank statement that has been transferred from Work with imported bank statements to Work with open batches.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Group header or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Group header.
For the Netstore/Teller Settlement Report, enter the date from the file name and time when the XML was imported to DC1.
- Bank statement ID
- Enter the Bank statement identification for the imported bank statement that has been transferred from Work with imported bank statements to Work with open batches.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Statement (Identification) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Statement (Identification).
- Electronic seq no
- Enter the electronic sequence number for the imported bank statement that has been transferred from Work with imported bank statements to Work with open batches.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Statement (Identification) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Statement (Identification).
For Netstore/Teller Settlement Report, enter the Payments info/Settlement number.