With Simulation functionality in Microsoft Dynamics NAV, you can capture and report non-financial data seamlessly.

Organisations with the requirement to maintain records of statistical or non-financial data can do so in Microsoft Dynamics NAV (NAV) instead of maintaining it separately outside NAV.

Keeping both financial and non-financial data in NAV allows you to see a complete picture of the business performance in a single view. It’s quick and easy to configure Simulation functionality in NAV, so you’ll be up and running before you know it.

It can be done by following the steps below:

Step 1 – Setup Chart of Accounts for non-financial data recording

Create new G/L Accounts outside the range of financial Chart of Accounts. This method will separate the financial Chart of Accounts from non-financial Chart of Accounts for easy management, recording and reporting.

Microsoft Dynamics NAV Capturing data image1

Step 2 – Create a new Source Code

Tick ‘Simulation’ field to activate the Simulation functionality associated with the Source Code.

Microsoft Dynamics NAV Capturing data image2

Step 3

Create a new General Journal Template to facilitate Simulation or non-financial transaction entry. Ensure that the new Source Code created in Step 2 is filled on the Source Code field of the new General Journal Template.

Microsoft Dynamics NAV Capturing data image3

Step 4 

Use the newly created “NFData” General Journal Template to create the journal lines. Then post it to record the non-financial transaction.

Please note that simulation entries can only be posted against the G/L Accounts.

Microsoft Dynamics NAV Capturing data image4

Microsoft Dynamics NAV Capturing data image5

General Ledger Entries will be created with Entry Type “Simulation” and with Entry No. in negative. These tags differentiate the entries from financial entries which are tagged with Entry Type “Definite” and with Entry No. in positive.

Another notable difference is that Simulation transaction will create Simulation Register instead of G/L Register that is created on posting of financial transactions.

Step 5

To report against financial and non-financial data, the “Entry Type” filter needs to be used on the report.

Microsoft Dynamics NAV Capturing data image6