Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Customer reconciliation report showing difference for particular legal entity in AX 2012

Posted on by 5,901

hi All,

Customer reconciliation report showing difference for one particular Legal Entity. I noticed one particular voucher is not considering in the report.

Is it data issue or code issue ?

I guess, it might be data issue , If it's code issue then entire report will impact not particular voucher.

please give me more shed on this.

thanks

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Customer reconciliation report showing difference for particular legal entity in AX 2012

    Hi @rp@n,

    Due to vacation, I missed updating this question. Have you found your answer already? If an amount got posted manually, you first have to understand why it happened. Based on the reasons why, there can be several different actions taken. I'm not able to guess the reason here and if there was a manual posting at all.

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: Customer reconciliation report showing difference for particular legal entity in AX 2012

    hi Andrea,

    thanks for your reply.

    Sure, i will check...

    As you said "I would expect that there is a voucher posted in journal 'GJT-04951***' directly on the main account from the customer balance. Can you check if this happened?"

    Suppose, if it happened then what to do ?

    kindly advice

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Customer reconciliation report showing difference for particular legal entity in AX 2012

    Hi @rp@n,

    Without technical details, when I read the details on the report, I would expect that there is a voucher posted in journal 'GJT-04951***' directly on the main account from the customer balance. Can you check if this happened?

    By the way, it is correct that all opening balances are not considered on this report. That is as per design as an opening transaction has no customer transactions.

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: Customer reconciliation report showing difference for particular legal entity in AX 2012

    hi Andre,

    Thanks for the response.

    I have run the report in below periods - 

    a1.jpg_2D00_640x480.jpg

    Report output

    2860.a1.jpg

    I have analyzed and found the above +ve marked amount is missing . I mean the particular voucher is not considering.

    Class - Ledger Reconcilation

    Method - insertNonSourceDocumentDetail

    4405.a3.jpg

    In the above code , i found in Table FiscalCalenderPeriod, it mentioned to consider only FiscalPeriodType = Operating

    and also analyzed the data from backend and found the particular record (voucher ) in table FiscalCalenderPeriod has FiscalPeriodType = Opening

    So, RecId get 0 while debugging i found

    Kindly let me know how to resolve this issue

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Customer reconciliation report showing difference for particular legal entity in AX 2012

    Hi @rp@n,

    Unfortunately, we don't know any details about your environment. Can you tell more about the missing voucher? What is the source of this voucher? Was it a customer related transaction or probably a manual posting? Is it skipped because of the date? Please provide some more information as we wouldn't be able to help you without any details.

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans