Download - MS Dynamics – nothing simpler
![Page 1: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/1.jpg)
MS Dynamics – nothing simpler
Jaromír Skorkovský Training Manager
Anytime
![Page 2: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/2.jpg)
2
Agenda – concise screening of MS Dynamics NAV
MS Dynamics – nothing simpler
Short Live introduction–sales-replenishment-purchase-general ledger(International world wide demo database -WW)
PWP Nothing simpler – form sequences and basic logicLive system (WW database – Financial Management)
Chart of accounts – structure – entries->NavigationBudgetSetup – Posting Group ->main setup in order to ensure proper and simple booking in the background of NAV
Reporting – standard Accounting Schedules – reason, type of reports,… MS Dynamics Role Tailored Client live show - principles Discussion
![Page 3: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/3.jpg)
Customer|Vendor
Accounting in NAV in one perspective IMain principles of reporting
3
Customer|Vendor
Order
Item,Resource, Account,..
Business posting group code ,VAT,..
Business posting group code
Posting
Chart of accounts
G/L
Entr
ies
G/L E
ntrie
s
Repo
rting
Item,Resource, Account,..Item,Resource,
Account,..Item,Resource, Account,..
Item ledger Entries
Stock value
![Page 4: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/4.jpg)
Accounting in NAV main tool = General Journals
4
Chart of accounts
G/L E
ntrie
s
G/L E
ntrie
sRepo
rting
Cash account Bank account
Repo
rting
![Page 5: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/5.jpg)
MS Dynamics – nothing simpler
5
![Page 6: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/6.jpg)
MS Dynamics – nothing simpler
Working area
6
Info for presenter : Database open from
![Page 7: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/7.jpg)
MS Dynamics – nothing simpler
Working area
7
![Page 8: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/8.jpg)
MS Dynamics – nothing simpler
8
![Page 9: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/9.jpg)
MS Dynamics – nothing simpler
9
![Page 10: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/10.jpg)
MS Dynamics – nothing simpler
10
![Page 11: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/11.jpg)
MS Dynamics – nothing simpler
11
![Page 12: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/12.jpg)
MS Dynamics – nothing simpler
12
![Page 13: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/13.jpg)
MS Dynamics – nothing simpler
13
![Page 14: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/14.jpg)
MS Dynamics – nothing simpler
14
![Page 15: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/15.jpg)
MS Dynamics – nothing simpler
15
![Page 16: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/16.jpg)
MS Dynamics – nothing simpler
16
![Page 17: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/17.jpg)
MS Dynamics – nothing simpler
17
![Page 18: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/18.jpg)
MS Dynamics – nothing simpler
18
![Page 19: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/19.jpg)
MS Dynamics – nothing simpler
19
![Page 20: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/20.jpg)
MS Dynamics – nothing simpler
20
![Page 21: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/21.jpg)
MS Dynamics – nothing simpler
21
![Page 22: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/22.jpg)
MS Dynamics – nothing simpler
22
![Page 23: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/23.jpg)
MS Dynamics – nothing simpler
23
![Page 24: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/24.jpg)
24
![Page 25: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/25.jpg)
MS Dynamics NAV
Drill down function
25
![Page 26: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/26.jpg)
MS Dynamics NAV
Chart of Accounts
General Ledger Entries
Posted Sales Invoice
List of Items
Item Card
Item Ledger Entries
Production Order
Components (BOM)
Item Ledger Entries
Purchase Order
Vendor Card
Vendor Statistics
WHAT CAN BE ALSO SHOWNWHAT WAS PRESENTED SO FAR26
![Page 27: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/27.jpg)
Reporting (NAV tools or JETs)
Reporting
27
![Page 28: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/28.jpg)
Main principles (source tables and their entries)
Main principles of reporting
28
Customer
Vendor
Item
Account
Dimension
Control parameters(time, type of products,Costs, Revenue, Area,..)
![Page 29: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/29.jpg)
Some chosen analysis asked by CFO EUROM Czech Republic
Analysis
Working capital – setup of the accounting schedule from NAV
29
![Page 30: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/30.jpg)
Analysis
Working capital – Show of the results from NAV
30
Some chosen analysis asked by CFO EUROM Czech Republic
![Page 31: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/31.jpg)
Some chosen analysis asked by CFO EUROM Czech Republic
Working Capital JETs
Working capital – Show of the results from JETs
31
![Page 32: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/32.jpg)
Some chosen analysis asked by CFO EUROM Czech Republic
Inventory Dashboard
32
![Page 33: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/33.jpg)
Some chosen analysis examples (JETs)
Analysis examples
33
![Page 34: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/34.jpg)
Some chosen analysis examples (directly from NAV)
Cash Flow
34
Cash flow page 1
Cash flow page 2
![Page 35: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/35.jpg)
On line analysis example generated over database by JETS
Account receivables
35
Account Receivables with Details
![Page 36: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/36.jpg)
On line analysis example generated over database by directly from NAV
Account Payables
36
![Page 37: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/37.jpg)
37
Simple business case
MS Dynamics NAV Nothing simpler
Purchase order creationBooking (posting, registering to the system)Impacts in transactions (G/L, Logistic, payables)Some examples of MS Dynamics NAV financial reports
![Page 38: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/38.jpg)
MS Dynamics NAV
F3
38
![Page 39: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/39.jpg)
MS Dynamics NAV
39
![Page 40: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/40.jpg)
MS Dynamics NAV
40
![Page 41: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/41.jpg)
MS Dynamics NAV
41
![Page 42: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/42.jpg)
MS Dynamics NAV
42
![Page 43: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/43.jpg)
MS Dynamics NAV
43
![Page 44: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/44.jpg)
MS Dynamics NAV
44
![Page 45: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/45.jpg)
MS Dynamics NAV
45
![Page 46: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/46.jpg)
MS Dynamics NAV
46
![Page 47: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/47.jpg)
MS Dynamics NAV
47
![Page 48: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/48.jpg)
MS Dynamics NAV
Item card beforeposting Purchase Order PostingYou can see even calculatedfield showing, that Purchase Orderfor 20 pcs has been created
Item card after posting
48
![Page 49: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/49.jpg)
MS Dynamics NAV
Vendor card before posting
Vendor card after posting
129446,40-11409,40=15350
49
![Page 50: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/50.jpg)
MS Dynamics NAV
50
![Page 51: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/51.jpg)
MS Dynamics NAV
51
![Page 52: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/52.jpg)
MS Dynamics NAV
52
![Page 53: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/53.jpg)
53
Customer –Summary Aging
Chosen financial MS Dynamics NAV reports I
![Page 54: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/54.jpg)
54
Customer –Detailed Aging
Chosen financial MS Dynamics NAV reports II
![Page 55: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/55.jpg)
55
Customer –Detailed Trial Balance
Chosen financial MS Dynamics NAV reports III
![Page 56: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/56.jpg)
56
Reconstruction Customer Balance
Chosen financial MS Dynamics NAV reports IV
![Page 57: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/57.jpg)
57
Customer Balance by Due Date
Chosen financial MS Dynamics NAV reports V
![Page 58: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/58.jpg)
58
Customet Order Detail
Chosen financial MS Dynamics NAV reports IV
![Page 59: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/59.jpg)
59
Balance Statement
See next slides
![Page 60: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/60.jpg)
60
Balance Statement
PAGE 1
![Page 61: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/61.jpg)
61
Balance Statement
PAGE 2
![Page 62: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/62.jpg)
62
Detailed Income Statement
PAGE 1
![Page 63: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/63.jpg)
63
Detailed Income Statement
PAGE 2
PAGE 3
![Page 64: MS Dynamics – nothing simpler](https://reader036.vdocuments.us/reader036/viewer/2022062411/5681301d550346895d959cba/html5/thumbnails/64.jpg)
Thank you for your timeMiki Skorkovský, Navertica South Africa