Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Potential Conflict WIP and GL report

Posted on by 3,945

Hi Friends,

I am trying to reconciling my WIP ledger account and generate the "Potential Conflict work in progress and general ledger".As our company start using AX since 2012 so i am taking the dates for 1 year difference and for the year 2012 (from 1/1/2012 to 12/31/2016) i didn't get any discrepancy. For the year 2013 (from 1/1/2013 to 12/31/2013) get the following report:

2013.jpg

In The ledger it is showing 97,098.76 and work in progress it is showing zero and at the bottom it is showing all the GL manual entries whose sum is 97,100. So here i have the questions:

1. The General ledger balance value is coming from the trail balance and from where WIP value is coming.

2. And why there is a difference of 1.24 (97098.76-97100) in  GL.

And now when i generate for the year 2014 (from 1/1/2014 to 12/31/2014), i got the below data:

2014.jpg

I am not understanding how the report fetching the data, and how i can reconcile my WIP ledger account, please guide.

thanks in advance.

*This post is locked for comments

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Potential Conflict WIP and GL report

    Hi Imran,

    Can you test running the pot. conflict report and the inventory value report with a total account that includes your WIP and inventory account?

    Ludwig

  • imran ul haq Profile Picture
    imran ul haq 3,945 on at
    RE: Potential Conflict WIP and GL report

    Hi Ludwig,

    As i am reconciling the WIP ledger account, i specify the WIP ledger account while generating the potential conflict report. In the Trail balance, closing balance is $78,218.43 and in the potential conflict GL value is $-18,880.33, and when i generate the inventory value report by selecting the WIP only it is showing 0. And in the same report if i check mark the "indirect cost" in the report parameter material cost is coming zero and the indirect cost coming is $2466.43.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Potential Conflict WIP and GL report

    Hi Imran,

    The GL Balance that you see in the potential conflicts report should come from the account that you specify when running the report. If you want to compare the balance shown in the trial balance with the one shown in the report make sure that both reports are run for the same period.

    Regarding the $2466.43: Can you identify how they are created? For example through indirect cost % specified in the costing sheet?

    About the closing amount: Have you run the inventory value Report for the same period? What amount does this Report Show for the financial, physical and total inventory value? I would imagine that it is $-21346.76. Can you check what the inventory value Report Shows? (Note: when running the report please ensure that you also check the WIP and the other report parameters).

    Best regards,

    Ludwig

  • imran ul haq Profile Picture
    imran ul haq 3,945 on at
    RE: Potential Conflict WIP and GL report

    Hi Ludwig,

    WIP transactions came from the production module, as you said i generate the balanes report from the production module. In Materials and finished item in process report is blank but in work in process report found some production order but no amount, also i generate indirect cost in process and found some production orders with total amount of 2466.43, which is showing in the Potential conflict report.

    Here also i would like to ask, in the potential conflict report, balances under general ledger comes from where, as per my understanding it is just giving the sum of the debit and credit of the period.

    Here while reconciling the ledger, following is my trail balance for the period:

    5751.1212.jpg

    Here the full amount of the opening balance came from the GL entry of 2013, sum of debit credit is -18,880.33 for the period. And as in the report we had one amount,what amount we should consider as the closing of the period 2014?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Potential Conflict WIP and GL report

    Hi Imran Ul Haq,

    Can the WIP transactions be related to production transactions that are executed in your system? Have you compared the amount shown in the report with the standard production WIP reports available in the production module?

    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