web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Detailed specification...
Microsoft Dynamics AX (Archived)

Detailed specification payment Journal

(0) ShareShare
ReportReport
Posted on by Oleg van den Boogaard 556

Hello,

When I create a payment journal for a customers and in 1 row are multiple invoices selected. In which table can I find the specification of the journal.

As for the why:
I want that extract all that are selected in a specific journal, where the method of payment is for example OLA. Maybe a SQL code would help like Select * From "table x" where payment method equals OLA (or something like that)

I'm facing a error when post and transfer a Payment journal. There is most likely a validation on payment method, but it doesn't post the correct lines and transfer the wrong lines to a new journal.

Any help would be more then welcome. Thanx in advance.

Kind Regards,

Oleg

*This post is locked for comments

I have the same question (0)
  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,677 Super User 2026 Season 1 on at

    while you mark transactions to do payment, irrespective whether you mark a single invoice or multiple, the data is kept temporarily in table named as SpecTrans

    once you post payment it goes away , the data from SpecTrans table to customer transactions table. customer transactions table involve, CustTrans, CustTransOpen and CustSettlement

    I think you may focus to actual error and try to fix it. sharing error message and details can be helpful for others.

  • Oleg van den Boogaard Profile Picture
    Oleg van den Boogaard 556 on at

    Hello Sohaib,

    I Understand the relating between the several table and the SpecTrans is not new for me.

    But is there  a way to link those data together? I know where the error is coming from, it is a user who is not using AX correctly.

    How does it come that Post and Transfer doesn't work, that answer is not yet answered.

    Thanks in advance.

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,677 Super User 2026 Season 1 on at

    it is just because I cannot see enough details about your question.

    the kind of magic to see into your system, without having its access, cannot happen :)

    you need to explain 'link together', also your need to provide any other details that should be sufficient enough to know reason of issue. my previous answer was based on what you gave as input.

  • Oleg van den Boogaard Profile Picture
    Oleg van den Boogaard 556 on at

    Hello Sohaib,

    My mistake that I did not inform you completely. When I am post en transfer a payment journal (Direct debit) I sometimes get an error that the payment method of a selected invoice is not INC (stands for direct Debit).

    A user changed the method of payment of the invoice to OV (manual payment).

    When i'm trying to post the journal it gives me an error.

    Knowing that I get this error I would like to find a quick way to find out which line is creating this error. Know I have to use like 5 vlookup en 3 export of different table.

    If not possible let me know.

    Thanx in advance.

    Groeten,

    Oleg

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,677 Super User 2026 Season 1 on at

    alright, so lets state your question.

    are you looking to know from where error message comes? i.e. line of code?

  • Oleg van den Boogaard Profile Picture
    Oleg van den Boogaard 556 on at

    yes

  • Verified answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 49,677 Super User 2026 Season 1 on at

    Great.

    I suppose error message is not giving you option to edit message and go into source directly. The easiest way to debug this is to turn off CIL for a moment and then putting breakpoint in info class add method. As soon as breakpoint hits, note down stack trace and disable debugging

  • Oleg van den Boogaard Profile Picture
    Oleg van den Boogaard 556 on at

    Hello Sohaib,

    Thanx for your feedback. This will do, unfortunately this is not a realistic option for as I'm posting a journal of probably 4000+ lines.

    Is there another option?

    Kind regards,

    Oleg

  • Verified answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 49,677 Super User 2026 Season 1 on at

    I don't see any quick option, other than following

    1) duplicate production on Test server

    2) create a journal with 1 line ( you can use same information from a line which is producing error i.e. same invoice number)

    3) debug it now with smaller set of data.

  • Verified answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 49,677 Super User 2026 Season 1 on at

    another option is to search label text of error message and then searching that label in AX

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans