January 26, 2018
ArcherPoint Dynamics NAV Developer Digest - vol 176
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.
Dynamics NAV 2017 Security, Customer and Vendor UpdatesGwen Brit shares: Here's a little heads-up related to security and functionality. In version NAV 2017 (and only NAV 2017) there is a piece of code that updates the Customer or Vendor address on their Card if the address fields are blank and you enter an address on their Sales or Purchase headers, respectively. In other words, if you create a Customer Card and intentionally leave the address blank, then create a Sales Order and fill in the address information on the Sales Header, without prompting, NAV will update the Customer Card with the address from the Sales Header. If the order creator does not have permission to modify the Customer Card, they will receive a permissions error. Here's the code from the Purchase Header Table (38), the OnModify trigger: OnModify() UpdateVendorAddress; LOCAL UpdateVendorAddress() IF Vendor.GET("Buy-from Vendor No.") THEN IF NOT Vendor.HasAddress THEN CopyBuyFromVendorAddressFieldsFromPurchaseDocument(Vendor); IF "Pay-to Vendor No." <> "Buy-from Vendor No." THEN IF Vendor.GET("Pay-to Vendor No.") THEN IF NOT Vendor.HasAddress THEN CopyPayToVendorAddressFieldsFromPurchaseDocument(Vendor); Therefore, if the Vendor does not have an address, it tries to update it with what was put in the Purchase Invoice, even if nothing is there. It is important to note that this feature was removed in Dynamics NAV 2018.
Statical PrismStatical Prism is an easy-to-use productivity tool that offers benefits for just about anyone using Dynamics NAV. Dynamics NAV consultants, developers, QA consultants, supporters, and architects, download Statical Prism today.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.
- Login Error: Communication protocol mismatch between client and server
- Creating a Date Table in Power BI
- How to Make Measures Total Correctly in Power BI Tables
- The Microsoft Technology Stack – What It Is and Why You Should Care
- The Top Eight KPIs Retailers Should Be Tracking (with Formulas) for Your Retail KPI Dashboard