web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • 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... 297,205 Super User 2025 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... 297,205 Super User 2025 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,837 Moderator 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... 297,205 Super User 2025 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
KP-31070522-0 Profile Picture

KP-31070522-0 3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans