1. Home
  2. /
  3. Panel Help
  4. /
  5. Financials
  6. /
  7. Work with imported bank...

Work with imported bank statements, References (FKR41101)

Related topics

On this panel you can view interpreted reference (settlement) data for the selected payment. From here you can drill down further to view the found A/R document to settle.

Options

A/R document 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.

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.

Debtor
Displays the debtor and the internal name from the Business partner file of the A/R payment.
Status
Displays the status code of the imported bank statement.

Valid codes are:

Code Description
20 Reloading completed
30 Transfer completed
Document type
Displays the document type of the A/R payment.
Doc date
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).

Transaction amount
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).

Trans curr
Displays the transaction currency for the transaction amount of the A/R payment.

For ISO 20022, see Transaction amount above. For Netstore/Teller Settlement Report, (Transaction Level/Transaction Settlement Currency).

Settlement
Displays the payment’s settlement option defined for the payment in Work with Cash Management schemes/Bank account details and/or in Work with Cash Management schemes/Bank accounts.

Line
This column displays the reference line number.
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.

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.
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.
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.

Example:

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),
or to 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. DC1 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 (FKR41119)

Related topics

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.