What happens when I turn “Expected Cost Posting to G/L” on or off?

Last week, I received an e-mail from one of our clients asking about the repercussions of turning off “Expected Cost Posting to G/L” in the Inventory Setup.

Inventory Setup

By default, this option is turned off / disabled. In the case of this particular client, they had turned it on in the past and wanted to know the impact of turning it off now.

When we are working with Purchase Orders in NAV, we may receive goods into inventory first and subsequently receive an invoice from the vendor. Sometimes, this may transcend months (receive goods in late March, invoice sent in April), and to give us proper visibility, NAV gives us the option to record the expected costs.

As my colleague Nick Prevett put it, “CFOs do not like surprises, so getting a delayed purchase invoice that was not expected usually creates problems.” Enabling Expected Cost Posting to G/L “makes for more accurate and timely accounting, and you do not have to build the accrual for those purchase invoices that you have not received yet and the expected/interim accounts are a good indicator of what purchase invoices are still outstanding.

Essentially, nothing will break if this option is disabled. To better understand, here’s what happens in each case (enabled, and disabled):

With Expected Cost Posting to G/L ‘enabled’:

When we use the “Post > Receive” action on a Purchase Order, NAV posts entries to the expected/interim accounts in the General Ledger based on the $ amounts that we have entered on the Purchase Order lines.

Later, when the invoice arrives, we use the “Post > Invoice” action on the same Purchase Order, and NAV reverses the expected entries in the G/L, and books the final entries to the appropriate G/L accounts. If the amounts in the Purchase Line have been changed / updated because the vendor has charged more or less than originally anticipated, the final entries posted to the G/L use these amounts.

With Expected Cost Posting to G/L ‘disabled’:

No entries are posted to the expected/interim accounts in the General Ledger when goods are received. NAV only posts entries to the General Ledger when we get the invoice from the vendor and use the “Post > Invoice” action on the Purchase Order.

Note: If we use Expected Cost Posting, we must have the appropriate requisite G/L accounts selected in the Posting Setups in NAV.

Issues connecting new Project “Madeira” Users to Power BI?

Homepage_metal_large_2If you’ve just added a new O365 user to Project Madeira and the new user is having trouble getting PowerBI.com working with the content pack, just try again the next day or so. It looks like the NAV User name and/or Web Service Access Key need some time to propagate.

I’ve had this happen with a couple users now, and at first I thought I was doing something wrong, only to find it working when I tried again with the same user credentials a day or two later.

You can find detailed instructions on connecting Project Madeira to Power BI on our blog post here.

Zetadocs Express and the 64-bit NAV 2016 Windows Client

If you are deploying Equisys Zetadocs Express with NAV 2016, you may find that the drag and drop functionality does not work in the Windows Client like it does in prior versions of NAV, and pages with the Zetadocs Documents FactBox load up slower.

ZDX01With assistance from the Equisys support team, we found that this issue is related to the 64-bit version of the NAV 2016 Windows Client. This is also discussed briefly in section 3.1 of the Zetadocs Express installation guide (v7.1), but the consequences are not clearly outlined.

With most new workstations being 64-bit machines, we suspect this issue will come up for more than a few users. When NAV 2016 is installed on a machine running 64-bit Windows OS, the default Windows Client shortcut placed in the Start Menu points to the 64-bit version of the client (default path: C:\Program Files (x86)\Microsoft Dynamics NAV\90\RoleTailored Client\Microsoft.Dynamics.NAV.Client.exe)

Continue reading “Zetadocs Express and the 64-bit NAV 2016 Windows Client”

Visual Studio Not Displaying NAV Report Layout Properly

We found this issue when using Visual Studio 2015 Community Edition with NAV 2016*, but it’s possible that you may encounter this with other editions and versions of Visual Studio as well.

Issue: When designing a Report object from the NAV Development Client and viewing the Layout in Visual Studio, Report.rdlc is rendered as an XML file instead of a “visual” layout with fields, controls and boxes.


Continue reading “Visual Studio Not Displaying NAV Report Layout Properly”

Simplify Expense Reporting and Derive The Most Out Of Dynamics NAV

As much as expense reports are despised, they are a necessary element of today’s increasingly mobile workforce. Surprisingly, even in the paperless 21st century, most companies process paper expense reports and expect employees to mail-in the receipts. This manual approach is frustrating, time consuming and wasteful!

Expense ManagementWith T&E spend hovering between 7% to 15% of the total budget for the average mid-market company ($50MM to $800MM in revenue); the challenges facing CFOs in this area are immense, with millions of dollars at stake! For most companies, travel related expenses remain a significant area of spend – second only to payroll. That’s how huge T&E spend is.

Join us on the webinar to learn more and see a live demo of the solution.

The Problem is Known. But Where to Start?

Most companies know that a manual paper based expense reporting process is painful to manage for the company and inefficient. Yet they struggle to tack action. This is because of not knowing where to start.

Aberdeen Research Group’s report (‘Expense Management for a New Decade and The Mid-Market Expense Management Program’) says that:

  • Only 33% leverage cloud-based expense reporting solutions
  • 56% of mid-market companies have limited visibility into T&E spending
  • Just 15% provide T&E data to C-level executives for financial forecasting purposes
  • Only 28% utilize corporate credit cards and integrate the data in T&E systems

Continue reading “Simplify Expense Reporting and Derive The Most Out Of Dynamics NAV”