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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to find Invoice th...
Microsoft Dynamics AX (Archived)

How to find Invoice that are related to a Journal Voucher?

(0) ShareShare
ReportReport
Posted on by chicagoax 50

Once I am on Account Payable -> Payment Journal -> Journal Voucher, I can see the invoice that's associated to that line item under Inquiries -> View marked transaction or Functions-> Settlement. Is there a way for me trace the invoice from the ledgerJournalTrans table, which is backing of Journal Voucher. The Invoice field and VendTransId on LedgerJournalTrans are blank and 0 respectively, so hard for me to link the two fields. Any help is appreciated. Thanks!

*This post is locked for comments

I have the same question (0)
  • chicagoax Profile Picture
    chicagoax 50 on at
    RE: How to find Invoice that are related to a Journal Voucher?

    Ok that would be helpful. I'll play around to see if I can figure this out in the meantime. Thanks again for the help!

  • Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,616 Super User 2025 Season 2 on at
    RE: How to find Invoice that are related to a Journal Voucher?

    Hi Chicagoax,

    Regarding your question , as you have mentioned, you can check if a vendor transaction is tagged against a journal voucher by clicking Inquiries -> View marked transaction. On the Vendor transaction point of view, you can find journal voucher on vendor transaction and click on History to find the voucher (invoice) that is settled against it and vice versa.

    On LedgerJournalTrans table, 'Invoice' field heritages from the Journal voucher (e.g. "Invoice field" which exists on Invoice journal or General Journal).  VendTransId field heritages from vendor transaction's Sequence number.

    P.S. "VendTrasId" on LedgerJournalTrans table = "RecId" on VendTrans table

    I wish it helps,

    Regards,

    Alireza

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,888 on at
    RE: How to find Invoice that are related to a Journal Voucher?

    Take look at this previous community post for related advice

    community.dynamics.com/.../211107

  • Suggested answer
    Hossein.K Profile Picture
    Hossein.K 6,648 on at
    RE: How to find Invoice that are related to a Journal Voucher?

    hi,

    There are two class for inserting vouchers in GeneralJournalAccountEntry and GeneralJournalEntry:

    ...Classes\LedgerVoucherTransObject\initFromLedgerPostingTransaction

    ...Classes\SubLedgerJournalTransferCommand\insertGeneralJournalAccountEntryRelated

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans