917.848.7284 Data for Finance and Accounting

Financial Reporting and Accounting Blog

Understanding NAV Currency, Part 4: Receiving Cash Against a Foreign Currency Receivable

Adam Jacobson November 17,2016

In my previous post, I showed how to perform a month end revaluation in Dynamics NAV with an unpaid invoice. In this post, I’ll show you how to receive cash against a foreign currency receivable.

To recap: We have an open invoice that was worth 15000 MXP when we invoiced and 17250 MXP when we closed the month. The peso continued to fall, and it’s now worth 20000 when we receive the cash on November 20th.

Read More

Tags: Dynamics NAV

Understanding NAV Currency, Part 3: Month End Revaluation

Adam Jacobson November 15,2016

In my last post, I entered a sales invoice in NAV in a foreign currency. The invoice was posted on 10/5 and had a value of 1150 USD or 11,500 MXN (or MXP as Cronus has it, which still irks me).

Now, it’s month end. As the invoice isn’t paid, we need to perform a revaluation (as it’s known in standard accounting parlance). The NAV system uses the terminology “adjust exchange rate.” (For more on revaluation, see my posts on exchange and revaluation and revaluation and translation.)

Read More

Tags: Dynamics NAV

Understanding NAV Currency, Part 2: Entering a Foreign Currency Sales Invoice

Adam Jacobson November 10,2016

In our previous post on understanding NAV currency, we covered the topic of NAV currency setup, including general ledger, currency and exchange rates.

In this post, we’ll continue the discussion by entering a foreign currency sales invoice in NAV.

As with our previous post, we’ll use Cronus Mexico for our examples.

But before we start, let’s set up our currencies and exchange rates to make our examples super obvious.

Read More

Tags: Dynamics NAV

Understanding NAV Currency, Part 1: Setup

Adam Jacobson November 8,2016

I’ve done a lot of work with currency accounting from a systems perspective. Now that I’m working in NAV, I thought it would be useful to explain how NAV works with foreign currency amounts in a series of posts.

In this series, I’ll cover the following topics:

  1. General Ledger Setup
  2. Currency Setup
  3. Exchange Rate Setup
  4. Entering a Foreign Currency Sales Invoice
  5. Revaluation (i.e. revaluing the open amount at period end)
  6. Receiving Cash Against a Foreign Currency Receivable.

In this post, I’ll cover the first three topics: how to set up the general ledger, currency and exchange rates.

Read More

Tags: Dynamics NAV

Month End Closing in Dynamics NAV

Adam Jacobson September 26,2016

If you know anything about NAV, you know it doesn’t really have a hard month end close. So, apologies for the somewhat misleading title of this post.

However, month end close remains a topic for discussion for folks switching to Dynamics NAV from other systems (like Lawson) that have a more traditional, hard period end.

Read More

Tags: Dynamics NAV

Jet Reports vs SSRS for Dynamics NAV

Adam Jacobson September 14,2016

For the past few months, I’ve been spending a lot of time creating reports with both Jet Reports and SSRS, mostly with Dynamics NAV and a little with Dynamics GP. If you’re a NAV customer, you have some version of Jet included with your purchase. Like all folks with SQL server databases, Dynamics folks use SQL Server and therefore have access to SSRS.

So which is better? Or rather, what works best in any given situation?

Read More

Tags: Dynamics NAV Jet Reports

Dynamics NAV Dimensions: Part 3—Dimension Combinations

Adam Jacobson September 9,2016

In my last post, I went into some detail about default dimensions in NAV and options for value posting. I also showed how the system reports posting errors when values don’t match the choices made in default dimensions.

Fortunately, you can work around this by controlling how your dimensions post, using dimension combinations.

I’m going to give you an error example first and then explain why it happened (and how you might be able to fix it). As in my precious posts, I’ll use the standard Cronus USA database for my examples.

Read More

Tags: NAV Dimensions Default Dimensions Dynamics NAV

Dynamics NAV Dimensions: Part 2—Moving Between Systems

Adam Jacobson September 6,2016

In my last post, I went over NAV dimensions setup, using sales invoices for my examples. I also mentioned how dimensions can be assigned to many, many different kinds of data in NAV.

In this post, I’ll go over how dimension values work with different setups. Again, all my examples use the CRONUS USA sample company.

Read More

Tags: NAV Dimensions Default Dimensions Dynamics NAV Dimension Combinations

Dynamics NAV Dimensions: Part 1—Setup

Adam Jacobson August 23,2016

Dimensions in Dynamics NAV are powerful tools. They’re also a little confusing to use. Which isn’t a good combination. With great power comes great responsibility.

In a series of posts, I’ll dive into the topic of NAV dimensions to help you navigate their choppy waters.

In today’s post I’ll show you how to set up NAV dimensions.

Read More

Tags: Dynamics NAV

RapidStart – A Query to Check Your Errors

Adam Jacobson July 28,2016

RapidStart Services is a useful tool to load data into Microsoft Dynamics NAV. You can use it not only for initial setup but also for mass updates. (Theoretically, you can also use it for regular interfaces, but I think there are better options.)

But as much as RapidStart is useful, it does have one major flaw: it has no comprehensive error report.

To solve this problem, I’ve developed a query for it. (If you want a copy, scroll down to the bottom of this post.) 

In this post, I’ll walk through RapidStart’s error process, and then show you the query.

Read More

Tags: Dynamics NAV