Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

Can you set different sell prices by location or by SKU

Posted on by 70

I have an issue that I can't believe is unique to my organisation....

We sell the same Item from 2 different physical locations. The main location ships the Item in bulk to the remote location. This adds significantly to the cost of the item. The Item is sold from both locations, with the relevant location being selected by the customers geographical location. How can I set a sell price for this item in the new location that reflects our added costs?

I have set up a SKU for this item in the new location as I did want to have different reorder points but I can't see any simple way of setting a different sell price in an SKU.

Any pointers to solve this would be appreciated.

  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,861 Moderator on at
    RE: Can you set different sell prices by location or by SKU

    That is one way of doing it without customization.

    However, user need to specify the price group every single time, so there is a risk for user error.

  • Chris_A Profile Picture
    Chris_A 70 on at
    RE: Can you set different sell prices by location or by SKU

    This is a response I got from our NAV contractor. Seems a bit hit or miss but maybe the only non custom way of doing it.

    Thanks Alfredo and Teddy for your replies.

    "NAV does not allow to setup price per location or SKU. Only cost can be setup per SKU.

    Only workaround is to setup two price groups to represent the two locations and define sales prices against those price groups in sales price area. Then, when sales order is entered the user has to select the appropriate price group in the sales line."

  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,861 Moderator on at
    RE: Can you set different sell prices by location or by SKU

    The SKU is more towards costing and replenishment. If you want it by Location, you need to customize it.

  • Suggested answer
    azelaya59 Profile Picture
    azelaya59 2,807 on at
    RE: Can you set different sell prices by location or by SKU

    Sales Prices are on the Item Card ONLY. Not the associated Stockkeeping Cards. These are inventory/replenish purposes only. You will have to do a customization for Sales prices driven by location.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans