web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    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?

  • Guy Terry Profile Picture
    Guy Terry 28,924 Moderator on at

    Hi Jericho

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

  • Jericho Profile Picture
    Jericho 5 on at

    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.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    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

    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.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    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?

  • Suggested answer
    Jericho Profile Picture
    Jericho 5 on at

    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).

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Sukrut Parab Profile Picture

Sukrut Parab 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans