917.848.7284 Data for Finance and Accounting

Financial Reporting and Accounting Blog

Converting 1099 Balances in Dynamics NAV

Adam Jacobson January 19,2017

I’m in the process of finishing up a data conversion from Lawson to Dynamics NAV 2016. The last piece to figure out are 1099 balances from checks issued before we converted. (We only converted open AP Items, so we don’t have the history necessary to calculate 1099s at year end.)

I’ve looked around the web and found a variety of incorrect and partial answers. Many solutions have a lot of discussion about invoices and credits. But I think I’ve found a much simpler way of doing this.

Read More

Tags: Dynamics NAV

See All Dimensions for NAV General Ledger Entries

Adam Jacobson January 17,2017

Dimensions are a wonderful feature of NAV. However, when doing General Ledger analysis, sometimes clients just want to dump everything into Excel and “play” with it—especially if they use Analysis Views.

And to do this, clients want to see all dimensions, at the detail level, for each transaction.

But here’s the challenge: You can only view or filter two dimensions directly on the General Ledger entries page.

Fortunately, there’s a way around this restriction.

Read More

Tags: Dynamics NAV

Free SSRS Reports for Dynamics NAV

Adam Jacobson December 29,2016

Since most of my clients have switched to Dynamics NAV (many of them from Lawson), I’ve been busy writing a bunch of SSRS reports that facilitate specific finance and accounting functions my clients require.

Here are the reports I’ve completed thus far:

Read More

Tags: Dynamics NAV

How to Deal With NSF Checks in NAV (Without Using Reverse Transaction)

Adam Jacobson December 22,2016

I was at the NAVUG user group in NYC last week. There, I learned that NAV2017 now allows users to cancel posted sales invoices and sales credit memos. While I’m sure some users will welcome these changes (and I’ve yet to see exactly how they’ll work), my first impression is that this isn’t such a great idea.

Part of my reasoning is that, honestly, I believe that people who “pay for their mistakes” are more likely to stop making them.

But I also hesitate because I don’t like reversing transactions in NAV more generally.

Read More

Tags: Dynamics NAV

Lawson and Dynamics NAV

Adam Jacobson December 20,2016

Since 1995, I’ve worked extensively with Lawson software. Until this month, that is, as my last Lawson client is moving into Dynamics NAV.

I’ve learned a lot about NAV over the last few years. And while I do miss Lawson at times, Lawson’s time has passed for my core clients (who aren’t in health care or government).

Read More

Tags: Dynamics NAV

AR Revaluation Report – Dynamics NAV

Adam Jacobson December 8,2016

In my last series of posts, I wrote about NAV currency setup, entering foreign currency sales invoices and how adjust currency amounts can be run at period end to create gain loss entries.

In that last post, I promised to show you a sample report that would allow you to see the gain loss before you actually post it.

And here it is.

Read More

Tags: Dynamics NAV

Using Totaling Accounts with SQL in Dynamics NAV

Adam Jacobson December 6,2016

If you’re like many of my clients, you didn’t clean up your chart of accounts when you installed your new ERP. Or maybe you did but then your business changed. So, instead of having a nice set of account ranges, like those in the sample Cronus companies, you need to create odd groupings of accounts.

Totaling Accounts are your first option in NAV. And they work well. However, if you want to use them to write reports using SSRS or another SQL tool, they aren’t that easy to work with. But I’ve built some code to make it a bit easier.

Read More

Tags: Dynamics NAV

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