Extending Table Insert Method in Dynamics 365 F&O
Create and extend the data model
Create classes and extend AOT elements
Short answer
D Right-click the WHSTmpStatusChange table in the Application Object Tree (AOT) and create an extension in the existing project.
Question
Case study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. When you are ready to answer a question, click the Question button to return to the question.
Background
Munson's Pickles and Preserves Farm produces and sells jarred food goods. The organization has several production and warehouse locations across the United States. Each location runs both production and warehousing operations. The company has three locations: East, Central, and West.
The company is upgrading its Dynamics AX 2009 system to Dynamics 365 Finance.
Current environment. General
Munson's Pickles and Preserves Farm plans to migrate customizations, data, and integration from its legacy system into Dynamics 365 finance and operations apps.
The Dynamics 365 finance and operations environment includes:
• multiple cloud-hosted development environments using Microsoft Visual Studio 2017
• a Microsoft Azure DevOps project for source control
• two tier 2 environments for user acceptance testing and staging, as well as production
Munson's Pickles and Preserves Farm is currently in the planning and development phase of the upgrade process. The company's internal development team needs additional development resources to address issues. The company already created a project that is set up to use a custom model named GPExtensions.
Current environment. Integrations
Munson's Pickles and Preserves Farm has a new integration for its freight processing information. The internal development team created the secure file transfer protocol (SFTP) site for the source information to be stored and the staging table to house the source information once the data is added to Dynamics 365 Finance. Information from the source will be transferred once a day from the source system and integrated with the target system. More than 10,000 records will be transferred over the integration. The company created an aggregate entity for the integration to minimize the amount of transmitted data.
Munson's Pickles and Preserves Farm has added a new integration for freight processing where all item weights, dimensions, and other factors will be configured in the external portal while planning the loads. Once the load is planned, it will be integrated into Dynamics 365 finance and operations apps for the freight invoice processing to occur.
No duplicate invoices or posting are associated with the freight invoice charges. The integration of this information from the source system is intended only for report creation and compilation purposes.
Current environment. Planned changes
Munson's Pickles and Preserves Farm wants to change inventory forms to fit its current needs. Any modifications or enhancements must follow the existing functionality for forms in Dynamics 365 Finance.
Requirements. Integrations
All data from integrations have the same format as an existing Dynamics 365 Finance apps field. All enhancements or customizations must use existing assets before creating new functionality.
Munson's Pickles and Preserves Farm wants to change its integration strategy to include real-time data from the freight processing source system. The inventory must update as it is sold from the system. That information will be updated in Dynamics 365 Finance.
The freight processing integration requires the use of an SFTP site to store XML files from the source system. The additional integration will use OData and must be transferred in real time.
A periodic batch job must:
• Pull data from the SFTP site.
• Import the data to a staging table used to hold the information from the source system.
• Map source data to the target table in Dynamics 365 Finance.
The imported Load ID field must be added to the Sales Order header for all processed orders. Additional requirements for integrations, including other integration strategies, may be necessary as the company grows. Existing tables must be changed to include the Load ID. The database will need to be synched before adding the Load ID field.
Requirements. Changes
Munson's Pickles and Preserves Farm must change the Inventory Status form to include more columns. It plans to create a table to enter the data for the Inventory Status form as a new data source. The company wants to add both the Product Name field and Batch ID field to this new table. The current form includes the item number, location, license plate, product inventory dimensions, and quantity.
The grid on the Inventory Status form must include the product name by using the item number and legal entity. The user interface must be created to include the new columns and the data must be available to add to the grid. The form must have only an Action Pane, a Navigation List, a List Style Grid, a Details Header, and a Details Tab in the design and include the Load ID field.
Munson's Pickles and Preserves Farm is currently in the process of adding the other required fields: one for Product Name and one for Batch ID. The new fields must be related to extended data types for the original fields on the existing data source for the Inventory Status form. Munson's Pickles and Preserves Farm plans to add the EcoResProductName and Batch ID data to the extended table for WHSTmpStatusChange. The fields on the table extension must be populated with data and visible on the Inventory Status form on insert.
Issues
• The internal development team has created the SFTP site connections, the staging table, and the batch jobs for the new integration for freight processing. The development team needs to map the source data to the target table and the data management workspace. The development team notices errors with mapping target fields in the data management workspace. The team needs another developer to configure the table extensions, class extensions, and form extensions that are required for the planned changes.
• The internal development team has issues adding the required fields to the Inventory Status standard form. The team needs another developer to configure the table extensions, class extensions, and form extensions that are required for the planned changes.
You need to add data to the WHSTmpStatusChange table by extending the insert method.
What should you do?
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. When you are ready to answer a question, click the Question button to return to the question.
Background
Munson's Pickles and Preserves Farm produces and sells jarred food goods. The organization has several production and warehouse locations across the United States. Each location runs both production and warehousing operations. The company has three locations: East, Central, and West.
The company is upgrading its Dynamics AX 2009 system to Dynamics 365 Finance.
Current environment. General
Munson's Pickles and Preserves Farm plans to migrate customizations, data, and integration from its legacy system into Dynamics 365 finance and operations apps.
The Dynamics 365 finance and operations environment includes:
• multiple cloud-hosted development environments using Microsoft Visual Studio 2017
• a Microsoft Azure DevOps project for source control
• two tier 2 environments for user acceptance testing and staging, as well as production
Munson's Pickles and Preserves Farm is currently in the planning and development phase of the upgrade process. The company's internal development team needs additional development resources to address issues. The company already created a project that is set up to use a custom model named GPExtensions.
Current environment. Integrations
Munson's Pickles and Preserves Farm has a new integration for its freight processing information. The internal development team created the secure file transfer protocol (SFTP) site for the source information to be stored and the staging table to house the source information once the data is added to Dynamics 365 Finance. Information from the source will be transferred once a day from the source system and integrated with the target system. More than 10,000 records will be transferred over the integration. The company created an aggregate entity for the integration to minimize the amount of transmitted data.
Munson's Pickles and Preserves Farm has added a new integration for freight processing where all item weights, dimensions, and other factors will be configured in the external portal while planning the loads. Once the load is planned, it will be integrated into Dynamics 365 finance and operations apps for the freight invoice processing to occur.
No duplicate invoices or posting are associated with the freight invoice charges. The integration of this information from the source system is intended only for report creation and compilation purposes.
Current environment. Planned changes
Munson's Pickles and Preserves Farm wants to change inventory forms to fit its current needs. Any modifications or enhancements must follow the existing functionality for forms in Dynamics 365 Finance.
Requirements. Integrations
All data from integrations have the same format as an existing Dynamics 365 Finance apps field. All enhancements or customizations must use existing assets before creating new functionality.
Munson's Pickles and Preserves Farm wants to change its integration strategy to include real-time data from the freight processing source system. The inventory must update as it is sold from the system. That information will be updated in Dynamics 365 Finance.
The freight processing integration requires the use of an SFTP site to store XML files from the source system. The additional integration will use OData and must be transferred in real time.
A periodic batch job must:
• Pull data from the SFTP site.
• Import the data to a staging table used to hold the information from the source system.
• Map source data to the target table in Dynamics 365 Finance.
The imported Load ID field must be added to the Sales Order header for all processed orders. Additional requirements for integrations, including other integration strategies, may be necessary as the company grows. Existing tables must be changed to include the Load ID. The database will need to be synched before adding the Load ID field.
Requirements. Changes
Munson's Pickles and Preserves Farm must change the Inventory Status form to include more columns. It plans to create a table to enter the data for the Inventory Status form as a new data source. The company wants to add both the Product Name field and Batch ID field to this new table. The current form includes the item number, location, license plate, product inventory dimensions, and quantity.
The grid on the Inventory Status form must include the product name by using the item number and legal entity. The user interface must be created to include the new columns and the data must be available to add to the grid. The form must have only an Action Pane, a Navigation List, a List Style Grid, a Details Header, and a Details Tab in the design and include the Load ID field.
Munson's Pickles and Preserves Farm is currently in the process of adding the other required fields: one for Product Name and one for Batch ID. The new fields must be related to extended data types for the original fields on the existing data source for the Inventory Status form. Munson's Pickles and Preserves Farm plans to add the EcoResProductName and Batch ID data to the extended table for WHSTmpStatusChange. The fields on the table extension must be populated with data and visible on the Inventory Status form on insert.
Issues
• The internal development team has created the SFTP site connections, the staging table, and the batch jobs for the new integration for freight processing. The development team needs to map the source data to the target table and the data management workspace. The development team notices errors with mapping target fields in the data management workspace. The team needs another developer to configure the table extensions, class extensions, and form extensions that are required for the planned changes.
• The internal development team has issues adding the required fields to the Inventory Status standard form. The team needs another developer to configure the table extensions, class extensions, and form extensions that are required for the planned changes.
You need to add data to the WHSTmpStatusChange table by extending the insert method.
What should you do?
Key Takeaways
The core concept tested is applying Chain of Command for extending standard table methods, with the common trap being confusion between creating new objects versus extending existing ones via the AOT.
This question addresses how to extend the insert method of a standard table in Dynamics 365 Finance and Operations using Chain of Command. It establishes that creating a table extension in the existing project is the correct procedural step.
Common mistake: Many learners incorrectly choose Option A (adding a Class object) because they associate code extension with classes, failing to recognize that table extensions are the specific mechanism for overriding table methods like insert() in modern D365 F&O development.
Expert Analysis
Why the Answer Is Correct
To extend theinsert method of a standard table like WHSTmpStatusChange, you must use the Chain of Command feature introduced in Dynamics 365 Finance and Operations. This requires creating a Table Extension rather than modifying the base table or creating a standalone class. In Visual Studio, this is done by right-clicking the table in the Application Object Tree (AOT) and selecting the option to create an extension within the existing project. This generates a partial class that can override the insert method while maintaining backward compatibility.Why the Other Options Are Wrong
Option A suggests adding a new Class object; however, Chain of Command for tables specifically utilizes Table Extensions, not generic classes. Option C suggests creating a new Table object, which would result in a separate entity rather than an extension of the existingWHSTmpStatusChange table, violating the requirement to modify existing functionality. Option B suggests viewing the code directly in the AOT, which is impossible for standard Microsoft-provided tables as they are locked and cannot be modified directly.Community Comment Notes
Community feedback highlights the importance of using Chain of Command. As noted by user MohraFawzy, extending theinsert method requires a table extension class. Another commenter emphasized that one must "extend it correctly first," pointing to the creation of the extension artifact itself (Option D) as the necessary prerequisite action before writing the override logic. Exam Strategy
Always look for 'Chain of Command' keywords when dealing with extending standard table methods. Remember that you cannot modify base tables directly; you must create extensions in your project, specifically Table Extensions for table logic.
Frequently Asked Questions
Why not add a new Class object?
Chain of Command for tables uses Table Extensions, not generic classes, to ensure proper inheritance and method overriding capabilities.
Can I modify the standard table directly?
No, standard Microsoft tables are locked. You must create an extension in your custom project to modify or extend their behavior.
Discussion 2 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors, not of islever. The comments shown first are the most substantive of the thread — ranked by depth, community endorsement and relevance; expand the list below to read the rest.
From public community threads 2
-
MohraFawzy 👍 1 Answered ATo extend the insert() method of the standard table WHSTmpStatusChange, you should use Chain of Command (CoC) in a table extension class.
-
cbef765 👍 1You are right, but you need to extend it correctly first, therefore its D
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.
Related Analysis
Practice All MB-500 Questions
Access 115 questions with complete answers and detailed explanations.
View Full MB-500 Practice Test →