Sales Price Location wise ?
manisharma31
Member Posts: 285
I am looking for setting up sales prices for my customer, with combination of Unit of Measure & Location.
Should i customise this or there is some standard avaliable.
I know the customer price group.
Should i customise this or there is some standard avaliable.
I know the customer price group.
Regards,
Manish
Manish
0
Answers
-
Not in standard you need to work around for location code UOM is already covered.0
-
I posed the same question through a MS Forum. Here was the answer:
"Is there a native way for setting up prices based on a specific location? What if I have 2 locations that sell the same part for different prices based solely on the fact that it costs more to get the parts to one location then the other? It’s almost as though the Sales Prices windows need to be extended to include Responsibility Center, or at the very least, Location Code. What other options do I have?"
1) It appears you may be able to create a SKU using the Variant Code to do what you want. You can bring in the Variant Code on the Sales Prices window of an item and then set a Sales Price for the Item/Variant in the Sales Price window. This is probably not the ideal method to use, but it might work. However if you have a lot of items you need to do this for and lots of different customers, then this process is probably too cumbersome.
2) Suggestion by another partner: You can setup a Price Group Code for the different locations for each item. On the sales order, you'll need to manually change teh Price Group Code in order for the sales lines to reflect the proper price. It's a simple mod to default it on the Ship-to Address or the Location Code.0 -
Looks like price group would be a good option.
Thanks everyone.Regards,
Manish0 -
Just modify table 7002 Sales Price, its an easy modification.David Singleton0
-
I agree with David's suggestion...it reduces data entry issues as well....user may forget to change the price group may a times.
Regards,
Sridhar0 -
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 329 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
