You're reading from Automated Testing in Microsoft Dynamics 365 Business Central - Second Edition

Product type Book

Published in Dec 2021

Publisher Packt

ISBN-13 9781801816427

Pages 406 pages

Edition 2nd Edition

Languages

Concepts

Enterprise Resource Planning

Table of Contents (22) Chapters

Preface

1. Section 1: Automated Testing – A General Overview

2. Chapter 1: Introduction to Automated Testing

3. Chapter 2: Test Automation and Test-Driven Development

4. Section 2:Automated Testing in Microsoft Dynamics 365 Business Central

5. Chapter 3: The Testability Framework

6. Chapter 4: The Test Tools, Standard Tests, and Standard Test Libraries

7. Section 3:Designing and Building Automated Tests for Microsoft Dynamics 365 Business Central

8. Chapter 5: Test Plan and Test Design

9. Chapter 6: From Customer Wish to Test Automation – the Basics

10. Chapter 7: From Customer Wish to Test Automation – Next Level

11. Chapter 8: From Customer Wish to Test Automation – the TDD way

12. Section 4:Integrating Automated Tests in Your Daily Development Practice

13. Chapter 9: How to Integrate Test Automation in Daily Development Practice

14. Chapter 10: Getting Business Central Standard Tests Working on Your Code

15. Section 5:Advanced Topics

16. Chapter 11: How to Construct Complex Scenarios

17. Chapter 12: Writing Testable Code

18. Chapter 13: Testing Incoming and Outgoing Calls

19. Section 6:Appendix

20. Other Books You May Enjoy

Appendix: Getting Up and Running with Business Central, VS Code, and the GitHub Project

From customer wish to test automation

Our customer wishes to extend standard Dynamics 365 Business Central with an elementary feature: the addition to the Customer table of a lookup field to be populated by the user. This field has to be carried over to the whole bunch of sales documents and also needs to be included in the warehouse shipping.

Data model

Even though the purpose of such a field will be very specific, we will generically name it Lookup Value Code. As with any other lookup field in Business Central, this Lookup Value Code field will have a table relation (foreign key) with another table, in our case, a new table called Lookup Value.

Figure 6.1 schematically describes the data model of this new feature, with the new table in the middle and the extended standard tables on the left and right sides:

Figure 6.1 – Lookup Value data model relational diagram

The Lookup Value Code field has to be editable on all tables except for the posted...