web
You’re offline. This is a read only version of the page.
close
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) / Potential Conflict WIP...
Microsoft Dynamics AX (Archived)

Potential Conflict WIP and GL report

(0) ShareShare
ReportReport
Posted on by imran ul haq 4,017

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

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

  • imran ul haq Profile Picture
    imran ul haq 4,017 on at

    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?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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 4,017 on at

    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.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans