The NAV community, including the ArcherPoint technical staff, is made up of developers, project managers, and consultants who are constantly communicating, with the common goal of
sharing helpful information with one another to help customers be more successful.
As they run into issues and questions, find the answers, and make new discoveries, they post them on blogs, forums, social media...so everyone can benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this community—so we thought, wouldn’t it be great to share this great information with everyone who might not have the time to check out the multitude of resources out there? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from NAV experts and devotees around the world. We hope these insights will benefit you, too.
Adrian asks, “NAV selects the highest sales line discount among the multiple effective sales line discounts covering a sales line. Is there a way to add sales line discount on the top of another on the same line? Thanks for your ideas in advance!”
Todd replies, “…one of our clients has something like this but you have to add a new table to hold the multiple discounts for each line. You then sum up the discounts in this new table to arrive at "Line Discount %". We can review if you want. It's a little involved. Maybe others have done something easier.”
Michael adds that another client has customizations for an interface with a 3rd party discount application. He explains, “Records are pushed into a custom table in NAV. The Job Queue runs a codeunit that "sums" the multiple, active discount records into the Sales Line Discount table.”
Bill shares How to print (like on real paper) from Visual Studio Code and from Dynamics NAV C/AL.
Adrian shares that he found a website for a free NAV 2016 table relationship diagrams.
Bill adds that by right clicking on a table in Prism and picking "Explore Table Relations" gets you something similar. He elaborates, “If our customer's Master branches are up to date in source, you'll have what this offers plus all of the customization.”
Suresh found on Twitter that every Packt eBook and video are only $5. Time to grab a book and do some learning!
KC notes that they provide a free daily book from PacktPub, but it is temporarily unavailable while the $5 sales is going on. Make a bookmark for future reference.
Sherry has a client looking to implement standard costs by SKU and asks if we ever done this customization for another client.
Rick Dill states that he does not recommend it. “Standard Cost by SKU is a huge modification, and to be honest should be avoided. Let me make a partial list of the things that would be involved:
This is such a huge change, and really changes the core of the financial logic of NAV, that I have never suggested to a customer that they go this route. The integrity of the costing logic is so interweaved, that it is almost impossible to find every place that the code would need to be changed.”
Do any of our readers know of an ISV solution for this request? If so, please comment below.
Stay abreast of what is new in the Microsoft Dynamics NAV community and at ArcherPoint by subscribing to our monthly newsletter, Better Business, by completing the form in our Resource Center.
If you are interested in NAV development, be sure to see our collection of NAV Development Blogs.
Read the "How To" blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV.