Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Cost+ special pricing for variants with different costs

Posted on by

This is our situation

We will have a base item (gold chain) which has 10 variants (setup as variants and SKUs). Each of those variants will have a different cost price (the variants are different lengths so the cost price increases)

What I want to do is set a special price of cost+%. However, when I do, it's only calculating it against the item base cost and not the individual variant costs. I confirmed this in sandbox testing

SKU Setup

pastedimage1605643723322v1.png

SKU Cost showing

pastedimage1605643791474v2.png

Special Pricing Setup (its incorrectly showing the unit cost as $4 which is what's on the base item), each SKU has a separate cost, 45cm is $2, 50cm is $4, 55cm is $6)

pastedimage1605643885131v3.png

  • Richard Mayo Profile Picture
    Richard Mayo on at
    RE: Cost+ special pricing for variants with different costs

    That is a standard field in BC. It hasn't been added.

    Clicking on it just brings up another screen showing the base item...

    pastedimage1605724556639v1.png

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,137 on at
    RE: Cost+ special pricing for variants with different costs

    The “Cost” field in the sales price screen shot you have provided. Value is in teal colour which indicates a drill down so I assume it’s a flowfield

  • Richard Mayo Profile Picture
    Richard Mayo on at
    RE: Cost+ special pricing for variants with different costs

    Which field are you referring to?

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,137 on at
    RE: Cost+ special pricing for variants with different costs

    Fairy sure that isn’t a standard field and furthermore it is clearly a flow field so it must be to the item table and not the SKU. Do you have any extensions for this part of the system? If you aren’t sure try and see if you can activate page inspection: docs.microsoft.com/.../across-inspect-page

    Either way it I would check what the result is from a purchase order. With that field just being a flow field it is for information only and is not reflective of whether the intended result will actually take place.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans