Complex example I ERP Microsoft Dynamics NAV 2018wl Created by Jaromír Skorkovský Date 23.10.2019 For MPH AOMA and AOPR and BPH EPS1 Keys Database MS Dynamics NAV 2018wl Ctrl-N=New, F4=Look-up, Ctrl-F7-entries, F7-statistics, F9-post Shorthands G/L General Ledger, TO-Transfer Order Tutor-TU 1. Find Item 80208->Searching windows->ltem->List of items ->Filter (right upper corner)->80208 2. See Item Ledger Entries->Ctrl-F7- >should be none. It means, that no Purchase neither Production was processed, which action may increase inventory 3. Go to Departments (lower-left corner of the working area)->Purchasing ->Order Processing->Purchase Orders and icon New 4. Enter Vendor Number into the first field (use mouse or typing or F4) -> 20000 and confirm by key 5. Go to Purchase Lines->Enter Type=ltem and Item Number 80208 and Location->BLUE (the YELLOW location must be overwritten) ->Quantity 10 and Direct Unit Cost=2 (the original cost have to be overwritten) 6. In the Purchase Order Header, you have to enter Vendor Invoice Number (ESF_20191023) 7. Post document by F9 (Invoice and Receive option) 8. Go to Departments (lower-left corner of the working area)->Financial Management->General Ledger ->Tasks->General Journals 9. Use Batch name =Default (if some lines created previously were already there- erase them by icon Delete-upper left corner) 10. Enter Document Type>Payment (use mouse of F4) ->Account Type=Vendor-> Account Number =20000->Balance Account Type=Bank->Bank Account->Balance Account Number=NBL 11. Upper Bar Menu-> Actions and icon Set Applies-to ID 12. Chose our External number ESF_20191023, which is in fact Vendor Invoice Number and click on Set Applies-to ID ->internal number starting with GOOOx will be created 13. Confirm by OK 14. See what happened in General Journal and post it by F9 15. Go to the searching window and find Vendor 20000->Ctrl-F7 and see created Vendor Ledger Entries 16. Go to Items ->80208 and Ctrl-F7 and see Item Ledger Entries 17. Go to Departments->Purchasing->Order Processing->Transfer Orders and click NEW 18. Transfer-from code =BLUE to Transfer-to code=RED 19. Enter data into Transfer line->ltem number=80208, Quantity =5 20. Post two times Transfer Order by F9 and the go-to ltems->find Item 80208 and Ctrl-F7 to see Item Ledger Entries 21. Go to Departments->Sales&lv1arketing ->Order Processing->Sales Orders->lcon NEW->Enter Customer Numer (second field from above) =10000 into Sales Order Header ->go to Sales Lines and enter Type=ltem->ltem Number=80208->Location=BLUE->Quantity=2 and Unit price=4 (original unit price must be overwritten)- >Print SO confirmation and post it by F9 22. See Icon by Location window 23. Go to the General Journal and accept Payment from Customer 10000 (the actions taken are more and less the same which we carried out with payment to our Vendor (see bullets 8-14 of this example) 1 24. See Customer Ledger Entries and Item Ledger Entries - final results 25. Customer Ledger Entries Posting Date Document Document Customer M Description Curre... Original Amount Remaining Due Date Type No. No. t.. Code Amount Amount [ililioit "j Invoice 103034 10000 Order 1005 10,00 10,00 10,00 28.02.2021 28.01.2021 Invoice 103033 10000 Order 1004 2141,30 2 141,30 2141,30 28.02.2021 28.01.2021 Invoice 103032 10000 Order 1003 8363,00 8365,00 3 365,00 28.02,2021 26. Vendor Ledger Entries Posting Cite Document Document External Document No 'Ardor Ho. M. Description 0«. »,.. Pj.„ c. Criminal Amount Amount (ICY) : err .■ ;: ' t,.:: ■ Cut Date Type Mo. to.. Code M_ Re-, H. Amount Amcurt Amt. (ico 213IJEI ma 20O3O AP. Day Property Manic*... 25,00 »,00 25,00 0,00 0X0 2MU021 ütUBI lira! 19K8Í ESFiOISlOiJ 20000 tMeNSBM •25,00 -25,s) •25,00 0,05 Ďffi 31.51.2023 27. Item Ledger Entries Pr 1W3CÍ Ha ÜLJt •Í -5 • 3.00 ■10,50 0,00 □ TnnUti 10'3J? BtUE 13 13 J 3.50 SJ.30 orco H 28. Item by Locations Items by Location Matrix 0 item - Ä Find Nc. „ Description UNSPECIFIED BLUE DAY GREEN RAL10 RED Graphic Card MS «0204 Ultra ttSVM SCSI Controller 3SZ05 10M8it Ethernet 50206 'Webcam 3020? Basic Mcuoe _ _ E020B Advanced Mouse 3 5 j... 29. General Ledger Entries->FinanciaI Managernent->General Ledger->Archive->History->G/L Registers->upper-left corner icon G/L Entries Posti... Document Document 3/1 „ Description Gen. Gen. Bus, Gen, Prod. Amount Sal, Bal. Dots Type Mo. Accc. Psstin,,, Posting ,„ Posting,.. Atem,, Acccu,,, 28.01.2021 Invoice 108036 7110 Order 106024 Purchase DOMESTIC RETAIL 20,00 G/L Account 28.01.2C21 invoice 103034 6110 Order 1005 Sale DOMESTIC RETAIL •8,00 G/L Account 28.01,2021 Invoice 1Ö8Ö36 3630 Order 106024 5,0t) G/L Account 28.01.2021 Invoice 103034 S61D Order 1005 ■2,00 G/L Account 28.01.2021 G000C2 5410 AR Day Property Managern... 25,00 Bank Accc, NBL 28.01,2021 Invoice 108036 541Ô Order I06O24 -25,00 G/L Account 28.01,2021 G00302 2920 AR Day Property Managern,. •25,00 Vender 2G00O 28.01.2021 Invoice 153034 2310 Order 1005 10,00 G/L Account 2