Related topics
- About the Imported bank statement functionality
- Setting up the Imported bank statement functionality
This panel displays the imported A/R payments for the selected imported bank statements, in status 20 (Reloading completed) or 30 (Transfer completed). From here you can drill down to view the payment details, references and text for the selected A/R payment.
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. |
| 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. |
Function keys
| A/R references | Access the Work with imported bank statements, A/R references panel where you can view, on the same panel, the A/R payments and related reference (settlement) data for the selected imported bank statement. On the payment line you select to view the payment details, found A/R document to settle, and the text data. On the reference line you select to display found A/R document to settle. |
| Rejected trans | Access the Work with imported bank statements, Rejected transactions panel where you can view the rejected transactions for the selected imported bank statement. From there you can drill down to view the payment details. Only displayed if Rejected transaction exists. |
Selection fields
- Imported bank stmt
- Displays the imported bank statement number and Message Identification. If Message Identification is missing, this field displays the imported bank statement number and description.
Message Identification:
For field details for description, 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.
Description:
For field details for description, 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 Card Acceptor Details info/Acquirer Information.
- Status
- Displays the status code of the imported bank statement.
Code Description 20 Reloading completed 30 Transfer completed
- Creation date/time
- Displays the date and time 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 and time when the XML was imported to DC1 is displayed.
- Electronic seq no
- 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.
- Bank account no/curr
- Displays the bank account number and currency.
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. Currency code is not applicable.
- Debtor no
- This column displays the debtor from the Business partner file of the A/R payment. Debtor is retrieved according to the Debtor retrieval code in Work with Cash Management schemes/Bank accounts details. See the Debtor retrieval for A/R payments section in About the Imported bank statement functionality for more information.
- 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, retrieved from Work with Cash Management schemes/Bank account and/or in Work with Cash Management schemes/Bank account details.
- 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.
- 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.
- 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.
- Interpreted text line 1
- 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.
Work with imported bank statements, A/R payments, More selections (FKR41011)
Function keys
| Clear | Clear any selections made on the panel. |
- Imported bank stmt
- Displays the imported bank statement number and Message Identification. If Message Identification is missing, this field displays the imported bank statement number and description.
Message Identification:
For field details for description, 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.
Description:
For field details for description, 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 Card Acceptor Details info/Acquirer Information.
- Status
- Displays the status code of the imported bank statement.
Code Description 20 Reloading completed 30 Transfer completed
- Bank account no/curr
- Displays the bank account number and currency.
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. Currency code is not applicable.
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 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
- Enter 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
- Enter 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.