Related topics
- About the Imported bank statement functionality
- Setting up the Imported bank statement functionality
The program holds bank transaction codes (for example domestic payment and foreign payment) for the selected Cash Management scheme/bank account number to be used in Work with imported bank statements. Here you set up the applicable data on bank transaction level. Some of the data overrides data entered on Cash Management scheme/bank account number level.
Options
Internal text rules | This option is only applicable for System identity A/R. Select this option to access the Internal text rules panel to define applicable internal text rules for the selected Cash Management scheme/bank account number/bank transaction code. |
Internal reference rules | This option is only applicable for System identity A/R. Select this option to access the Internal reference rules panel to define applicable internal reference rules for the selected Cash Management scheme/bank account number/bank transaction code. |
Selection fields
- Scheme ID
- Displays the selected scheme ID and description for the bank account.
- Bank account number
- Displays the bank account number.
- Bank account description
- Displays the bank account description.
- Domain
- This column displays the bank transaction domain code.
- Family
- This column displays the bank transaction family code.
- Sub fam
- This column displays the bank transaction sub family code.
- Description
- This column displays the description for the bank transaction code.
- Active
- This column denotes if the bank transaction code is active.
- Syst
- This column displays the system identity, i.e. G/L, A/R or A/P.
- Domain description
- This column displays the bank transaction domain code description from Work with ISO 20022 external code lists.
- Family description
- This column displays the bank transaction family code description from Work with ISO 20022 external code lists.
- Sub family description
- This column displays the bank transaction sub family code description from Work with ISO 20022 external code lists.
Work with Cash Management schemes, Bank account details (FSR71304)
On this panel you enter new or maintain bank account detail parameters for a Cash Management scheme.
- Scheme ID
- Displays the selected Cash Management scheme ID and description.
- Bank account number
- Displays the bank account number.
- Bank account no desc
- Displays the bank account description.
Bank transaction cd
- Domain
- The Bank transaction code (Domain/Family/Sub family) identifies the transaction entry. In Add mode this field is defaulted with PMNT. Enter the bank transaction Domain code, which specifies the business area, from Work with ISO external lists/codes for the *BKTXDOMN element.
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), Statement (Entry/BankTransactionCode) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Notification (Entry/BankTransactionCode).
For Netstore/Teller Settlement report, defaulted to PMNT.
- Family
- The Bank transaction code (Domain/Family/Sub family) identifies the transaction entry. In Add mode this field is defaulted with RCDT. Enter the bank transaction Family code, which specifies the family within a domain, from Work with ISO external lists/codes for the *BKTXFMLY element.
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), Statement (BankTransactionCode) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Notification (BankTransactionCode).
For Netstore/Teller Settlement report, defaulted to CCRD.
- Sub family
- The Bank transaction code (Domain/Family/Sub family) identifies the transaction entry. In Add mode this field is defaulted with *ALL. Enter the bank transaction Sub family code, which specifies the sub-product family within a specific family, from Work with ISO external lists/codes for the *BKTXSUBFM element. Instead of defining all Sub-families, you can enter *ALL. For missing bank transaction codes, the system will re-read the table with Sub family *ALL.
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), Statement (BankTransactionCode) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Notification (BankTransactionCode).
For Netstore/Teller Settlement report, defaulted to *ALL.
- Description
- Enter a description for the Bank transaction.
- Active
- Set this flag to YES to activate the bank transaction code. Set it to NO to inactivate it. This flag impacts the subsequent processing of approved imported transactions within the bank statement.
Approved transaction:
The imported bank statement is approved, and the A/R payment is defaulted with an active bank transaction code (Domain/Family/Sub family) in this file. These transactions will be further processed.
For missing bank transactions codes the system re-reads the table with Sub family *ALL.Approved A/R Payments with no error, and with the Automatic Transfer flag set to YES on Bank account header level, will be automatically transferred to Work with open batches. Otherwise the payment will end in the Work with imported bank statements routine and you will need to manually transfer them further. For transactions that are transferred to Work with open batches, the Stop after loading parameter controls the further processing to the A/R ledger.
Rejected transaction:
The imported bank statement is rejected or the imported bank statement is approved, but the A/R payment is defaulted with a missing/inactive bank transaction code (Domain/Family/Sub family) in this file. These transactions will end in Work with imported bank statements.
- System identity
- This field is defaulted with 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. If this field is left blank, the voucher type defined on Work with Cash Management schemes/Bank accounts level is used.
- Document type
- Enter an A/R payment document type from Work with documents for this type of payment. If this field is left blank, the document type defined on Work with Cash Management schemes/Bank accounts level is used.
Click Next to access an additional panel where you can enter more bank account detail parameters for the Cash Management scheme.
Work with Cash Management schemes, Bank accounts, Copy (FSR71305)
- Scheme ID
- Displays the scheme ID for the bank account detail(s) you selected to copy.
- Bank account number
- Displays the bank account number for the bank account detail(s) you selected to copy.
- Bank account no desc
- Displays the bank account number description for the bank account detail(s) you selected to copy.
- Domain
- Displays the domain for the bank account detail(s) you selected to copy.
- Family
- Displays the family for the bank account detail(s) you selected to copy.
- Sub fam
- Displays the sub family for the bank account detail(s) you selected to copy.
- New sub fam
- The Bank transaction code (Domain/Family/Sub family) identifies the transaction entry. Enter the new bank transaction Sub family code that you are creating, which specifies the sub-product family within a specific family, from Work with ISO external lists/codes for the *BKTXSUBFM element. Instead of defining all Sub-families, you can enter *ALL. For missing bank transaction codes, the system will re-read the table with Sub family *ALL.
Work with Cash Management schemes, Bank account details, Deletion (FSR71308)
Work with Cash Management schemes, Bank account details (FSR71311)
On this panel you enter A/R payment proposal, Debtor retrieval and Open batch details information for the current scheme, bank account, and bank transaction code.
- Scheme ID
- Displays the selected Cash Management scheme ID and description.
- Bank account number
- Displays the bank account number.
- Bank account no desc
- Displays the description of the bank account number.
- A/R payment proposal
- If the transferred A/R payments to Work with open batches exist in Work with A/R payment proposals they will end in error in Work with open batches. Set this flag to YES if the system should automatically delete the payment in Work with A/R payment proposals if it exists. Set this flag to NO if you do not want the system to automatically delete the payment in the Work with A/R payment proposal, if it exists.
- Debtor retrieval cd
- The code controls how to retrieve the debtor for the confirmed A/R payment. Valid codes are 1 and 2.
Debtor retrieval code 1:
- Retrieve debtor from the received bank file.
- If debtor is missing above, retrieve the debtor according to the Internal reference rules set up as follows:
- a) From the first found A/R document applicable to settle.
- b) If the A/R document to settle is missing and if the Extended ref search field has been set to 1 in Work with Cash Management schemes/Bank account details/Internal reference rules, retrieve from Work with business partners.
- If debtor is still missing, retrieve from Work with Direct Debit mandates, if a Mandate ID has been imported and the SEPADD function is activated in the Function control file.
- If debtor is still missing, retrieve from Work with Business partner banks if the debtor’s bank account number has been imported from the bank file.
Debtor retrieval code 2:
- Retrieve debtor from the received bank file.
- If debtor is missing above, retrieve from Work with Direct Debit mandates, if a Mandate ID has been imported and the SEPADD function is activated in the Function control file.
- If debtor is still missing, retrieve from Work with Business partner banks if the debtor’s bank account number has been imported from the bank file.
- If debtor is still missing, retrieve according to the internal reference rules set up as follows:
- From debtor from the first found A/R document to settle.
- If the A/R document to settle is missing and if the Extended ref search field has been set to 1 in Work with Cash Management schemes/Bank account details/Internal reference rules.
- Retrieve from the bank file.
- If debtor is missing above, retrieve from Work with Direct Debit mandates, if a Mandate ID has been imported and the SEPADD function is activated in the Function control file.
- If debtor is still missing, retrieve from Work with Business partner banks if the debtor’s bank account number has been imported.
Open batch details
- 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. If this field is left blank, the settlement option defined on Work with Cash Management schemes/Bank accounts level is used.
- Settlement option 2
- This field must be set to *NOREF or left blank. The settlement option 2 controls the settlement rules for on account payments. For more information see Work with settlement options. If this field is left blank, the settlement option 2 defined on Work with Cash Management schemes/Bank accounts level is used.