Microsoft Dynamics AX (Archived)

Inventory Cost Amount showing different values transaction form and Movement Journal

(0) Share

Report

Posted on by Maheen

Example:

In the Movement Journal, I have an entry for a 1 Qty at 212 is cost price, for a total of -212.00.

After Posting I found the Transaction in particular item Cost Amount is showing -151.07.

We are on Weighted Average cost method,

My questions:

1) Why is there a discrepancy between the Movement Journal and the General Ledger? If cost is recalculated at month end, I would expect the recalculation to be reflected everywhere the voucher is posted.

2) Since there is a discrepancy, does anyone have an idea where I might look in the setup to see where the difference is being posted.

Kindly help us

Regards

EDC

*This post is locked for comments

All responses (9)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Inventory Cost Amount showing different values transaction form and Movement Journal

Hello Maheen

What is the clearing account that is shown in the inventory value report?

Is this part of your inventory posting matrix or has it for example been used for data migration?

Do you post your item groups on separate accounts? If so, try to run the report by item group to find out which group / item causes the main difference

Best regards

Ludwig
Maheen 25 on at

Like (0)

Report

RE: Inventory Cost Amount showing different values transaction form and Movement Journal

Hi Ludwig,

I found Inventory summary account is mapped one expense account finally I removed the expense account and run inventory value report still have the difference with GL (below screen shot)

The same period I was run the potential conflict report I didn't find any difference (below screenshot)

I didn't understand what is the exact issue

kindly help me the issue

Regards

Maheen
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Inventory Cost Amount showing different values transaction form and Movement Journal

Hello Maheen,

The most important thing is that you select the correct total account that summarizes all inventory accounts.

In your potential conflict reports there were some lines that mentioned that the account does not represent inventory. Can you check whether those accounts have an inventory account category setup? If the correct category is assigned the warning should disappear.

The transactions that cause real differences between GL and inventory are those where it says direct postings... these transactions need special attention and you have to find out why postings in GL has been made on those accounts. Try to correct those and run the report again to see what is left in regards to warnings and errors.

Best regards

Ludwig
Maheen 25 on at

Like (0)

Report

RE: Inventory Cost Amount showing different values transaction form and Movement Journal

Hi Ludwig,

When I was run the Potential conflict Report inventory summary account , that time also got huge difference is there

This below screen shot is last page of the Report(Potential conflict)

When I run the inventory value report also using inventory summary accout I got the below figure

we are using weighted average method.

Kindly help me how rectify the issue ,

what is the reason we got this much difference figure?

Regards

Maheen
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Inventory Cost Amount showing different values transaction form and Movement Journal

Hi,

In addition, is account 123001 a total or summary account, which should be selected here. I would expect that you use more than a single inventory account. So please double check this with your configuration

Best regards

Ludwig
Suggested answer

guk1964 10,877 on at

Like (0)

Report

RE: Inventory Cost Amount showing different values transaction form and Movement Journal

its difficult to comment without more information on what other transaction was posted when, when your calculated or closed, and when you transacted the movement , whether your average set up is by Site or by warehouse etc.

Recalculation is not settlement, so each time it runs it will calculate all the way back to the last closed period not just the current period.

A back dated transaction is one of several possible reasons.

I suggest run the potential conflicts report filtered for that item from the day before the transaction date to the period end.

This report can be found under Inventory management > Reports > Status > Inventory value.

In the "Main account" field insert the main account that sum up the different inventory main accounts and is reconciled against the inventory value report.
Maheen 25 on at

Like (0)

Report

RE: Inventory Cost Amount showing different values transaction form and Movement Journal

Hi Ludwig,

Thank you for your quick Response,

My scenario is reconcile the Inventory account for (eg: 123001) from 01/01/2019 to 31/12/2019

The particular Period the TB is : 339,380.160

Inventory Value report setup is below screenshot

The particular Period the Inventory Value Report Amount is : 288,111.44

The particular Period the Potential Conflict Inventory GL Amount is below screenshot

Then I click the Comment message system open the inventory transaction form and I found the transaction is linked to movement journal below screen shot

but inventory transaction screen showing another one figure

This was my problem why this much difference coming is there any wrong setup or anything else.

Regards

Maheen
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Inventory Cost Amount showing different values transaction form and Movement Journal

Hi EDC

I don't think that there is a variance between inventory and GL. Just check your voucher and you should see this. What you see is the standard behavior of AX in case of issue transactions through journals.

Best regards

Ludwig
MATTGUO 22,306 on at

Like (0)

Report

RE: Inventory Cost Amount showing different values transaction form and Movement Journal

Hi Maheen,

The displayed cost in movement journal default comes from the cost field of manage cost tab or cost type of item price tab in released products.

The quantity is negative, system will calculate the actual cost of item when posting it.

If the quantity is positive, the cost of movement journal and general ledger will be same.