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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Moving average Cost

(0) ShareShare
ReportReport
Posted on by 90

Dears 

 i have the following scenario :

1.create storage dimension groups ( site is activated, physical inventory is activate, financial inventory is selected).

2. item module group (inventory model is moving average, post physical inventory selected, post financial inventory selected ).

3. Receiving the following aquatints

a.Item A 100 in Warehouse AB   cost 10

b. item A 100 in Warehouse AC  cost 10

4. cost now in all warehouses is 10 

5. receiving new quantity 50 for the same item in warehouse  AB and the cost is 15.

6. now the cost shown for site is 11.

7. cost for the warehouse AB is 11.67

8. cost for the site AC is remaining the same 10.

9. when i am making an invoice or an issue for the item the cost is right 11.

10. the cost is showing the new calculation in the warehouse AB but it is the same old cost in Warehouse AC.

i need to see the new calculation of the cost in all warehouses when i am receiving any new quantity with new cost.

is it possible or no .

appreciate your help.

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    301,146 Super User 2025 Season 2 on at

    Hi Abdullah,

    Do you mean you want to have the moving average cost the same over all the warehouses within the site? In that case you need to deselect the 'Financial inventory' field of the warehouse line in the Storage dimension group. This is not possible when you made transactions already. The downside of doing so, is that you cannot use the Inventory value report with a warehouse specification.

  • Abdullah Sarhan Profile Picture
    90 on at

    Dear Andre

    thank you for your reply, exactly that what i want, when receiving new item with new cost to update all the warehouses with the new cost, instead of impact one warehouse,

    the 'financial inventory' is already deselected for the warehouse line in storage dimension group.

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…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans