Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AP GL difference help
Microsoft Dynamics AX (Archived)

AP GL difference help

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Good evening colleagues,

can you please suggest which way to move in order to investigate further.

We are having difference between AP and GL ledgers of €25.24 in P10 (October). It’s caused by vendor xxxxx, there are no transactions open on this vendor and each of this vendor’s transactions looks booked correctly, however, AP ledger still showing balance of 25.24.

It seems that the problem is very recent so it restricts the range of action: difference must have been caused in P10 (October) postings as there was no AP GL difference in P9 (September).

I think it's hard to reproduce because I do not have a standard environment, I only have a copy of the production env. every x weeks.

6433.image003.jpg

2018_2D00_11_2D00_05_5F00_19_2D00_55_2D00_47.jpg

2018_2D00_11_2D00_05_5F00_19_2D00_56_2D00_28.jpg


many thanks,

best regards

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AP GL difference help

    Hello FG,

    Many thanks for that screenprint.

    If you click on the 'transaction origin' button can you see that the ledger and the accounts payable modules are used?

    In case both modules (AP and GL) are visible in the transaction origin form the difference cannot be caused by this voucher and you should follow Andre's advice to check LCS for a hotfix or ask a developer digging deeper into this issue from a database perspective.

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: AP GL difference help

    Hi FG,

    The column you highlighted is column that has an offset. Debit is presented left and Credit right. If you enlarge the column, you will see that behavior better. Did you already check LCS issue search?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP GL difference help

    8562.print.jpg

    8562.print.jpg

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP GL difference help

    Hi Ludwig,

    here the print screen - shouldn't be the amount -25.24 instead 25.24?

    The Vendor amount should be 0 but the system shows 25.24

    3884.print.jpg

    Thanks,

    Regards

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AP GL difference help

    Hi FG,

    The voucher starts seems to be related to a general ledger voucher. Can you open this voucher and check the transaction origin to see the different sy ledgers affected.

    Best regards

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP GL difference help

    Hi Ludwig,

    I have answered in the post below.

    Thanks,

    Regards

    FG

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP GL difference help

    Hi Magic,

    thanks for the heads up.

    after digging in the vouchers, he issue is in GEN003614 (P9) but I still don’t see the reason for having wrong balance on this vendor, all transactions showing correct GL postings...

    culprit.jpg

    Thanks

    FG

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,877 on at
    RE: AP GL difference help

    If you know the period and the vendor then the Vendor Balances list report as suggested is a good place to start to see what ahs happened in the period for that vendor.

    If running other reports then you might find it useful to read my previous post https://community.dynamics.com/ax/f/33/t/238269

    Link the vendor transactions in the VendTrans and the GeneralJournalAccountEntry, by the  createdTransactionId to also verify that for the  transactions related to a particular vendor, that the postings all went to that correct main account.

    To link the vendor transactions in the VendTrans with those in the GeneralJournalAccountEntry, use createdTransactionId to isolate transactions related to a particular vendor, then you can see whether all the postings went to that particular main account.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP GL difference help

    Hi Ludwig,

    not yet - we are digging in the matter.

    Thanks

    Regards

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AP GL difference help

    Hello FG,

    Have you been able to overcome or dig down deeper into the issue?

    Best regards,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans