There are ledger journal lines missing that are required to generate payment

(0) Share

Report

Posted on by Johnny

6,414

I'm getting the error "There are ledger journal lines missing that are required to generate payment" when I click generate payment and OK.

I have 1 line in journal.

What can be a reason?

*This post is locked for comments

All responses (12)

Answers (0)

Stefan Wojtas 550 on at

Like (0)

Report

RE: There are ledger journal lines missing that are required to generate payment

Hello,

I get the same error. Query VendPayments searching for the "wrong" OffsetLedgerDimension. AX should search for OffsetLedgerDimension from LedgerJournalTrans but the Dimension in Query is the demension from My BankAccount which I select in Dialog VendSumForPaym. Where can I change this?
Suggested answer

AndrejT 15 on at

Like (0)

Report

RE: There are ledger journal lines missing that are required to generate payment

Hey guys,

For me it was rather silly thing that generated the error. In Accounts receivable > Journals > Payment journal, when you click on desired journal and click Lines button, you can see Method of payment parameter below the grid. In my case methods of payment didn't match, therefore query came back with no lines.

Generally you can set breakpoint in CustVendPaymOut.checkLinesCount() method and explore query to find which criteria is preventing correct journal lines from being picked.

Hope this helps!

Br,

Andrej
Dynamics AX community 85 on at

Like (0)

Report

RE: There are ledger journal lines missing that are required to generate payment

I get the same error. I checked that the query performed by the system is asking for a OffsetLedgerDimension when it should. Could be something of the parametrization?
Community Member Microsoft Employee on at

Like (0)

Report

RE: There are ledger journal lines missing that are required to generate payment

I have the same problem. Can you say to me in what table or in what form you have put this information? Thank you.
Suggested answer

jagnayee 50 on at

Like (0)

Report

RE: There are ledger journal lines missing that are required to generate payment

I overcame this error by entering the offset bank account name in the payment journal line
Community Member Microsoft Employee on at

Like (0)

Report

RE: There are ledger journal lines missing that are required to generate payment

Hi, did any of you receive or find a solution for this error? Up to a month ago I was able to generate SEPA payments (both SCT and SDD) and now I get this same error message. Can you tell me if and how you solved this problem?

thanks!
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: There are ledger journal lines missing that are required to generate payment

Hi Kual,

Please check the following site that contains a link to a list that was developed by the Microsoft DACH support-team and details what hotfixes are required to make SEPA working correctly.

blogs.technet.microsoft.com/.../sepa-hotfixliste-in-allen-ax-versionen

I suppose that it might be a bug that can be fixed by installing the hotfixes mentioned in the list.

Hope this helps,

Ludwig
Kual 10 on at

Like (0)

Report

RE: There are ledger journal lines missing that are required to generate payment

Actually I have used correct SEPADirectDebit schema and related setup for file generation. Still this error is coming
Suggested answer

Brandon Wiese 17,788 on at

Like (0)

Report

RE: There are ledger journal lines missing that are required to generate payment

That error is generated in class AxdExportCustVendPayment method validateRecords(). It's looking for a record with a payment schema name of SEPACreditTransfer or SEPADirectDebit.

Is that helpful?
Minoru Ohya 300 on at

Like (0)

Report

RE: There are ledger journal lines missing that are required to generate payment

Do not have VendTransOpen table remain that only all marked transaction data ? If all marked data, I think that may any error occurs. Can you check SpecTrans table from AOT ? That table keeps marked data.