Introduction   to MS Dynamics NAV 2018
Jaromír Skorkovský
9.12.2020 ESF-KPH-MU
           Basics of  Budget
      Related to muc more simple example in word

Basic principles
Purchase Order
Account 8320
(consultant services)
F9
Account 8320
(consultant services)
07.11.14
General Ledger Item Entries (Debit amounts)
1500
07.12.2014
100
1002
8320
9510
Budget for chosen Year
(Business Plan)
D1
D2
D3
D 4
2000
1500
Difference = 500
Direct posting field
must be ticked
Difference = 1400
Dimensions

Budget example
In our word example we use G/L account 8320
In our model we use accout
6710

Important statement for this budget model
* Author incorrectly used in PO lines account 6710, which supposed to be account used for revenue.
So the  correct account have to be account 8320.
* Used account 6710 have to be used in sales lines
* Anyhow as a matter of principle  the main concept of using Budget and Accounting schedule
functionality is fully preserved
4

PO lines generation of G/L Entries
5
Dimension = SALES
28.1.16,Cost=1200
Dimension = ADM
28.1.16, Cost=600
Change of Working date  to 30.1.2016
From Icon Line,
Dimensions
Dimension = ADM
30.1.16, Cost=1800
Dimension = SALES
30.1.16,Cost=2400

General Ledger Entries (filtered for just created ones)
6
See next slide

General Ledger Entries
7


Setup data in Budget matrix
8
We have to go back in time

Budget  Matrix
9
Setup of expected (budgeted) values
for chosen dimension

Manual setup of budget values
10


Budget
11


Budget automated calculation
12


Creation of new  Accounting Schedule view
13
Use recently created Accounting Schedule TEST (see Intro PWP XIV)
It is necessary to update Analysis view in order to use data
created by this method in period which is not so far included
6710

Accounting  Schedule
14
Add  Default column  from predefined set of columns templates

Edit Accounting Schedule
15
Add  new  G/L account 6710

Overview of Accounting Schedule with use of filters (ADM and SALES)
16
Net change =600 (1st PO line) + 1800 (2nd PO line) = 2400 and budget is for
4800, so G/L entries satisfy budgeted value   by 50 % .

Navertica.png
THANKS FOR YOUR ATTENTION AND  TIME


•Standard colour palette
Backgrounds Primary Text        Secondary Text      Expanded Palette
Accent Accent Gradients
Gradient Upper Levels
18

•Sample chart
Sample chart
Lorem ipsum dolor sit amet
Sample chart description
19