Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Suggested answer

Monthly Inventory closing

Posted on by 10

I am trying to close inventory on month-end. at the time of closing, the error returned was 'Account number for transaction type Price difference for moving average does not exist.' I have already set all the required posting parameters for the item group of the item I'm posting.

  • Suggested answer
    Vamsi Pranith Profile Picture
    Vamsi Pranith 682 on at
    RE: Monthly Inventory closing

    Have you changed your costing method on any of the items? Were all the items/item model groups set to Moving average all the time? It could be possible that you might have changed the model group or the costing method and it may be causing this issue.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,113 Super User 2024 Season 2 on at
    RE: Monthly Inventory closing

    Hi Dynamis 365,

    When I reread your question, you are talking about inventory closing and it is requiring an account for moving average. This is odd as the moving average is not an actual costing method which is used in the inventory closing calculations.

    Can you check if you have customizations or share what exactly you start as part of the "close inventory on month-end"?

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: Monthly Inventory closing

    could u share the visuals of inventory posting ?

    meanwhile pls check with an Error account defined in Accounts for automatic transactions

  • dynamis 365 Profile Picture
    dynamis 365 10 on at
    RE: Monthly Inventory closing

    Hi Andre,

    Yes i did. but it didn't work for me. i tried to assign account item group level and for all item level as well. Already revalidate account structure as well.

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: Monthly Inventory closing

    ususally seen this with accounts structure.

    try activating again and suggest ensuring the account is present and also the financial dimensiions are valid / not suspended

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,113 Super User 2024 Season 2 on at
    RE: Monthly Inventory closing

    Hi,

    Can you share a screenshot of the Inventory posting form with the selection on this price difference account? Did you try to set a main account for 'All' items as well?

  • dynamis 365 Profile Picture
    dynamis 365 10 on at
    RE: Monthly Inventory closing

    Hi. Mariano,

    Yes i already did. but it didn't work.

  • Mariano Melo Profile Picture
    Mariano Melo 339 on at
    RE: Monthly Inventory closing

    Hi!

    Have you tried to setup the "Price difference for moving average" account in the general ledger under accounts for automatic transactions, besides the Item group?

  • dynamis 365 Profile Picture
    dynamis 365 10 on at
    RE: Monthly Inventory closing

    Thanks for your reply Rahul!

    Price difference for moving average account is alreaddy added in account structure. i have validate and activate the account structure.

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: Monthly Inventory closing

    If all required setup is accurate then pls review and confirm your accounts structure is good and covers the account used for posting Price difference for moving average

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans