Potential Conflict WIP and GL report

(0) Share

Report

Posted on by imran ul haq

3,947

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:

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:

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

All responses (5)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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 3,947 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 3,947 on at

Like (0)

Report

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:

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 Microsoft Employee on at

Like (0)

Report

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