ppt-stdl.png MS Dynamics – nothing simpler Jaromír Skorkovský Training Manager Anytime C:\Documents and Settings\lkyncl\Plocha\mat\navertica\PPT\logo-prusvitne10%.png Agenda – concise screening of MS Dynamics NAV 2 •MS Dynamics – nothing simpler • * Short Live introduction–sales-replenishment-purchase-general ledger (International world wide demo database –WW or Czech database, company Cronus) * PWP Nothing simpler – form sequences and basic logic * Live system (WW database or Czech database Cronus – Financial Management) * Chart of accounts – structure – entries->Navigation * Budget * Setup – 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 * Customer|Vendor Accounting in NAV in one perspective (home study) I •Main principles of reporting 3 Customer|Vendor Order Item,Resource, Account,.. Business posting group code ,VAT,.. Business posting group code Posting Chart of accounts Item,Resource, Account,.. Item,Resource, Account,.. Item,Resource, Account,.. Item ledger Entries Stock value Item Value Entries Accounting in NAV main tool = General Journals (home study) 4 Chart of accounts Cash account Bank account •MS Dynamics – nothing simpler • 5 Protected Access to the system (ID and passwords). • MS Dynamics – nothing simpler • Working area 6 Info for presenter : Database open from Modularity- similarity to MS Office (such as Outlook)- Setup of the ERP functionality (modules) based on user requirement • MS Dynamics – nothing simpler • • Working area 7 One of the chosen menu module expanded. Every partial menu structure is similar, so finding the right functionality is very easy • MS Dynamics – nothing simpler • • 8 For control of your steps (processes) a mouse or key combination can be used. These combinations are same for every window type • MS Dynamics – nothing simpler • • 9 Data can be displayed by use of windows of the different types (card, list, form and sub-form->header and lines). You can have in the working area any quantity of the open windows. Anyhow , only one window is active at any moment. This is one example, where you can see a customer card, basic statistics for chosen customer and list of all customers in our database (one of many examples) • MS Dynamics – nothing simpler • • 10 Another example : customer card, item card and combination of two single records (windows, cards) in the shape of form and sub-form windows, which represent a most common MS Dynamics NAV structure composed of header and lines , in the other words, a type of document such as quote, order, credit notes, invoice delivery list , production order and so on. • MS Dynamics – nothing simpler • 11 Another example of data representation from manufacturing application : Form representing structure of the final product (Bill-of -Material), another form (window) (bellow BOM) representing a routing (how to produce a final product) and then you see production order and its components and calculated job lines based of predefined routings. • MS Dynamics – nothing simpler • • 12 Calculated fields (flow fields) : a technical wizardry to show at any time when chosen window is open a current calculated value such a balance, inventory quantity and so on. Be aware : these values are never saved in the database. It is a virtual value !!! • MS Dynamics – nothing simpler • • 13 Calculated fields (flow fields) : a technical wizardry to show at any time when chosen window is open a current calculated value such a balance, inventory quantity and so on. On the above example you can see item card with calculated field inventory and quantity on all production orders component lines. • MS Dynamics – nothing simpler • • 14 Calculation principles related to calculated fields (flow fields) : To every basic table (customer, vendor, item, account) a records called entries are related (connected). These entries have a common causes of its appearance in registration (booking, posting) of documents such as orders, invoices, production orders or credit notes. In our example we can see entries of the type invoice and some entries of the type payment. Payment entries apply invoice entries. If all invoice entries are applied , the calculated balance is zero • MS Dynamics – nothing simpler • 15 Navigate request panel to setup what you want to see • MS Dynamics – nothing simpler • • 16 Navigated (found) document related to previously chosen entry • MS Dynamics – nothing simpler • • 17 Navigation tool started from Menu item History, which can be found in most of the modules. The benefit of using is to find immediately any document of you know its specification (e.g. Number) or you can see all document related to chosen business partner (Vendor, Customer). • MS Dynamics – nothing simpler • • 18 Navigate window with entered parameters (type of the partner =Customer and its number). You can see from here 3 already created Sales Orders, 5 Sales Invoices, 6 Posted Sales Shipment and so on. Kindly see next slide • MS Dynamics – nothing simpler • • 19 List of Posted Sales Invoices of one chosen customer. From here you can preview a document in question (required one) • MS Dynamics – nothing simpler • • • 20 Found document related to chosen business partner and other parameters. Navigation benefits: quick access to required information and better decision making based on such a information • MS Dynamics – nothing simpler • • 21 Principles connected with sweet point called Easily from Anywhere to Wheresoever. The example can be started e.g. from Chart of account. Chosen account will be chosen for the group of turnover ones. The field where a chosen amount is displayed is calculated field (flow field). You can see drill down arrow in order to display immediately related general ledger entries from where the final amount is calculated (total amount called here Net Change) • MS Dynamics – nothing simpler • • 22 All general ledger entries having origin in booked documents (e.g .invoices). Mind you, that these entries are only entries related to one and only one sales account (filtering). From chosen entry we will go to document by use of Navigate tool (navigate functionality was already presented) in this power point show. • MS Dynamics – nothing simpler • • 23 The result of the use of Navigation tool. From here we will go (by use of Show button) to Posted Sales Invoice • • • • 24 From the displayed Posted Sales Invoice we will go directly to the inventory by use of Look-up function from the field No. of the Item in invoice line. So the next window is List of all items in our inventory and the next window is a item card which was sold . •MS Dynamics NAV • Drill down function 25 In order to see next step we went from Item Card to Item Ledger Entries, which are entries connected with item movements such as Sales, Purchase, Production , Transfer and so on. •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 SHOWN WHAT WAS PRESENTED SO FAR 26 Presented sequence which can be far much complicated (from the Item ledger entries you go to production order (if sold Item was a final product), than from production order to component stored on inventory and from here again by use of Item Ledger Entries window to Purchase Order and form here e.g. to Vendor card …….in the other words never ending story !!!! Reporting (NAV tools or JETs) •Reporting 27 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,..) Some chosen analysis asked by CFO EUROM Czech Republic •Analysis * Working capital – setup of the accounting schedule from NAV • 29 •Analysis * Working capital – Show of the results from NAV 30 •Some chosen analysis asked by CFO EUROM Czech Republic Some chosen analysis asked by CFO EUROM Czech Republic •Working Capital JETs * Working capital – Show of the results from JETs 31 Some chosen analysis asked by CFO EUROM Czech Republic •Inventory Dashboard 32 Some chosen analysis examples (JETs) •Analysis examples 33 Some chosen analysis examples (directly from NAV) •Cash Flow 34 Cash flow page 1 Cash flow page 2 On line analysis example generated over database by JETS •Account receivables 35 On line analysis example generated over database by directly from NAV •Account Payables 36 Simple business case 37 •MS Dynamics NAV Nothing simpler * Purchase order creation * Booking (posting, registering to the system) * Impacts in transactions (G/L, Logistic, payables) * Some examples of MS Dynamics NAV financial reports • •MS Dynamics NAV • F3 38 The basics of simple business case. Purchase Order ->Posting ->Impacts of registration of Purchase order-> Sales Order->Posting->Impacts . On first slide you have started from menu Purchase ->Order processing ->Orders and you will see one of many Purchase Orders, which has been created by another user connected to NAV database. The next step will be creation a new Purchase Order by use of F3 key (create new) •MS Dynamics NAV • 39 After pushing a key F3 we will get an empty structure of the Purchase Order composed by header where a Vendor will be entered and lines for Item (G/L Account ,…) which will be purchased (supplied). Firstly but not lastly you have to push Enter key, which results creation of the unique document number. For selection of particular Vendor (in the purchase order header) and Item (purchase order line) we will use key F6 called look-up. Every chosen table (either Vendor table or Item table must be always confirmed by pushing Enter key. •MS Dynamics NAV • 40 The process of selection of the Vendor from the list of vendors by use of Look up key (F6) •MS Dynamics NAV • 41 After confirmed chosen Vendor we have to enter by some method an Item from list of items (by use of Look-up key F6 and confirmation of your choice by Enter key) .Than you have to enter quantity and inventory location. The cost price of the item is taken primarily from the Item card. Anyhow, it can be changed if you wish to do so. •MS Dynamics NAV • 42 On this slide you can see the finished Purchase Order. On the next slide we can print it by use of print button and on the next screen Preview button •MS Dynamics NAV • 43 Result of the preview of the Purchase Order. This can be sent by e-mail or post or can be printed as a pdf file (based fully on the user requirement) •MS Dynamics NAV • 44 By use of F9 key (Statistics- you can have a lot of different Statistics from different winds by use of F9 key) you can display a statistics of recently created document (Purchase Order). You can see automatically calculated VAT based on the setup of General Business Posting Group (Vendor Card) ,VAT Business Posting Group and Posting Groups setup on Item Card. This principle is also common for the Sales. •MS Dynamics NAV • 45 You can post Purchase Order by use of key F11. Meaning that MS Dynamics NAV system will automatically create general ledger entries, VAT entries and inventory and value entries (besides other entries such a possible reservation entries, dimension entries and so on). You have the third possibilities shown on the slide . Use the third one which is in fact preset one please. Be aware, that you have to enter before posting to the header of the Purchase Order Vendor Invoice Number .In this case the vendor invoice number is Miki_001. This code is important when apply invoice with payment. •MS Dynamics NAV • 46 After registration (posting) of the Purchase Order is done by use of key F11 recently created Purchase order disappears from orders pool and a new posted purchase invoice order is created and can be found in menu - > History->Posted Invoice -> and use key (see upper bar) to find the last created posted invoice •MS Dynamics NAV • 47 To observe all entries which have been created after posting Purchase Order by use of the key F11 we will firstly go to Menu Financial Management Module ->History ->Register where you can see all general ledger entries created by ERP system MS Dynamics NAV. The type of the transaction is marked by a code in the source code field (predefined subset of codes). For our purchasing example it is code „Purchases“ and by use of button Register and an option General ledger you will see all related entries. We have to say, that MS Dynamics NAV is firstly double-booking entry system. To distinguish Debit and Credit amount syntax of the NAV system uses positive/negative signs. •MS Dynamics NAV • Item card before posting Purchase Order Posting You can see even calculated field showing, that Purchase Order for 20 pcs has been created Item card after posting 48 Another impact of the posting Purchase Order is Inventory Accrual, meaning that system, beside automatically created Item Ledger entry, also calculates by use of flow field function on the item card a new final inventory level of the Item in question, so the original amount before purchase order posting was increased •MS Dynamics NAV • Vendor card before posting Vendor card after posting 129446,40-11409,40=15350 49 And lastly, a balance amount (payables) related to our Vendor, which has been used for delivery (purchase) increased. Firstly on the slide you see a Vendor card before a Purchase Order is posted, than a posting happened by F11 and we can see Vendor ledger entries where the last entry is connected with just posted Purchase Order. Finally you can see a actual Vendor card with new calculated payables amount ins the calculated field. And an equation on this slide shows ,that your payables has increased by a value from posted purchase order. •MS Dynamics NAV • 50 System automatically calculates a actual stock value as it is visible on the next two slides. •MS Dynamics NAV • 51 Inventory valuation report. •MS Dynamics NAV • 52 One of the system reports showing payables or Vendor/Item Purchases (based on the user´s requests). MS Dynamics NAV reporting system is amazingly powerful and flexible. 53 •Customer –Summary Aging Chosen financial MS Dynamics NAV reports I 54 •Customer –Detailed Aging • Chosen financial MS Dynamics NAV reports II 55 •Customer –Detailed Trial Balance Chosen financial MS Dynamics NAV reports III 56 •Reconstruction Customer Balance Chosen financial MS Dynamics NAV reports IV 57 •Customer Balance by Due Date Chosen financial MS Dynamics NAV reports V 58 •Customet Order Detail Chosen financial MS Dynamics NAV reports IV 59 •Balance Statement 60 •Balance Statement 61 •Balance Statement 62 •Detailed Income Statement 63 •Detailed Income Statement • Navertica.png Thank you for your time •Miki Skorkovský