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

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Can you set different sell prices by location or by SKU

(0) ShareShare
ReportReport
Posted on by 74

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.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    azelaya59 Profile Picture
    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.

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,261 Super User 2025 Season 2 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.

  • Chris_A Profile Picture
    74 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
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,261 Super User 2025 Season 2 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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Alexander Ermakov Profile Picture

Alexander Ermakov 2

#2
SC666 Profile Picture

SC666 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans