Business Intelligence and Reporting Track helps solve user challenges at NAVUG Forum.

Jason Chance, Senior Programmer/Analyst at Seventh Generation and Business Intelligence and Reporting Track Leader for NAVUG Forum, guest blogs today on what the BI and Reporting Track has to offer end users at NAVUG Forum, the annual NAV end-user conference held in Seattle, October 15-18 2012.

Without fail, whenever I lead a NAV roundtable discussion or training class, people talk about the reporting. I’ve only met a handful of people who are completely happy with their business reporting and most of them have spent significant resources developing reporting solutions outside of NAV. But before you throw in the towel on reporting in NAV, and spend a lot of time and money, you owe it yourself and your organization to understand what’s available in NAV. This is where NAVUG Forum 2012 comes in.

NAVUG Forum is an excellent event led by NAV users and professionals. It’s not a sales pitch. It’s not a glossy brochure full of fluff. It’s real NAV users sharing their experience and insight gained through years working with NAV. In the reporting and BI track we’ll focus how you can get the most out of the existing tools in NAV. With sessions like Reporting 101 and Reporting 102, you’ll learn how to create and modify NAV reports. Sessions on the Role Tailored Client will show you how to use the RTC to customize the data that you see in NAV. The Analysis Views and Jet Reports session will highlight two often under utilized reporting tools in NAV. The NAV 2013 sessions will give you a preview of what to expect in the newest version of NAV.

If you have issues and concerns with your reporting capabilities, chances are someone else has the same concerns, who knows, maybe they’ve already solved their problems. Come to NAVUG Forum, learn from your peers, build a network of colleagues that can help you get the most out of NAV.

See you in Seattle.

Microsoft’s concept of how 2019 will look like

Microsoft Dynamics NAV users have already gotten the chance to see Jesper Lachance Raebild’s video demo using Microsoft Kinect in a NAV manufacturing environment.  If you missed it, find the link to the video here.

What else does Microsoft have in store for us?  Take a five minute break to see what 2019 could look like.

10 easy tips for payment terms success in Microsoft Dynamics NAV

1.  Know that the Document Date is what controls the calculation of payment terms. This is true for both vendor invoices as well as customer invoices.

2.  The vendor and customer areas share the same Payment Terms setup. Make sure the folks who maintain these tables know they’ll need to share the codes that are set up here.

3.  Basic terms use very basic setup. Payment terms of Net 30 simply require a Due Date Calculation of 30D in order to work.

4.  Immediate payment terms can be accomplished in two ways. The first way is to leave the payment terms field blank on the vendor or customer card. When this occurs, NAV makes the assumption that the payment terms are immediate. The second way is to populate the Due Date Calculation with 0D. By putting in zero days, you can still define a payment term and name it as immediate. I don’t like to see blank fields in any of my data, so I recommend using this method.

5.  Discounted terms follow a specific combination in the payment terms table. For discounted terms like 1/10 Net 30 (one percent discount if paid in ten days, otherwise due at thirty days), use this setup.

6. You may have some things you always pay on the first of the month, like rents. How do you get invoices to show up on your payables aging on the first day of the month regardless of whether the month has 31, 30, or 28 days? In the due date calculation, use this simple formula:  CM+1D.

7.  If you send checks, and you need for that first of the month payment to get in the mail in time to be received on the first, get a little fancier with the formula and use CM-3D. This will calculate the due date as the third to last day of the month, no matter how many days are in the month.

8.  If you need to date something as always due the last day of the month, set up the Due Date Calculation as D31. This will always calculate the due date on the last day of the month, regardless of how many days the month has.

9.  When running the suggest vendor payment process for payables, the last payment date corresponds to the due dates calculated by the payment terms. The date you put in this field will suggest payments to be made with due dates up to and including the date listed.

10.  If any invoice gets posted with incorrect payment terms and you need to correct the due date in order for it to show up properly on your aging, you can go in and correct the due date on the already posted invoice. This can be done from the end-user level and does not require use of the object designer.  Drill down to the correct invoice record from the Balance ($) field found on the general tab of the vendor card.  Use a triple-click with your mouse on the due date field to change the date quickly and easily. The same steps can be accomplished from the customer card.

This posting is one of the Top 20 Most Viewed in the last year! Follow this link to see the entire list.

NAVUG FORUM 2012 Overview and IT Track – Keyword: WOW!

Lewis Rosenberg, Information Technology Manager at Mars Fishcare, Information Technology Track Leader, and Programming Committee Chairperson for NAVUG Forum, guest blogs today on what the IT Track has to offer end users at NAVUG Forum, the annual NAV end-user conference held in Seattle, October 15-18 2012.

All I can say after reviewing the list of offerings for this years’ NAVUG Forum in Seattle is WOW! If you have never attended a NAVUG Forum before, this is a “must-attend, must-participate,  WOW!” event! There will be so much quality information available from so many quality Dynamics NAV professionals. This is the best opportunity to link up with, meet, and network with so many people that do what you do every day using Dynamics NAV.

The conference begins with an optional day or half-day of training. There are ten different classes to choose from for a small additional fee. The classes being offered span a wide range of subject areas including finance, manufacturing, information technology, and reporting.

The remainder of the event spans three days and offers more than 100 sessions organized by eight subject tracks:  BI-Reporting, Finance, Global, IT-Developers, Manufacturing-Supply Chain, NAV 2013, Strategic, Potpourri.  You can attend sessions in multiple tracks to get the most out of the conference.

One of the most exciting things about the sessions offered is that they are all led by Dynamics NAV users and professionals like you. All of the sessions encourage participation, sharing of knowledge and solutions. The power of networking is what NAVUG Forum is all about!

This year’s Information Technology track features thirteen sessions covering topics like Cloud Computing,  Database Optimization, SharePoint, Web Services, NAV 2013, the Role Tailored Client, and Dynamics NAV Security, Permissions, & Roles.

NAVUG Forum 2012 is at the Grand Hyatt in Seattle Washington from October 16 – October 18.  All the information you need is available at Connect, Learn, Share! WOW!

Lewis I. Rosenberg
Information Technology Manager, Mars Fishcare
Programming Committee Chairperson, NAVUG