Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Can you set different sell prices by location or by SKU

(0) ShareShare
ReportReport
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.

*This post is locked for comments

  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,868 Super User 2024 Season 1 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,868 Super User 2024 Season 1 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans