Microsoft Dynamics NAV: Finance Year End Processing

eDM Financial Year End Processing

Module 1: Adjust Currency

This module is to explain how to process adjust exchange rate.

Lessons:

1. Processing of adjust Exchange Rates

Lab:

1. Update Exchange Rate
2. Adjust Exchange Rates

Module 2: financial report

This module is to explain reports that user can use to verify the accuracy of the accounts before closing the books at the end of a year or period

Lessons:

1. Generate and preview Financial reports
   1. Trial Balance
   2. Income Statement
   3. Balance Sheet
   4. Journal Listing
   5. Sales Apply Entry
   6. Purchase Apply Entry
   7. Aged Receivable
   8. Aged Payables
   9. Inventory Valuation
   10. FA Book Value 01

Lab:

– NA

Module 3: Year end closing procedures

This module is to explain the closing procedures.

Lessons:

1. Closing a Fiscal Year
2. Processing of Close Income Statement

Lab:

1. Close a Fiscal Year
2. Close Income Statement

Module 4: Accounting Period

This module is to explain the accounting period.

Lessons:

1. Create new accounting period

Lab:

1. Create new Fiscal Year

After completing this module, students will be able to:

1. Describe how to run the Adjust Exchange Rate batch job for customers, vendors and bank accounts.
2. Describe how to run the Adjust Exchange Rates batch job for G/L accounts.
3. Describe how to view the Exchange Rate Adjustment Register
4. Generate financial reports from system.
5. Close the accounting periods for the fiscal year.
6. Explain and run the Close Income Statement batch job process.
7. Complete the closing process by posting the general journal.
8. Create a new fiscal year.

pre-requisition:

1. Basic NAV Financial Module Knowledge
2. Bring own Notebook
3. Accounting Knowledge

Register Here :

Adjust Inventory from Item Card in Microsoft Dynamics NAV 2017

User is allowed to adjust inventory from Item Card itself in NAV 2017 instead of manual post adjustment through Item Journal.

However, this function is not workable when item

Network Security – things to consider

1.       Is Microsoft Navision Secure enough to work without VPN?

2.      What is best practice? How companies that use Navision practice.

3.

If you don’t have an Azure subscription, create a free account that lets you access any Azure service.

Create a Recovery Services vault

To create a Recovery Services vault

• If you haven’t already done so, sign in

Microsoft Dynamics NAV with SQL DB

Excel Reporting and Jet Report 

Excel reporting on Dynamics NAV

This module explains how to create basic NAV reports using Excel to connect to Dynamics NAV.

Lessons:

1. Plan the dashboard
2. Create the dashboard
   – Create and save a SQL data connection
   – Create a report
   – Create a filter
   – Create a slicer
   – Create a Timeline
3. Configure Excel Add-In
4. Practice
5. Useful links

Lab:

1. Create and save a SQL data connection
2. Create a report
3. Create a filter
4. Create a slicer
5. Create a Timeline
6. Configure Excel Add-in
7. Create report to display outstanding amount by customers

After completing this module, students will be able to:

1. Able to create basic dashboard by using Excel and SQL Data source.
2. Able to create basic dashboard that contains several reports and a filter using external data connections.

PRE-REQUISITE:

1. Excel 2013 (and above) installed on Laptop/Notebook
2. Dynamics NAV with SQL DB
3. Bring your own Laptop/Notebook

JET REPORT

Excel Reporting and Jet Report 

Jet report

Module 1: jet professional introduction and report design

This module explains introduction of Jet Professional and processes related to report design using Jet functions.

Lessons:

1. Introduction of Jet Professional
2. Creating a report listing
3. Creating a report option
4. Creating a report from multiple tables
5. Grouping and Sorting
6. Connecting to multiple databases and companies
7. Jet Browser

Lab:

1. Design a report list in Jet
2. Design a report option
3. Design a report from multiple tables
4. Include grouping and sorting in report
5. Connect to multiple data sources

After completing this module, students will be able to:

1. Understand how to design a report in Jet Professional

Register Here :

Yes or No to Call Scripting

Call scripting is one of the “hot topics”, primarily because there are so many opinions on the subject. There are many in favour of call scripting, while many remain against it.

A script