Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I hope this community can help us...
What is the best practices in uploading prices? We have ~30k customers and ~30k items and quantity break or column pricing for each item: e.g. Item12345 Qty 1 List price $100, Qty 5 List price $90, Qty 10 List price $80, Qty 20 List price $70, etc.
We have hundreds of different trade agreements and we would like to use our NAV ERP correctly to change prices. Is there a pricing module for NAV?
Thank you very much for your insights into this! Currently we have to upload .txt files...
Current pain points
Ideal or Best practices in pricing system – wish list, needed features etc.
Hope we can start using NAV 2017/2018 correctly when we upgrade end of 2018.
Sales prices can be loaded into Sales Price table in NAV using Rapidstart Services (they will be loaded from an Excel template) or via CSV/TXT file by using a custom XMLPort or via web services (for more advanced scenarios).
For other things that I see listed in your post, you need some customizations.
I appreciate you taking the time to try to help us with the price uploads. I believe the problem is that we have several trade agreements with very large number of lines to be uploaded (e.g. 30k items x 100 customer price groups x 5 quantity breaks = over 1M records).
Using the Sales Price table is what IT is doing when we have large number of lines. We are using a Pricing Server to not slow down the NAV production system and then IT loads data to Sales Table in production NAV.
Sanela Halilovic, Pricing Administrator5724 North Pulaski Road, Chicago, IL 60646 Shalilovic@labelmaster.com
Director of Marketing & Business Analytics O: 773.279.2219 M: 248.872.7038 5724 North Pulaski Road, Chicago, IL 60646Mfuentes@labelmaster.com
For such a number of record for sales prices, using Excel is impossible. You've to think to a different upload, using for example Web Services or direct writing into tables 7002 (Sales Price) and 7004 (Sales Line Discount).
Business Applications communities