Analytics & Reporting

BC/NAV

BIR54 - SQL and NAV: From Foes to Friends

BCUG/NAVUG Presenter(s)

• 

  Adam Jacobson

  President
  Red Three Consulting

Of course, the salesperson said that you could get everything you needed out of Jet Reports. But now you're live and people are confused. You have SQL skills, but NAV's way of working is less than perfectly obvious. In this session, we'll go over the basics of the NAV database and how you can learn more when you need to. We'll also show you some special complementary SQL (as in yours to keep) that will make your life easier as you work with Totaling Accounts, Dimensions and multiple companies.

Learning Objectives:

• Identify the key tables behind any NAV Page
• Create reusable SQL that can be applied to any number of companies
• Understand how to solve complex SQL challenges including converting NAV totaling strings to SQL