Last week's blog on Creating Advanced Charts in Dynamics NAV dealt with two-dimensional charts, but you can also add a third dimension. Select one Amount and one Dimension from the lower right as before. Then select another Dimension from the lower left-hand corner.Here we have a chart that shows Sales Order Amount by Salesperson and State:If you left click on the chart, you can move the chart's angle to change the view to your liking.If you want to print this chart or save it to imbed in a document, right click on the chart and the Print and Save Picture As options will appear. To save the chart in Dynamics NAV, select Customize.This brings you to the Generic Chart Customization where you can add an Axis Title and … [Read more...] about Add a Three-Dimensional Chart in NAV
Create Advanced Charts in Dynamics NAV
Microsoft Dynamics NAV has many pages with list views: Customers, Items, Vendors, Sales Orders and Purchase Orders, to name a few. However, it can be useful to have a quick visualization of some important business metrics without having to filter the list data. Today, you’ll see how to successfully change a list view to a chart view and how to customize a chart.For our example, we’ll deal with Sales Orders, which are seen in the list view below. First, click on Show as Chart in the ribbon to replace the list view with the chart view.You’ll find that no chart is displayed, however, and this is where many users get discouraged. So what’s going on here? You first need to pick out the metrics you want to see in the chart. Start by … [Read more...] about Create Advanced Charts in Dynamics NAV
Set Up Account Balances in Dynamics NAV
Primary Goal: Establish the Bank Account's sub ledger detail in a manner which prepares for processing future bank reconciliations. To do this, you'll need to account for the following items:Ending Bank Balance Outstanding checks Outstanding deposits/other transactionsSuccess Criteria: At the end of the process we need the following:The Bank Account's Balance field value should match exactly with the Bank Account's G/L account balance (as found on the Chart of Accounts and associated via the Bank Account's Bank Acc. Posting Group field). We should have appropriate Open Bank Account Ledger Entries to use on future Bank Reconciliations.Bank Account - Beginning Balances:Presumption: In my demo scenario, I presume the GL … [Read more...] about Set Up Account Balances in Dynamics NAV
Microsoft unveils specifics of Dynamics 365
Microsoft Senior Director Angela Bandlow gives an interview on Dynamics 365, which is expected to release Nov. 1.Touted by Microsoft as the “next generation of intelligent business applications,” Dynamics 365 is set to release Nov. 1. The company’s latest offering combines features of enterprise resource planning (ERP) and customer relationship management (CRM) software into one cloud-based offering.What exactly does that mean?Microsoft has been notably quiet on specifics of its new product, giving the public teasers throughout the summer. The company finally released a “first look” of Dynamics 365 at Summit 2016 last week, offering live demos for those in attendance.Some details are still a mystery and will be until partners get to … [Read more...] about Microsoft unveils specifics of Dynamics 365
Quick Start Tips: Windows PowerShell ISE
I wish I had access to some quick start tips when I first started learning how to use Windows PowerShell ISE to administer Microsoft Dynamics NAV. With that in mind, this blog offers some quick tips to get you started.From here on out, I'm going to refer to Windows PowerShell ISE simply as PowerShell. This isn't exactly accurate since there is a separate console tool that's called PowerShell. To keep it simple, just know that when I say PowerShell, I am referring to Windows PowerShell ISE. Suggested Screen Layout for Windows PowerShell ISE These two screen shots show how I like to set up my PowerShell screen: Script Pane on the top Console on the bottom Command Add-on shown on the rightThis layout allows me to write … [Read more...] about Quick Start Tips: Windows PowerShell ISE
Create New Records in NAV RapidStart Part 2
Hello and welcome back to our series of blogs on RapidStart in Microsoft Dynamics NAV.Today we are going to review steps 6-8 as they apply to new records. We will import our Excel file into NAV, validate it, resolve any errors and then apply the file.Let’s start with importing the file we created in the previous blog:Choose your file.You will see that in the configuration package under No. of Package Records the total is now “3” for the three tire records we created in our last blog post.Next, click on “Validate Package.”In our example we ended up with nine validation errors (see below) on our first validation attempt.Move your mouse on top of the number. Once it underlines, click on it and the following message box … [Read more...] about Create New Records in NAV RapidStart Part 2
Create New Records in NAV RapidStart
Hello and welcome back to our series of blogs on RapidStart in Microsoft Dynamics NAV. For this week’s blog, we’re going to take a short detour to add new items to the Item Card.Adding new records is similar to performing a mass update on existing records. You will follow the same eight steps as before. However, the trick to adding new records is to find an existing record that is very similar to what you want to add. For example, is the item purchased or manufactured? Will the existing and new records share the same posting groups? And so on. You then use the existing record as a template for the new records.To add some new items for our example, let’s use the Cronus database and for the bike, let’s say we want to add in a few new … [Read more...] about Create New Records in NAV RapidStart
Mass Updates in NAV RapidStart Step 6
Hello and welcome back to our blog series on how to use RapidStart Services in Microsoft Dynamics NAV. In this post we are going to work on importing the Excel file into NAV (step 6 of the 10-step process).At this point, please make sure the file you were working on in step 5 is saved. Our work in Excel is complete and we will be working in NAV from this point forward, unless there are data errors to fix in the Excel file. Step 6 Before we go further, I’d like to explain one concept in a little more detail. When we import the Excel file into NAV, at the time of import we are copying the data from Excel into NAV’s configuration package. We are not moving the data directly into the tables yet. When we get to the step to apply the data, … [Read more...] about Mass Updates in NAV RapidStart Step 6
Mass Updates in NAV RapidStart: Steps 1 & 2
Welcome to Part 2 in a series of blogs on how to make mass changes and additions to data in Dynamics NAV. If you missed Part 1, you can read it here.In this blog we will look at the first two of 10 steps in making a mass change or addition to data in NAV, specifically:Identify what you want to change or add to NAV, including which fields and tables are involved. a.) For changes to existing records, create a mapping table to identify under what circumstances certain records will get updated. b.) For new records, identify all the fields that need to be set up to add in the new data. Go into RapidStart and create your configuration package and download the tables and fields identified. Export this to Excel.Let’s get started! Step … [Read more...] about Mass Updates in NAV RapidStart: Steps 1 & 2
Use NAV RapidStart to Make Mass Updates
“There has to be a better way to do this,” you say, frustrated with the tediousness of manually entering the same data again and again. It would be much more convenient to make a large number of changes to multiple records in a more automatic way. Fortunately, Microsoft Dynamics NAV has such a mass update and mass add tool in one place called RapidStart Services.This is the first in a series of blog posts to help you get started with RapidStart in NAV. With RapidStart, you can add several new records at once or update existing records quickly. However, because of data dependencies, you cannot mass archive/delete records.Before we go further, remember that the first rule with mass updating of data is “do no harm.” RapidStart is a very … [Read more...] about Use NAV RapidStart to Make Mass Updates
