Related topics
- About the Imported bank statement functionality
- Setting up the Imported bank statement functionality
This panel displays the imported A/R payments and related A/R references for the selected imported bank statements, in status 20 (Reloading completed) or 30 (Transfer completed). The A/R payment and related A/R references (settlements) creates a group. Each group starts with the code for YES in the P column and displays the payment and the first related reference (settlement) data. If the payment holds several references (settlements) they are displayed on the subsequent lines and the P column is left blank.
Options
| Payment details | This option is only applicable if the P column is set to YES. 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. |
| A/R document | This option is only applicable if the A/R document to settle exists (the A/R dt and A/R doc no columns). Select this option to access the A/R transactions enquiry where you can view the A/R document to settle on Details level of that enquiry. |
| 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
| Orig ref fr bank sel | Access the Original reference from bank, Selection panel where you can enter selection data to select the Original references (un-edited raw data) from the bank. |
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 IBS Enterprise 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.
- P
- This column denotes if this a payment line. The A/R payment and related A/R references creates a group. Each group starts with the code for YES in this column, and displays the payment and the first related reference data. If the payment holds several references they are displayed on the next lines and this column is left blank.
- Line
- This column displays the line number. Each payment starts with line number 1 and displays the payment and the first reference number to the A/R document to settle. The line number is incremented with 1 until all references are displayed related to the payment. These lines display only the additional reference numbers related to the payment, if it exists.
Example:
This example depicts a payment with 3 reference numbers to the A/R document to settle. Line 1 and 2 found the A/R document to settle but not the third line.P Line Interpreted reference A/R dt A/R doc no Y 1 4408621 FKI 4408621 Y 2 4408622 FKI 4408623 Y 3 4408623
- Interpreted reference number
- This column displays the interpreted reference (settlement) number.
The reference number is interpreted from the “Original reference from bank”, (which is an un-edited (raw data) reference line from the bank), and processed according to the Internal reference rule in Work with Cash Management scheme/Bank account detail/Internal ref rules and might be transferred to Work with open batches.If left blank, the interpreted reference from the “Original reference from bank” is rejected before the search process in A/R according to the set up for the internal reference rule in Work with Cash Management schemes/Bank account details/Internal ref rules. See the Reference handling section in About the Imported bank statement functionality for more information.
For more information, see Original references from bank below.
- A/R dt
- This column displays the document type for the found A/R document to settle in the A/R ledger. The document is found in the A/R with help of the Interpreted reference number and internal reference rules in Work with Cash Management schemes/Bank account details/Internal ref rules.
- A/R doc no
- This column displays the document number for the found A/R document to settle in the A/R ledger. The document is found in the A/R with help of the Interpreted reference number and internal reference rules in Work with Cash Management schemes/Bank account details/Internal ref rules.
- Er
- This column denotes if an error has been found, i.e. the Interpreted reference number is missing in A/R or if found the A/R document is settled or in a period after the period for the A/R payment.
- Tfr
- If this column is set to YES, it denotes that the A/R payment and the Interpreted reference number is/will be transferred to Work with open batches. If this column is set to NO, it denotes that only the A/R payment is/will be transferred to Work with open batches.
If the Error column is set to NO, this column will be set to YES. If the Error column is set to YES, the Transfer ref error field in Work with Cash Management schemes/Bank accounts details/Internal ref rules controls this Y/N code setting. See Reference handling section in About the Imported bank statement functionality for more information.
- T
- This column displays the code for YES if payment text lines exist, and is only displayed for sub-file lines with the P column set to YES.
- Reference amount
- Only shown if this column has been activated through the Edit columns feature. This column displays the amount specified for the referred document to settle.
Reference amount is used as settlement amount in Work with open batches if the reference amount currency = transaction currency for found A/R document to settle.For ISO 20022, refers to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatetmentV02 (Msg ID camt.053.001.02), Transaction Details (Remittance Information/ Referred Document Amount)
or to BankToCustomerDebitCreditNotificationV02( Msg ID camt.054.001.02), Transaction Details (Remittance Information/ Referred Document Amount).For Netstore/Teller Settlement Report, this field is not applicable.
- Ref curr
- Only shown if this column has been activated through the Edit columns feature. This column displays the reference amount currency. For ISO2002, see Reference amount.
- Interpreted as
- Only shown if this column has been activated through the Edit columns feature. This column displays a text string to clarify how the interpreted reference number was used in the search process for the referred A/R document to settle. Example of the text that could be displayed is:
- Bank reference number
Interpreted reference number was used as bank reference number, in the search process, when the referred A/R document to settle was found. - Document number
Interpreted reference number was used as document number, in the search process, when the referred A/R document to settle was found.
- Bank reference number
- No of lines
- Only shown if this column has been activated through the Edit columns feature. If the Original reference from bank consists of several references, it is split to several sub-file lines and this column denotes the number of used lines for the split.
- Settlement
- Only shown if this column has been activated through the Edit columns feature. This column displays the payment’s settlement option, and is only displayed for sub-file lines with the P column set to YES.
- Payment debtor no
- Only shown if this column has been activated through the Edit columns feature. This column displays the debtor of the A/R payment, and is only displayed for sub-file lines with the P column set to YES. 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
- Only shown if this column has been activated through the Edit columns feature. This column displays the internal name from the Business partner file, and is only displayed for sub-file lines with the P column set to YES.
- Payment doc type
- Only shown if this column has been activated through the Edit columns feature. 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, and is only displayed for sub-file lines with the P column set to YES.
- Payment doc date
- Only shown if this column has been activated through the Edit columns feature. This column displays the document date of the A/R payment, and is only displayed for sub-file lines with the P column set to YES.
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).
- Payment trans amount
- Only shown if this column has been activated through the Edit columns feature. This column displays the amount of the A/R payment in transaction currency, and is only displayed for sub-file lines with the P column set to YES.
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).
- Payment curr
- Only shown if this column has been activated through the Edit columns feature. This column displays the transaction currency for the transaction amount of the A/R payment, and is only displayed for sub-file lines with the P column set to YES.
For ISO 20022, see Payment trans amount above. For Netstore/Teller Settlement Report, (Transaction Level/Transaction Settlement Currency).
- 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.
- Original references from bank
- Only shown if this column has been activated through the Edit columns feature. This column displays the original references from bank. If the Original reference from bank consists of several references it is split to several sub-file lines and the No of lines column denotes the number of used lines for the split. If split, the data is displayed on the first line for the split.
Line Interpreted reference number (Interpreted reference in Enterprise from the Original Reference according to the Internal reference rule)
No of lines Original reference from bank (Un-edited (raw data) reference line from the bank)
1 12345678 2 12345678 85994523 2 85994523 For ISO 20022, refer to the standard or local guideline according to the UNIFI ISO 20022 payments message BankToCustomerStatetmentV02 (Msg ID camt.053.001.02),
and the BankToCustomerDebitCreditNotificationV02( Msg ID camt.054.001.02). The references are retrieved from many different places. For more information see Work with Cash Management schemes, Bank account details, Internal ref rules.For Netstore/Teller Settlement Report, (Transaction Level/Transaction Ref Num 1 and Transaction Level/Transaction Ref Num 2).
See Reference handling section in About the Imported bank statement functionality for more information.
- Original references from bank- continues
- Only shown if this column has been activated through the Edit columns feature. The original reference from the bank is split into two columns if the length is greater than the max length for XT/UI fields. This column displays the continued original reference from bank. For more information, see Original reference from bank above.
- Internal ref rule
- Only shown if this column has been activated through the Edit columns feature. This column displays the Internal reference used for the processing of the Original reference from bank. If split, the data is displayed on the first line for the split.
Integrator marks the reference records with a pre-defined internal reference rule. IBS Enterprise processes the reference record according to the set up for the internal reference rule in Work with Cash Management schemes/Bank account details/Internal ref rules.
- Netstore transaction ID
- Only shown if this column has been activated through the Edit columns feature. This column, which is only applicable if the Cash Management scheme type is 2, displays the Netstore transaction ID for the credit card payment from the received bank file.
For Netstore/Teller Settlement Report, (Transaction Level/Transaction Num).
Original reference from bank, selection (FKR42519)
In this window you can make a selection on the Original reference from bank.
- Original reference
- Enter data to make a selection in the Original reference from bank.