Related topics
- About the Imported bank statement functionality
- Setting up the Imported bank statement functionality
This panel displays all imported bank statements in status 20 (Reloading completed) or 30 (Transfer completed) at transaction level. From here you can drill down to view the payment details, the imported bank statement transactions, the reference (settlement) data, the text data and the imported bank statement details.
Options
| Payment details | Select this option to access the Work with imported bank statements, Payment details panel where you can view the payment details for the selected payment. |
| Imported bank stmt trans | The At column denotes if the transaction for the imported bank statement has been approved. If that column is set to YES, select this option to access the Work with imported bank statements, A/R payments panel to view all approved transactions in the same imported bank statement as the selected transaction. If that column is set to NO, select this option to access the Work with imported bank statements, Rejected transactions panel to view all rejected transactions in the same imported bank statement as the selection transaction. |
| References | This option is only applicable if the Ref column is set to YES. Select this option to access the Work with imported bank statements, References panel where you can view interpreted reference (settlement) data for the selected payment. From there you can drill down further to view the found A/R document to settle. |
| Text | This option is only applicable if the T column is set to YES. Select this option to access the Work with imported bank statements, Text panel where you can view interpreted text data for the selected payment. |
| Imported bank stmt details | Select this option to access the Work with imported bank statements, Imported bank statement details panel to view the imported bank statement details for the selected payment. |
Function keys
Selection fields
- Debtor no
- This column displays the debtor from the Business partner file of the A/R payment.
- Internal name
- This column displays the internal name from the Business partner file of the debtor.
- Dt
- This column displays the document type of the A/R payment.
- Doc date
- This column displays the document date of the A/R payment.
For ISO 20022, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Entry (Value Date) or to BankToCustomerDebitCreditNotificationV02( Msg ID camt.054.001.02), Entry (Value Date).
For Netstore/Teller Settlement Report, (Payments Info/Actual Settlement Date).
- Amount
- This column displays the amount of the A/R payment in transaction currency.
For ISO 20022, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Transaction Details (Amount Details/Transaction Amount) or to BankToCustomerDebitCreditNotificationV02( Msg ID camt.054.001.02), Transaction Details (Amount Details/Transaction Amount).
For Netstore/Teller Settlement Report, (Transaction Level/Transaction Settlement Amount).
- Curr
- This column displays the transaction currency for the A/R payment.
For ISO 20022, see Transaction amount above. For Netstore/Teller Settlement Report, (Transaction Level/Transaction Settlement Currency).
- Ref
- This column denotes if payment references (settlements) exist.
- T
- This column denotes if payment text lines exist.
- At
- This column denotes if the transaction has been approved.
- Domain
- Only shown if this column has been activated through the Edit columns feature. This column displays the A/R payment’s bank transaction code for Domain.
For field ISO 20022 details, refer to the standard or local guideline according to the UNIFI Payments message BankToCustomerStatetmentV02 (Msg ID camt.053.001.02), Entry (Bank Transaction Code) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Entry (Bank Transaction Code).
For Netstore/Teller Settlement report, default value.
- Family
- Only shown if this column has been activated through the Edit columns feature. This column displays the A/R payment’s bank transaction code for Family.
For field ISO 20022 details, refer to the standard or local guideline according to the UNIFI Payments message BankToCustomerStatetmentV02 (Msg ID camt.053.001.02), Entry (Bank Transaction Code) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Entry (Bank Transaction Code).
For Netstore/Teller Settlement report, default value.
- Sub family
- Only shown if this column has been activated through the Edit columns feature. This column displays the A/R payment’s bank transaction code for Sub family.
For field ISO 20022 details, refer to the standard or local guideline according to the UNIFI Payments message BankToCustomerStatetmentV02 (Msg ID camt.053.001.02), Entry (Bank Transaction Code) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Entry (Bank Transaction Code).
For Netstore/Teller Settlement report, default value.
- Domain description
- Only shown if this column has been activated through the Edit columns feature. This column displays the bank transaction domain code description from Work with ISO 20022 external code lists.
- Family description
- Only shown if this column has been activated through the Edit columns feature. This column displays the bank transaction family code description from Work with ISO 20022 external code lists.
- Sub family description
- Only shown if this column has been activated through the Edit columns feature. This column displays the bank transaction sub family code description from Work with ISO 20022 external code lists.
- Syst
- Only shown if this column has been activated through the Edit columns feature. This column displays the user’s language code for System identities A/R, A/P or G/L. A question mark (?) character denotes undefined transactions (bank transaction code is missing in Work with Cash Management schemes/Bank accounts details).
- BP bank account number
- Only shown if this column has been activated through the Edit columns feature. This column displays the business partner’s bank account number where the payment was drawn.
For ISO 20022, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Transaction Details (Debtor Account) or to BankToCustomerDebitCreditNotificationV02( Msg ID camt.054.001.02), Transaction Details (Debtor Account).
For Netstore/Teller Settlement Report, this field is not applicable.
- Mandate ID
- Only shown if this column has been activated through the Edit columns feature. This column displays the payment’s Mandate ID when the SEPADD function is activated in the Function control file.
For ISO 20022, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Transaction Details (Mandate Identification) or to BankToCustomerDebitCreditNotificationV02( Msg ID camt.054.001.02), Transaction Details (Mandate Identification).
For Netstore/Teller Settlement Report, this field is not applicable.
- Business partner
- Only shown if this column has been activated through the Edit columns feature. This column displays the payment’s debtor number for the Mandate ID, if it exists. Otherwise for the debtor for the bank account number, if it exists.
- BP internal name
- Only shown if this column has been activated through the Edit columns feature. This column displays the internal name of the business partner.
- Interpreted text line
- Only shown if this column has been activated through the Edit columns feature. This column displays the interpreted text line 1. Use the Text option to view all text lines.
- Imported bank stmt
- Only shown if this column has been activated through the Edit columns feature. This column displays the imported bank statement number.
- Creation date
- Only shown if this column has been activated through the Edit columns feature. This column displays the date that the bank created the file.
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.
- Bank account number
- Only shown if this column has been activated through the Edit columns feature. This column displays the bank account number.
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 (Account) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Notification (Account).
For the Netstore/Teller Settlement Report, the Card Acceptor Details info/Agreement Card Acceptor Num is displayed.
- Electronic seq no
- Only shown if this column has been activated through the Edit columns feature. This column displays the unique electronic sequence number of the bank account statement assigned by the bank.
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.
- Status
- Only shown if this column has been activated through the Edit columns feature. This column displays the status code of the imported bank statement.
Code Description 20 Reloading completed 30 Transfer completed
- Status description
- Only shown if this column has been activated through the Edit columns feature. This column displays the description for the status code.
- Scheme ID
- Only shown if this column has been activated through the Edit columns feature. This column displays the Cash Management scheme ID to which the imported bank statement is connected.
- Transferred by
- Only shown if this column has been activated through the Edit columns feature. This column displays the ID of the user who transferred the imported bank statement number to Work with open batches.
Work with imported bank statements, All bank statements, More selections (FSR43211)
Function keys
| Clear | Clear any selections made on the panel. |
More selections
- Debtor
- Internal name
- Voucher type
- Document type
- Document date
- Accounting period
- Transaction currency
- Transaction amount
- Mandate ID
- This field is only displayed if the SEPADD function is activated in the Function control file. Enter the payment’s Mandate ID.
For ISO 20022, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Transaction Details (Mandate Identification) or to BankToCustomerDebitCreditNotificationV02( Msg ID camt.054.001.02), Transaction Details (Mandate Identification).
For Netstore/Teller Settlement Report, this field is not applicable.
- Bank account number
- Enter the business partner’s bank account number where the payment was drawn.
For ISO 20022, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Transaction Details (Debtor Account) or to BankToCustomerDebitCreditNotificationV02( Msg ID camt.054.001.02), Transaction Details (Debtor Account).
For Netstore/Teller Settlement Report, this field is not applicable.
- Domain
- Enter the transaction’s bank transaction code for Domain.
For field ISO 20022 details, refer to the standard or local guideline according to the UNIFI Payments message BankToCustomerStatetmentV02 (Msg ID camt.053.001.02), Entry (Bank Transaction Code) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Entry (Bank Transaction Code).
For Netstore/Teller Settlement report, default value.
- Family
- Enter the transaction’s bank transaction code for Family.
For field ISO 20022 details, refer to the standard or local guideline according to the UNIFI Payments message BankToCustomerStatetmentV02 (Msg ID camt.053.001.02), Entry (Bank Transaction Code) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Entry (Bank Transaction Code).
For Netstore/Teller Settlement report, default value.
- Sub family
- Enter the transaction’s bank transaction code for Sub family.
For field ISO 20022 details, refer to the standard or local guideline according to the UNIFI Payments message BankToCustomerStatetmentV02 (Msg ID camt.053.001.02), Entry (Bank Transaction Code) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Entry (Bank Transaction Code).
For Netstore/Teller Settlement report, default value.
- System identity
- Enter the user’s language code for System identities (A/R, A/P or G/L), or enter a question mark (?) character to select undefined transactions (bank transaction code is missing in Work with Cash Management schemes/Bank accounts details).
- Approved trans
- This field is defaulted with the code for YES, meaning you want to display all approved transactions on the initial Work with imported bank statements, All bank statements, Transactions panel. Keep this setting or change to NO to display all rejected transactions. Of set it to ‘ ‘ to view a mixture of approved and rejected transactions.
Work with imported bank statements, All bank statements, More selections (FSR43212)
Function keys
| Clear | Clear any selections made on the panel. |
More selections
- Imported bank stmt
- Creation date
- Bank account number
- Electronic seq no
- Scheme ID
- Transferred by
- Status
Sequence
- Debtor number
- Document date
- A/D
- Enter A to sequence the information in ascending order, or D to sequence it in descending order.