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 :
Business Central forum

Article/item dimensions

(0) ShareShare
ReportReport
Posted on by

Hi All,

I'm new to Business Central and need some advice/help from the experts.
In AX 4.0 (our current version) we have an item called "travel cost" with a dimension "distance".

Distance Price
< 15 KM € 130,-
< 75 KM € 175,-
< 150 KM € 200,-

In this example I have only added 3 lines but there are more. There are also many other items where we use the same principle.
We use this to keep our list of items short. Several hunderds instead of thousends.
Our salesdepartment now only has to select "travel cost" and "<75 KM" to make a quote.

In Business Central I've looked at Variants and Attributes but can't find where to put the salesprice (and cost).
Am I looking in the right direction or do I need a different approach?

Thanks,
Paul

  • Suggested answer
    Adam Shilton Profile Picture
    460 on at

    Hi Paul, you're right to be using variants, you just need to update the pricing as per the screenshots below. I'd recommend the sales price worksheet as the easiest way to do it in business central... You'll also have to use the personalise function to add 'Variant Code' into the table.

    1. Make sure your variant codes are setup
    2. Navigate to 'Sales Price Worksheet' using the search function
    3. Add 'variant code' into the table using the personalise function (top right cog)
    4. Update your prices and register the change

    This worksheet is also useful for implementing bulk pricing changes as well. You can also apply discounts based on unit of measure, customer group etc

    Thanks

    Adam

    Sales-Price-Worksheet.png

  • Community Member Profile Picture
    on at

    Hi Adam, thank you for your response.

    Good to know I was on the right path. I managed to get the sales prices per Variant right.

    Next question. Is there also a place where I can input the "Unit cost" per Variant?

    Thanks,

    Paul

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans