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 :
Small and medium business | Business Central, N...
Suggested Answer

How to find the average cost of an Item variant

(0) ShareShare
ReportReport
Posted on by 3,372

Hi All

We are using item variants and costing by Variant and location under the inventory setup screen.  Now the problem is there is no easy way to find the cost of item variants without running the inventory valuation report filter by a particular variant.  Is there another screen related to item that shows unit cost of each variant? or any other methods/reports?

Thanks

  • Suggested answer
    JAngle Profile Picture
    159 on at

    Apply the flow filter on the item list page for variant. Drilldown on the unit cost and it carries over the filter.

  • Suggested answer
    Kavisha Profile Picture
    310 on at

    Hi Samantha

    Yes, You can create stock-keeping units prior to use variants in the transactions. 

    The unit cost will reflect average unit cost per variant for each SKU created for each location and variant. 

    Steps I used :- 

    Item card created --> related --> warehouse--> stock keeping units. Create stock keeping units for each location and variant combination. 

    Did few purchase and positive adjustments for each variants. It reflected Average unit cost on the item card for all variants but reflect Unit cost average in the stock keeping for each variant. 

    Make sure SKU exists before doing transactions. 

    Regard

    Kavisha . 

    Please select Yes if this helps or answered your question. 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 674 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 362 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 359 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans