Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Sales price Codes
NaveenReddy
Member Posts: 53
For each Item we have three sale price code A,B,C set.
For example:
For item No: 1234
Regular Unite Price = 110
We set customer price groups with Sale code A with unit price 100
B With unit price 90
C With unit Price 80
When creating a sales Line with customer price group A on the sales header for this Item, The system will automatically fill in the unit price as 100, But what we want to do is, if quantity is less than 10 it should take 100 as unit price but if quantity is more than 10 It should take price C’s unit price that is 80 even if we selected Price A as the customer price group on the sales header. In other words we want to over ride the unit price on the sales line with Price C’s unit price if the quantity is more than 10.
How can we achieve this ?
If we do write code to over ride the unit price will it effect over functionality of navision?
For example:
For item No: 1234
Regular Unite Price = 110
We set customer price groups with Sale code A with unit price 100
B With unit price 90
C With unit Price 80
When creating a sales Line with customer price group A on the sales header for this Item, The system will automatically fill in the unit price as 100, But what we want to do is, if quantity is less than 10 it should take 100 as unit price but if quantity is more than 10 It should take price C’s unit price that is 80 even if we selected Price A as the customer price group on the sales header. In other words we want to over ride the unit price on the sales line with Price C’s unit price if the quantity is more than 10.
How can we achieve this ?
If we do write code to over ride the unit price will it effect over functionality of navision?
0
Comments
I think u cant achive this from the base functionality of navision .
You will have to put a condition where it is picking up the unit prices for customer price groups.I cant see anyother way out .
Might be wrong let see what others have to say on it
Cheers,
Tarun
I think you should reconcider if you want to implement such a pricing strategy. Pricing is normaly very important to organisations and maintenance of sales prices and such is something to take into concideration.
You could implement a number of strategies:
> link both items to the price group A and use the minimum quantity to setup up the level of 10 (first price linked to minimum 1 and second level linked to minimum of 10).
> other possibility is to link the standard sales price to the customer price group A with a minimum of 1 and then link the price > 10 to a Sales Price entry (table 7002) that applies to all customers (or if that is not what you want to a specific customer).
It is my belief that you should try not to tamper to much with basic Navision coding (unless there is really no other option). Think about the updates you want to install in a year..... and then in two... etc...
Hope this helped...
Prins Hendrikplein 14
2518 JC DEN HAAG
The Netherlands
http://www.cane.nl
I think thats the only option i have, two A sales codes with different quantity.
Even i am thinking not to modify base navision code, But lets see what my client going to say.