Using Microsoft Dynamics 365 for Finance and Operations: Learn and understand the functionality of Microsoft's enterprise solution

486 Pages·2019·28.57 MB·English

by  Andreas Luszczak

Andreas Luszczak
Using Microsoft
Dynamics 365
for Finance and
Operations
Learn and understand the functionality
of Microsoft’s enterprise solution
Using Microsoft Dynamics 365 for Finance and
Operations
Andreas Luszczak
Using Microsoft Dynamics
365 for Finance and
Operations
Learn and understand the functionality
of Microsoft’s enterprise solution
Andreas Luszczak
Wien, Austria
ISBN 978-3-658-24106-3 ISBN 978-3-658-24107-0 (eBook)
https://doi.org/10.1007/978-3-658-24107-0
Library of Congress Control Number: 2018965573
Springer Vieweg
© Springer Fachmedien Wiesbaden GmbH, part of Springer Nature 2019
This work is subject to copyright. All rights are reserved by the Publisher, whether the whole or part of the
material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation,
broadcasting, reproduction on microfilms or in any other physical way, and transmission or information storage
and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now known or
hereafter developed.
The use of general descriptive names, registered names, trademarks, service marks, etc. in this publication does
not imply, even in the absence of a specific statement, that such names are exempt from the relevant protective
laws and regulations and therefore free for general use.
The publisher, the authors and the editors are safe to assume that the advice and information in this book are
believed to be true and accurate at the date of publication. Neither the publisher nor the authors or the editors
give a warranty, express or implied, with respect to the material contained herein or for any errors or omissions
that may have been made. The publisher remains neutral with regard to jurisdictional claims in published maps
and institutional affiliations.
This Springer Vieweg imprint is published by the registered company Springer Fachmedien Wiesbaden GmbH
part of Springer Nature
The registered company address is: Abraham-Lincoln-Str. 46, 65189 Wiesbaden, Germany
Preface
Reading this Book
The primary purpose of this book is to provide you with a good knowledge of the
concept and functionality of Microsoft Dynamics 365 for Finance and Operations.
As a result, you should be able you to execute business processes in the application
on your own. It is primarily designed for users, students, and consultants who are
interested in learning how to use the application.
Going beyond the operations on the user interface, you learn how the different
parts of the application work together. For this reason, also system administrators,
developers, IT executives, or consultants who do not know all the details of the
application take advantage of getting to know the end-to-end concept.
The best way to learn an application is to use it. For that reason, this book includes
exercises that build up on each other in a comprehensive case study. If you need
support with the exercises, download the illustrated sample solutions.
Microsoft Dynamics 365 for Finance and Operations is a very comprehensive
business solution, which makes it impossible to explain all parts of the application
in a single book. In order to provide a profound understanding of the core
application, this book addresses the core functionality in the supply chain
(including trade and logistics, and production control) and finance management. It
covers the application but does not cover tasks in system administration and
development.
Microsoft Dynamics 365 Version
This book is based on version 8.1 of Microsoft Dynamics 365 for Finance and
Operations (released in October 2018). It is an update of my previous book editions
on Dynamics AX. In order to avoid repeating the current long name, the short
name “Dynamics 365” is used for the application in most parts of this book.
Applicable Settings
In Dynamics 365, you can individually select the language of your user interface.
Descriptions and illustrations in this book refer to the language “EN-US” (United
States English). Whereas it is obvious that the Dynamics 365 client shows different
labels when you select languages like Spanish or Russian, there are also differences
when you select British English. For example, the label for the field “Sales tax” is
“VAT” in British English. Other differences between your application and the
VI Preface
descriptions in the book are possibly caused by permission settings, by local
features, by later updates, or by modifications and add-ons in your application.
In order to benefit from the explanations, it is recommended to practice with
Dynamics 365. A separate test application, which you can use to execute the
exercises, is required to avoid an impact on actual company data.
The illustrations and the exercises in this book refer to the Microsoft standard
demo environment with the company “Contoso Entertainment System USA”
(“USMF”). For the screenshots, the color theme “High contrast” and a small
element size has been selected in the visual preferences of the user options. In
order to grant a flexible choice of your training environment, the tasks in the
exercises are specified in a way that you can use any Dynamics 365 test
environment of your choice.
Available Support
You can download the exercise guide for the exercises in this book and other
applicable resources from the online service of the publisher, or from my website:
http://D365book.addyn.com
If you have comments or questions regarding the book or the exercises, please
contact me via this website or e-mail to [email protected].
Acknowledgments
Many people have been involved in finalizing this book, directly and indirectly,
from the first to the current edition. Thank you to all of them. In particular, I would
like to mention Matthias Gimbel (STZ IT Business Consulting), Ingo Maresch
(Solutions Factory Consulting), and Finn Nielsen-Friis (AXcademy).
Thank you also to the editor, Sabine Kathke, and to my family – Sonja, Felix, and
Caroline.

Andreas Luszczak
Table of Contents
1 What is Microsoft Dynamics 365/AX? ..................................................................... 1
1.1 Dynamics 365, Dynamics AX and Axapta .................................................... 1
1.2 Dynamics 365 for Finance and Operations at a Glance .............................. 2
1.2.1 Functional Capabilities ........................................................................ 2
1.2.2 Implementation ..................................................................................... 3
1.2.3 Data Structure ....................................................................................... 4
1.2.4 Voucher Principle ................................................................................. 4
2 Getting Started: Navigation and General Options ................................................ 5
2.1 User Interface and Common Tasks ............................................................... 5
2.1.1 Login and Authentication .................................................................... 5
2.1.2 Navigation ............................................................................................. 5
2.1.3 Elements of the User Interface ............................................................ 9
2.1.4 Working with Records ....................................................................... 17
2.1.5 Filtering and Sorting ........................................................................... 23
2.1.6 Help System ......................................................................................... 28
2.1.7 Case Study Exercises .......................................................................... 29
2.2 Printing and Reporting.................................................................................. 30
2.2.1 Printing Documents ............................................................................ 30
2.2.2 Microsoft Office Integration .............................................................. 35
2.2.3 Case Study Exercise ............................................................................ 37
2.3 Advanced Options ......................................................................................... 37
2.3.1 User Options and Personalization .................................................... 37
2.3.2 Record Information and Templates ................................................. 41
2.3.3 Case Study Exercises .......................................................................... 44
2.4 Global Address Book ..................................................................................... 44
2.4.1 Parties and Addresses ........................................................................ 44
2.4.2 Address Books ..................................................................................... 46
2.4.3 Case Study Exercise ............................................................................ 47
3 Purchase Management ............................................................................................ 49
3.1 Business Processes in Purchasing ................................................................ 49
3.1.1 Basic Approach ................................................................................... 49
3.1.2 At a Glance: Purchase Order Processing ......................................... 52
VIII Table of Contents
3.2 Vendor Management .................................................................................... 54
3.2.1 Vendor Records .................................................................................. 54
3.2.2 Payment Terms and Cash Discounts ............................................... 59
3.2.3 Ledger Integration ............................................................................. 62
3.2.4 Case Study Exercises ......................................................................... 63
3.3 Product Management in Purchasing .......................................................... 64
3.3.1 Product Categories and Procurement Categories ......................... 64
3.3.2 Basic Product Data ............................................................................. 66
3.3.3 Purchase Price Setup ......................................................................... 71
3.3.4 Case Study Exercises ......................................................................... 76
3.4 Purchase Order Management ...................................................................... 76
3.4.1 Basics of Purchase Order Processing ............................................... 76
3.4.2 Purchase Order Registration ............................................................ 79
3.4.3 Change Management and Purchase Order Approval .................. 86
3.4.4 Canceling and Deleting Purchase Orders ....................................... 88
3.4.5 Purchase Inquiries and Order Confirmations ................................ 89
3.4.6 Case Study Exercises ......................................................................... 92
3.5 Item Receipts .................................................................................................. 93
3.5.1 Basics of Item Receipts ...................................................................... 93
3.5.2 Receipts Lists ...................................................................................... 94
3.5.3 Inventory Registration ....................................................................... 94
3.5.4 Product Receipts ................................................................................. 98
3.5.5 Partial Delivery, Underdelivery, and Overdelivery .................... 100
3.5.6 Order Status and Inquiries .............................................................. 102
3.5.7 Case Study Exercises ....................................................................... 105
3.6 Invoice Receipts ........................................................................................... 106
3.6.1 Processing Vendor Invoices ............................................................ 106
3.6.2 Order Status and Inquiries .............................................................. 111
3.6.3 Case Study Exercises ....................................................................... 113
3.7 Vendor Credit Notes and Item Returns ................................................... 114
3.7.1 Crediting and Returning ................................................................. 114
3.7.2 Credit Notes without Item Return ................................................. 116
3.7.3 Case Study Exercise ......................................................................... 117
3.8 Purchase Agreements, Requisitions, and Quotation Requests ............. 118
3.8.1 Purchase Agreements ...................................................................... 118
3.8.2 Purchase Requisitions ..................................................................... 119
3.8.3 Requests for Quotation .................................................................... 121
3.8.4 Case Study Exercise ......................................................................... 124
Table of Contents IX
4 Sales and Distribution ............................................................................................ 125
4.1 Business Processes in Sales and Distribution ........................................... 125
4.1.1 Basic Approach ................................................................................. 125
4.1.2 At a Glance: Sales Order Processing .............................................. 128
4.2 Customer Management ............................................................................... 130
4.2.1 Core Data in the Customer Records ............................................... 130
4.2.2 Case Study Exercise .......................................................................... 133
4.3 Product Management in Sales .................................................................... 134
4.3.1 Product Data and Sales Categories................................................. 134
4.3.2 Sales Price and Discount Setup ....................................................... 135
4.3.3 Case Study Exercises ........................................................................ 140
4.4 Sales Order Management ............................................................................ 141
4.4.1 Basics of Sales Order Processing ..................................................... 141
4.4.2 Sales Quotations ................................................................................ 142
4.4.3 Sales Order Registration .................................................................. 144
4.4.4 Order Prices and Discounts ............................................................. 151
4.4.5 Surcharge Management ................................................................... 153
4.4.6 Sales Order Confirmations .............................................................. 155
4.4.7 Case Study Exercises ........................................................................ 156
4.5 Delivery Management ................................................................................. 157
4.5.1 Basics of Picking and Shipping ....................................................... 157
4.5.2 Pick Form and Picking Lists ............................................................ 159
4.5.3 Picking Workbench .......................................................................... 162
4.5.4 Packing Slips...................................................................................... 164
4.5.5 Case Study Exercises ........................................................................ 166
4.6 Sales Invoices ................................................................................................ 167
4.6.1 Sales Order Invoices ......................................................................... 167
4.6.2 Collective Invoices ............................................................................ 168
4.6.3 Free Text Invoices ............................................................................. 170
4.6.4 Case Study Exercises ........................................................................ 172
4.7 Sales Credit Notes and Item Returns ........................................................ 173
4.7.1 Return Order Management ............................................................. 173
4.7.2 Simple Credit Notes ......................................................................... 176
4.7.3 Case Study Exercise .......................................................................... 177
4.8 Direct Deliveries ........................................................................................... 177
4.8.1 Processing Direct Deliveries ............................................................ 177
4.8.2 Case Study Exercise .......................................................................... 180
4.9 Trade Allowances and Incentive Management ....................................... 180
X Table of Contents
4.9.1 Trade Allowances ............................................................................ 180
4.9.2 Broker Contracts ............................................................................... 187
4.9.3 Royalty Agreements ........................................................................ 188
4.9.4 Vendor Rebates ................................................................................ 188
5 Production Control ................................................................................................ 189
5.1 Business Processes in Manufacturing ....................................................... 189
5.1.1 Basic Approach ................................................................................. 189
5.1.2 At a Glance: Production Order Processing ................................... 192
5.2 Product Management and Bills of Materials ........................................... 194
5.2.1 Product Data in Manufacturing ..................................................... 194
5.2.2 Bills of Materials (BOM) .................................................................. 196
5.2.3 Case Study Exercises ....................................................................... 203
5.3 Resource and Route Management ............................................................ 204
5.3.1 Working Time Calendars and Templates ..................................... 205
5.3.2 Resource Groups and Resource Management ............................. 206
5.3.3 Routes and Operations .................................................................... 212
5.3.4 Case Study Exercises ....................................................................... 220
5.4 Production Order Management ................................................................ 221
5.4.1 Basics of Production Order Processing ......................................... 221
5.4.2 Production Order Registration ....................................................... 222
5.4.3 Processing Production Orders ........................................................ 225
5.4.4 Case Study Exercises ....................................................................... 231
5.5 Consumption of Material and Resource Capacity .................................. 231
5.5.1 Journal Setup and Ledger Integration ........................................... 232
5.5.2 Picking Lists ...................................................................................... 233
5.5.3 Resource Usage ................................................................................ 235
5.5.4 Case Study Exercises ....................................................................... 236
5.6 Reporting as Finished and Ending Production ....................................... 236
5.6.1 Reporting as Finished ...................................................................... 236
5.6.2 Ending and Costing ......................................................................... 239
5.6.3 Case Study Exercise ......................................................................... 241
5.7 Subcontracting ............................................................................................. 241
5.7.1 External Resources ........................................................................... 241
5.7.2 Purchased Services ........................................................................... 242
5.8 Formulas and Batch Production Orders................................................... 245
5.8.1 Formula Management ..................................................................... 245
5.8.2 Batch Production Orders ................................................................. 247