Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Inventory Closing Adjusted Value

Posted on by 475

Dear All,

            similar to my previous post on Inventory Closing having difference in inventory VS GL. I notice one more thing which I am going to share now. on same post not posted because of no reply coming to that.

when I close inventory for the month it adjust the value on all transaction but the value adjusted on Transfer Order ("Inventory Module--Periodic") giving discrepancy between subledger vs GL.

I am not getting why or its not consider as non financial transfer or may be I am missing any GL Account in Item group setup. I don't know.

did anyone face the same issue?

*This post is locked for comments

  • Sajjad_00 Profile Picture
    Sajjad_00 475 on at
    RE: Inventory Closing Adjusted Value

    Hi Ludwig;

                       Yes. and if 365 (Both Cloud Base or on premises) covering all features of R3

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory Closing Adjusted Value

    You mean whether to upgrade to AX2012 R3 vs. upgrading/implementing MSDyn365FO?

  • Sajjad_00 Profile Picture
    Sajjad_00 475 on at
    RE: Inventory Closing Adjusted Value

    Hi Ludwig;

                   yes I consider that and forward to management also but the issue is now we have 365 so what is best to go for and budget also as an issue.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory Closing Adjusted Value

    Hi Sajjad,

    We had a couple of customers who had problems with the R2CU7 environment and brought them all up to the latest R3 versions, which often fixed the problems.

    I am not sure if this might help in your case and how much time and effort such an upgrade requires but maybe it is something you want to take into consideration?!

    Best regards,

    Ludwig

  • Sajjad_00 Profile Picture
    Sajjad_00 475 on at
    RE: Inventory Closing Adjusted Value

    HI Ludwig,

                    this third option already I am using same. but issue is something else or maybe the report getting some bug. like there is fix but the issue is I am not able to apply this fix as it creating some other problem in my environment. I try to get consultant to apply the fix but no one ready to take a risk factor.

    may be you know that or gone through. Inventory Aging report where for example if you have 5 items and let says 2 item have no qty and value then when you print I will show the Qty and Value for that item also as inventory Qty and value. the reason behind that is not clearing the variables and pass the value for empty stock item.

    in short there is some classes or method ("Inventory Stock") which picking a wrong info and need to be apply patches or through developer to correct that.

  • Sajjad_00 Profile Picture
    Sajjad_00 475 on at
    RE: Inventory Closing Adjusted Value

    Hi Ludwig;

                  thanks first two fix I checked also but now I am looking a third one you mentioned. I will get back on the result.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory Closing Adjusted Value

    Hi Sajjad,

    I see. Do you have a very concrete example where you identified a variance between GL and inventory that was caused by your transfer journals?

    Can I also ask you to take a look at the following articles/fixes that I found on LCS and that might help?

    • KB 3049568The Vendor/Ledger Reconciliation report shows difference if selecting "Include details"
    • Solution 3626020Transfer Order Costing Issues
    • Issue 3601557Inventory and general ledger discrepancy due to adjustment in a transfer order

    Best regards,

    Ludwig

  • Sajjad_00 Profile Picture
    Sajjad_00 475 on at
    RE: Inventory Closing Adjusted Value

    Hi Ludwig;

                    I my self admin for the system and there is no modification which can change the posting rules. Transfer Journal post both Issue and Receipt same time but Transfer Order no it first ship then received two steps process. plus we can add a transport charges also.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory Closing Adjusted Value

    Hi,

    I am not sure what this means. Do you have a system admin guy around who knows whether a system modification has been made that might be responsible for this variance?

    Transfer orders should actually not create variances because they post a receipt and an issue at the same time.

    With the things that you described I am not sure whether your system behavior is caused by a bug or a modification that has been made.

    Guess we need somebody from the technical platform side who can dig deeper at the database level.

    Best regards,

    Ludwig

  • Sajjad_00 Profile Picture
    Sajjad_00 475 on at
    RE: Inventory Closing Adjusted Value

    Hi Ludwig;

                  I check there is no voucher generated. but on transaction ledger tab showing GL.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans