Quick way to get a lot of unit prices

jensmurer
Member Posts: 3
We have to export pricelists in CSV-format multiple times a day. I do so by filtering Item-records and exporting these by a XMLPort. These pricelists contain - unsurprisingly - unit prices. To get the correct unit price per item and customer I have so far found CodeUnit 700 "Sales Price Calc. Mng." which calculates the unit price in Sales Lines in the Client. To do so programatically I have to create a temporary Sales Header, add a temporary Sales Line and pass this to FindSalesLinePrice of Codeunit 7000. This is by FAR to slow for the number of lines I have to create. One pricelistfile takes several minutes and there are nearly a thousand of them.
Is there a quicker way to get to the unit price for a Customer/Item-combination?
To be honest I already pushed the logic to get the Pricelist-receiving customers and their specific item-catalogs into SQL-views/-functions. But this data comes solely from two of our own modules. I don't want to transcribe the NAV-Standard-Codeunit's logic to SQL and have to look after this workaround in the future.
(Sorry for some weird Capitalization, my browser seems to have its own opinion towards that.)
Is there a quicker way to get to the unit price for a Customer/Item-combination?
To be honest I already pushed the logic to get the Pricelist-receiving customers and their specific item-catalogs into SQL-views/-functions. But this data comes solely from two of our own modules. I don't want to transcribe the NAV-Standard-Codeunit's logic to SQL and have to look after this workaround in the future.
(Sorry for some weird Capitalization, my browser seems to have its own opinion towards that.)
regards
Jens Murer
Jens Murer
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 320 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