Sales Price Table - Additional Unit Price Field
Jonathan2708
Member Posts: 552
Hi,
I need to store an additional unit price for each record in the Sales Price table. There are 2 prices for each combination of customer/item/variant. Just wondered if anybody has done this development before and can point me in the direction of functions etc. that will need amending. The unit price selected will depend on a field on the Sales Header table when entering the order/invoice.
Any help appreciated,
Jonathan
I need to store an additional unit price for each record in the Sales Price table. There are 2 prices for each combination of customer/item/variant. Just wondered if anybody has done this development before and can point me in the direction of functions etc. that will need amending. The unit price selected will depend on a field on the Sales Header table when entering the order/invoice.
Any help appreciated,
Jonathan
0
Comments
-
Hi,
We have done the same added a delivered and collected price to the sales header. You can manage the selection based on sales header option through code unit 7000 in version post 3.7 and I think it was codeunit 55 in older versions.0 -
Many thanks Ger.
Jonathan0 -
Why do you need to bother with Code modification at all.
there is already two very good ways of acheiving what you want already
You can either base your prices discounts around the customers or around the Items Using customer price groups or items discount groups,
both provide you the Item/Customer/Variant code selection criteria already.
The customer discount group would probably be your preference if you want the header qualifications to determine the price.0
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
- 333 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