Dynamics Community Forum Thread Details

Error on Payment file generation with use of bridging account

What is the customer trying to do (business process)

A SEPA CT file should be generated – also when using a bridging account and use in the dialog for generating the payment a different bank account, as it has been defaulted in Methods of payment.

What is the business impact to the customer?
- How does the problem impact their business?

User cannot create payments, as error message "no records were found to generate a payment file" occurs

- How frequently does this issue occur (times daily/times weekly/times monthly)? daily
  Is there a workaround? Setup method of payment for each bank account separately – other manual work

Is the customer applying the workaround? No – too time consuming

- How many users are affected by this issue? All AP Clerks

Steps to reproduce

Update GER to the most actual version for ISO20022 Credit transfer (DE)
Go to AP/Methods of payments, create a new method of payment and enter

Name = SEPA CT
Period = total
Description = SEPA Credit Transfer DE
Payment type = Electronic Payment
Account type = Bank
Payment account = DEMF OPEr
Bridging posting = yes
Bridging account = 110180
Bank transaction type = 12
File Formats:
Generic Electronic Export Format = Yes
Export format configuration = ISO20022 Credit transfer (DE)
Payment attributes
Payment account = checked
Third party bank = checked

3. Create a new company bank account, go to Cash and bank management/Bank account, create a new one and enter:

Bank account = DE Bank
Routing number = 1458
Bank account number = 987654
Main account = 110110
Name = DE Bank 2
Bank groups = BankEUR
Currency = EUR
Additional Information:
Swift code = SSKMDEMMXXX
IBAN = DE12500105170648489890
Address, country/region = DEU

4. Setup a vendor with correct details, go to AP/Vendors, select DE-001 click edit and enter

Payment tab:
Terms of payment = Net10
Method of payment = SEPA CT
Go to Bank account and edit the existing one
Swift code = COBADEFFXXX
IBAN = DE36200400000628808808
Address Country/Region = DEU

Go back to vendor details and select the bank account to field bank account

5. Create a vendor invoice, go to AP/Journals/Invoice journal, create a new one, go to lines and enter

Date = 12/10/2017
Account = DE-001
Invoice date = 12/1/2017
Invoice = 456
Credit = 555,00
Offset account type = Ledger
Offset account = 600120

Post the invoice

6. Go to AP/Payments/Payment journal, create a new journal, go to lines and enter

Date = 12/14/2017
Account = DE-001
Go to settle transactions and select the invoice created in step 5:

Close the settlement form, back to lines:

7. Generate the payment, enter

Method of payment= SEPA CT
File name = BridgingAccountTest1
Bank Account = DEMF OPER – this is the bank account, which is defaulted in Method of Payment

Click OK
Processing date = 12/14/2017
Number of Invoices = 1

Click OK
File is created:

8. Go back to the payment journal lines and set the payment status to “none”

Click again on Generate payments and change content to
File name = BridgingAccountTest2
Bank account = DE Bank – this is a different bank, which is not defaulted in the method of payment

Click ok

Processing date = 12/14/2017
Number of invoices = 1

Click OK

Actual Result

Error message “No records were found to generate a payment file”

Expected result

Payment file should be generated, as it worked in AX 2012:

Does anyone have an idea how to do that in Dyn365FO?

Hi Alfonso,

I do not understand why you do step 8 because the payment file was already created in step 7.

Why do you reset the payment status and try to generate the payment file again but this time from a different bank account?

Irrespective of that please check the following:

1. That the other bank account 'DE Bank' is correctly setup with IBAN + SWIFT

2. That the other bank account 'DE Bank' is linked to a separate method of payment that is selected in the journal.

3. That the other bank account 'DE Bank' and the other payment method is selected in the generate payments form that opens after you hit the generate payments button

4. Also check the following form: => payment proposal button => edit invoices for selected payments and see what accounts and method of payment is selected there.

Best regards,

Ludwig

Quick Links