Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Posing to Inventory Mo...
Microsoft Dynamics AX (Archived)

Posing to Inventory Moving Average problem

(0) ShareShare
ReportReport
Posted on by Jericho 5

Ok, so I was trying to generate a product receipt for a product that has a moving average inventory model set:

I'm in Purchase Order, done registering the incoming inventory using item arrival journal, and was ready to post product receipts.

po_2D00_item_2D00_post_2D00_receipt_2D00_overview.png

po_2D00_item_2D00_post_2D00_receipt.png

However, this error occurred:

PI_2D00_ERROR_2D00_Account_2D00_Missingpng.png

The error returned was 'Account number for transaction type Price difference for moving average does not exist.' 

Mind that I've already set all the required posting parameters for the item group of the item I'm posting (and being redundant at that):

itemgroup_2D00_posting_2D00_invent.png

The item group for the Purchase Order's (single line) item is MG-MCH, which has a set account. you can also see that I've set the 'All' category.

I've been brooding at this problem for days now.

My application version is 6.3.164.0 if that's important. For the AOS version, I do not have right now, but will ask if needed.

*This post is locked for comments

  • Suggested answer
    Jericho Profile Picture
    Jericho 5 on at
    RE: Posing to Inventory Moving Average problem

    Yup, that's the problem. We have a somewhat complicated accounting structure configuration so when the account for Moving average entries was created, it didn't register in the structure. Adding the new account solved the problem.

    But seriously the error displayed by the system was too vague I thought it wasn't related to accounting structures (which we completely forgot about).

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,642 Super User 2024 Season 2 on at
    RE: Posing to Inventory Moving Average problem

    I would like to know the setup of the accounting structure where is account is part of. Can you share some more information about that? Probably a screen shot?

  • Jericho Profile Picture
    Jericho 5 on at
    RE: Posing to Inventory Moving Average problem

    Well we created multiple purchase orders with a product that has a moving average model but they're all the same, won't post product receipts. Posting completes with products that don't have a moving average model though.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,642 Super User 2024 Season 2 on at
    RE: Posing to Inventory Moving Average problem

    Hi Jericho,

    Can you try to create a new purchase order and see if this works? If so, it is related to a non updated accounting distribution of the purchase order where the account might be missing. It is also possible to reset the accounting distribution.

  • Jericho Profile Picture
    Jericho 5 on at
    RE: Posing to Inventory Moving Average problem

    Yeah, I have multiple legal entities but all of them are only samples (the Contoso companies from the training modules). We created a clean legal entity (MEST) and ploughed our way through the settings from scratch. We encountered this error before the posting settings for inventory was configured however. But the error still persists even after configuring the inventory posting for moving average (even after creating a new purchase order; this is our 29th one).

    @Guy Terry

    Yes the account for the setting is active.

  • Guy Terry Profile Picture
    Guy Terry 28,626 Super User 2024 Season 2 on at
    RE: Posing to Inventory Moving Average problem

    Hi Jericho

    Is the main account '420-020' part of an active Account structure in the G/L module?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,642 Super User 2024 Season 2 on at
    RE: Posing to Inventory Moving Average problem

    Hi Jericho,

    The setup seems to look correct for the Posting part. Can you indicate if this setup was done after the first attempt to post the product receipt?

    Can you also indicate if you have multiple legal entities and copied settings from another legal entity into this one?

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans