Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Inventory Cost Amount showing different values transaction form and Movement Journal

Posted on by 25

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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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 Profile Picture
    Maheen 25 on at
    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)

    pastedimage1562224293973v1.png

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

    pastedimage1562224443127v2.png

    I didn't understand what is the exact issue

    kindly help me the issue

    Regards

    Maheen

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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 Profile Picture
    Maheen 25 on at
    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

    pastedimage1562211588177v1.png

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

    pastedimage1562211680444v2.png

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

    pastedimage1562211885572v3.png

    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 Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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 Profile Picture
    guk1964 10,877 on at
    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 Profile Picture
    Maheen 25 on at
    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

    pastedimage1562144870891v1.png

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

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

    pastedimage1562145121064v2.png

    pastedimage1562145174772v3.png

    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

    pastedimage1562145361566v4.png

    but inventory transaction screen showing another one figure

    pastedimage1562145441343v5.png

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

    Regards

    Maheen

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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 Profile Picture
    MATTGUO 22,306 on at
    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.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans