Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Inventory Count - Ledger Journal is not generated

Posted on by Microsoft Employee

Hello guys,

I just created the Item Counting Journal, my requirement is that I will fill the Quantity and Cost Amount, thus the cost price will automatically calculated.

However when I post the journal, suddenly the cost amount is blank and then there is no journal generated.

Is there missing set up in my system?

Thanks in advance for the help,

Regards,

M.H.

*This post is locked for comments

  • Guy Terry Profile Picture
    Guy Terry 28,621 Super User 2024 Season 2 on at
    RE: Inventory Count - Ledger Journal is not generated

    Hmm. I find the same. Must be something specific to the Moving average model (although I'm not sure why it doesn't allow you to give a value to inventory you've counted if you don't already have some on-hand).

    Personally, I wouldn't spend too long worrying about that for your initial data migration. Instead of using a Counting journal, I would use a Movement journal. If you use a Count Journal, AX will post to the inventory profit account, and I don't think I have ever seen anyone do this during initial data migration. A Movement journal allows you to specify a different account to use as the offset account.

    Another advantage with a Movement journal, which I've just tested, is that it allows you to use the Moving average model and value the item as you expect.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Count - Ledger Journal is not generated

    Hi Guy Terry,

    In my inventory model I have set the Post financial and physical invenotry tick mark.

    Btw I just found the cause of my problem.

    In my case the Inventory Count only works when I choose the FIFO model group.

    While MWA (Moving Average) only works when I have already perform Inventory Adjustment Journal previously.

    Is this the correct method?

    I use the inventory count for initial data migration.

    Regards,

    M.H.

  • Guy Terry Profile Picture
    Guy Terry 28,621 Super User 2024 Season 2 on at
    RE: Inventory Count - Ledger Journal is not generated

    Hi M.H.

    On the Item model group of your items, what is the Inventory model set to?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Count - Ledger Journal is not generated

    Hi Nagendra,

    I currently try again the process to generate the counting.

    This time I use other warehouse/site (my set up is site, Wh).

    But now I couldn't generate the ledger journal.

    Below is my set up for Inventory Parameter, Site, and Warehouse.

    Inventory-Set-Up.pngInventory-Set-Up.png

    FYI,

    I only able to generate ledger in warehouse 0201.


    Thanks,

    M.H.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Count - Ledger Journal is not generated

    Hi Nagendra,

    Thanks very much for your advise.

    It works very well..

    M.H.

  • Verified answer
    RE: Inventory Count - Ledger Journal is not generated

    Hi Hasan,

    Counting Journals should be created either though on-hand or Items, You can find this on the create menu item on lines, When you select from on-hand system will generate line with on-hand and specified dimensions you will also find on-hand quantity and than you need to key In adjusted quantity and there you can also see the cost amount in the General tab cost amount. Please note when generate Counting journals it is also mandatory to select dimensions if any specific you are maintaining.

    Thanks

    Nagendra Varma K 

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!

Community AMA December 12th

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

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans