ArcherPoint Dynamics NAV Developer Digest - vol 195
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.
Create a Dynamics 365 Business Central Sandbox
If you haven’t started playing around in your own D365 BC sandbox, check out this post from last year to get your sandbox setup, learn how the wizard works, see advanced functionality, the works! Go learn and feel free to make mistakes.
Business Central Developer and IT Professionals Help
If you haven’t bookmarked this page from Microsoft, Business Central Developer and IT Pro help, you probably should. It contains information about deployment and administration, and developing for Dynamics 365 Business Central using the AL language extension and Visual Studio Code. On the left menu, you will see navigation to Development in AL, AL Development Environment, Rules and Guidelines for AL Code, and access to the D365 BC API preview. It also contains links to C/SIDE documentation if you need it.
Matt T. states, “So I know you can do something like this:
and it will launch the lookup page for whatever table the record reference points too. Does anyone know of a way to determine what record was selected? I know how to do it if you hard code the page as a variable. You can use the GETRECORD function in that case. But I don’t have that here.”
Kyle replies, “Once the RUNMODAL is done, wouldn’t the RecRef be changed to whatever the user selected in the Page? Why are you trying to do this generically instead of building in a specific Lookup ACTION so you can tell the difference between a lookup/OK and a cancel?”
Matt explains, “It needs to be able to lookup any record from any table dynamically. I don’t know what table the user will choose, so I can’t pre-load a bunch of variables that point to pages. Not a hard requirement for anything I’m doing, just a nice to have.
I think I can get around it using the newer FILTERPAGE variable type where you essentially create a page dynamically from code. It doesn’t show you the data, but it does show fields that you can do lookups on. I could populate that page dynamically with all of the fields from the primary key and let the user choose that way. Not as pretty, though.”
Customs NAFTA Reports
KC wants to know, “Has anyone done any work with NAFTA Customs Reports? A client would like to replace manually creating custom reports for transporting items to Canada by automating the report. They would prefer to have a pdf file of the customs report. I am hoping that maybe someone has a customs report already created.”
Todd replies, “KC, the only NAFTA reports I have worked with are through Lanham’s E-Ship.”
Tammy F. suggests, “search nafta* in our ticketing and you’ll get a long list of cases related to NAFTA and the resources that worked on them. If you need any help let me know.”
Trish adds, “Lanham E-Ship includes the NAFTA Certificate in several different formats. I believe they work with the Export document.”
Still on Dynamics NAV 2009 R2?
Kyle declares, “No matter how bad your day was today, I bet it wasn’t “chase 2009R2 SPN problems for hours” bad. Team, keep up the good work selling upgrades. *please*.”
Saurav agrees, “Wow that was an old and bad one for me too and yes UPSI will keep on upgrading…we will upgrade them to latest and greatest NAV / Business Central version.”
Brian chimes in, “Amen brother, I feel your pain.”
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.