Skip to main content

Notifications

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) / Find transactions dire...
Microsoft Dynamics AX (Archived)

Find transactions directly posted to Ledger main account configured with Vendor Posting profile

(0) ShareShare
ReportReport
Posted on by MYGz 1,935

Hi,

How can I found out transactions that are directly posted to LedgerMainAccount (for eg. 211001)?

This main account is configured with VendorPosting profiles.

How can I find which transactions are generated on posting Vendor transactions and which ones are directly posted to the LedgerMainAccount?

*This post is locked for comments

  • Katy3992 Profile Picture
    Katy3992 322 on at
    RE: Find transactions directly posted to Ledger main account configured with Vendor Posting profile

    Did you solve the issue now?

  • MYGz Profile Picture
    MYGz 1,935 on at
    RE: Find transactions directly posted to Ledger main account configured with Vendor Posting profile

    Thanks Andre,Ludwig,Katy for the reply.

    @Ludwig Is this correct?

    DirectToAccount.png

    This is working for me.

    @Andre:

    Can you elaborate on "Journal Of Origin"? I don't know about it.

    By "not exists join on the accounting transactions with the vendor transactions"

    (eg. For Vendor) Do you mean:

    LedgerJournalTrans not exists VendTrans where LedgerJournalTrans.VendTransId == VendTrans.RecId


    @Katy,Andre
    I checked the Vendor Reconciliation report with Differences and Include details checked.
    I got the correct result on test environment.

    Thanks.

  • Verified answer
    Katy3992 Profile Picture
    Katy3992 322 on at
    RE: Find transactions directly posted to Ledger main account configured with Vendor Posting profile

    Dear MYGz,

    try to use the Vendor / Ledger Reconciliation report. You can find it in General Ledger -> Reports -> Reconciliation -> Vendor -> Vendor. You can active the checkboxes "include details" and "differences only", it will make it easier for you.

    Another idea where the difference could come from, did you check if there's a prepayment (or any other) posting profile that maybe posts on another G/L account but also on a vendor account?

    Kind regards

    Katy

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Find transactions directly posted to Ledger main account configured with Vendor Posting profile

    Hi,

    Go to GL, open the voucher transactions form, enter the main account (211001) and add a filter for the posting type 'Ledger journal'.

    This should give you the manual transactions posted on that account.

    Best regards,

    Ludwig

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,516 Super User 2025 Season 1 on at
    RE: Find transactions directly posted to Ledger main account configured with Vendor Posting profile

    Hi MYGz,

    You can try to filter/search on the posting type field, journal of origin or number sequence pattern of the accounting transactions. Eventually, you can try to use a not exists join on the accounting transactions with the vendor transactions based on accounting date and voucher.

    There are also some reconciliation reports which might help  you here.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans