The Rules Pattern
by Mark Brummel, Christopher Studebaker, David Studebaker, David Roys, Vjekoslav Ba
Microsoft Dynamics NAV
- Microsoft Dynamics NAV
- Table of Contents
- Microsoft Dynamics NAV
- Microsoft Dynamics NAV
- Credits
- Preface
- 1. Module 1
- 1. Exploring Microsoft Dynamics NAV – An Introduction
- Understanding Microsoft Dynamics NAV
- The functional areas within Dynamics NAV
- History of Dynamics NAV
- Functional areas
- Accessing Dynamics NAV
- Summary
- 2. What's New in NAV 2016?
- Application changes
- Improvements for the application users
- Tablet client
- New application features
- Automatic payment and bank reconciliation
- Signing up for the Bank Data Conversion Service
- Reconciling payments automatically
- Reconciling bank statements automatically
- Social Listening
- Power Business Intelligence
- RapidStart services
- Schedule reports
- E-mailing documents
- Document exchange service (OCR Services)
- Exchange rates update
- Native integration with Dynamics CRM
- Universal app
- Workflow management
- Posting Preview
- Deferrals
- Development changes
- IT changes
- Summary
- Application changes
- 3. Dynamics NAV – General Considerations
- 4. The Implementation Process – From the Reseller
- 5. The Implementation Process on the Customer Side
- 6. Migrating Data
- Tools to migrate data
- RapidStart Services
- Using XMLports to migrate data
- Writing your own tools
- Converting data from the old system to Dynamics NAV's needs
- Master data
- Open entries
- Historical data
- Open documents
- Choosing a go-live date
- Summary
- Tools to migrate data
- 7. Upgrading Microsoft Dynamics NAV
- Upgrading philosophy
- Upgrades prior to Dynamics NAV 2013
- Upgrades from Dynamics NAV 2013 forward
- Upgrading process checklist
- Upgrading steps to NAV 2013
- Upgrading tools
- Summary
- 8. Development Considerations
- 9. Functional Changes on Existing Implementations
- 10. Data Analysis and Reporting
- 11. Debugging
- 12. Popular Reporting Options with Microsoft Dynamics NAV
- 1. Exploring Microsoft Dynamics NAV – An Introduction
- 2. Module 2
- 1. An Introduction to NAV 2015
- NAV 2015 – an ERP system
- Significant changes in NAV 2015
- A developer's overview of NAV 2015
- Hands-on development in NAV 2015
- Summary
- Review questions
- 2. Tables
- An overview of tables
- Enhancing our sample application
- Creating and modifying tables
- Assigning a Table Relation property
- Assigning an InitValue property
- Adding a few activity-tracking tables
- New tables for our WDTU project
- New list pages for our WDTU project
- Keys, SumIndexFields, and table relations in our examples
- Modifying a standard table
- Version list documentation
- Types of tables
- Summary
- Review questions
- 3. Data Types and Fields
- 4. Pages – The Interactive Interface
- Page design and structure overview
- Types of pages
- Page Designer
- Page components
- WDTU Page Enhancement – part 1
- Page controls
- WDTU Page Enhancement – part 2
- Page Actions
- Learning more
- Summary
- Review questions
- 5. Queries and Reports
- Queries
- Reports
- Report components – overview
- Report data flow
- Report components – detail
- Creating a Report in NAV 2015
- Summary
- Review questions
- 6. Introduction to C/SIDE and C/AL
- 7. Intermediate C/AL
- 8. Advanced NAV Development Tools
- NAV process flow
- Role Center pages
- XMLports
- Web services
- Summary
- Review questions
- 9. Successful Conclusions
- Creating new C/AL routines
- Multi-language system
- Multi-currency system
- Navigate
- Debugging in NAV 2015
- C/SIDE Test-driven development
- Other Interfaces
- NAV Application Server (NAS)
- Client Add-ins
- Customizing Help
- NAV development projects – general guidance
- Design for efficiency
- Updating and upgrading
- Supporting material
- Summary
- Review questions
- 1. An Introduction to NAV 2015
- 3. Module 3
- 1. Introducing Dynamics NAV Patterns and Software Architecture
- What do we mean by 'patterns'?
- Microsoft Dynamics NAV Design Patterns
- Patterns elements and hierarchy
- Building blocks
- Metadata
- Base application
- Summary
- 2. Architectural Patterns
- 3. Design Patterns
- 4. Building an Example Application Using Patterns
- 5. Coding Best Practices
- 6. Anti-patterns and Handling Legacy Code
- 7. Building Solutions Using Patterns
- 1. Introducing Dynamics NAV Patterns and Software Architecture
- Bibliography
- Index
The Microsoft Dynamics NAV EARP application is designed to work for small, medium-sized, and larger businesses. The Rules Pattern enables us to store information in the database with a sliding level of complexity.
These tables have a composite Primary Key that has up to 20 fields, limited by the SQL Server or 900 bytes. The value being used in the application is based on rules. These rules are programmed in Codeunits.
The non-Primary Key fields typically determine the values that are being used after applying the rule, although these fields can also be a part of the Primary Key. For example, the selected printer, after filtering on the criteria, is an additional field in the table.
The following diagram explains how to implement the Rules pattern:
The Rules Pattern is used for the setup tables, and for either pricing or discount information. It is also used to implement a Select Distinct statement; for example, during the posting of Documents.
Note
To learn more about the Select Distinct statement in T-SQL, go to http://www.w3schools.com/sql/sql_distinct.asp.
-
No Comment