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

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) / Verifying Weighted Ave...
Microsoft Dynamics AX (Archived)

Verifying Weighted Average Cost

(0) ShareShare
ReportReport
Posted on by GORAV_VASHISTHA 50

Hi All 

Greeting !!!

Please advice how to verifying WT Average rate against any part in AX 2012 R3. 

If any option is available or we can do some workaround. 

Example :   

Item Code  Part-001
Date Received Qty Issue Qty Purchase Prices  Value  WT Rate 
01-12-17 10   10 100 10.00
10-12-17 10   5 50 7.50
14-12-17 10   10 100 8.33
20-12-17 10   3 30 7.00

Regards

Gorav Vashistha 

*This post is locked for comments

I have the same question (0)
  • Guy Terry Profile Picture
    Guy Terry 28,972 Moderator on at

    To see the current running average cost price for any item:

    1. Check the Storage and Tracking dimension groups, and make a note of which lines are both 'Active' and enabled for 'Financial inventory'.
    2. Go to the On-hand inquiry (Inventory management -> Inquiries).
    3. Use 'Dimensions display' to enable only those dimensions which are enabled for Financial Inventory.
    4. Click on any line with 'Physical inventory'.
    5. Go to the 'On-hand' tab. The current running average cost price is shown at the bottom of the middle column.
  • GORAV_VASHISTHA Profile Picture
    GORAV_VASHISTHA 50 on at

    Hi Guy Terry

    Thanks for your reply but i want to verify that amount which is showing in on hand inventory tab.

    If auditor ask me kindly verify this rate how we can verifying in AX.

    Kindly advice.

  • Suggested answer
    Mahmoud Hakim Profile Picture
    Mahmoud Hakim 17,887 on at

    Hi GORAV_VASHISTHA

    you need to check the above point as guy said to verify, weighted average change based on  Storage and Tracking dimension group parameters

  • GORAV_VASHISTHA Profile Picture
    GORAV_VASHISTHA 50 on at

    Hi Hakim

    Yes, We can verifying current running cost as per Guy suggest.

    Let me clarify my question.

    As per my above mention table 20 Dec 2017 WT Avg rate "7.00" will be showing in On-Hand Inventory Tab but I want to verifying transaction wise Wt rate and submit to Auditor for reconciliation of WT rate against X part. 

    Regards

    Gorav Vashistha 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans