Reference:
https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/how-to-use-a-report-data-provider-class-in-a-report

Scenario: Implement the Excel integration for the Vendor Exclusion List form.
B: By opening entity data in Excel, you can quickly and easily view and edit the data by using the Excel add-in.
Reference:
https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/office-integration/use-excel-add-in
https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/power-bi-integration

Explanation:

Scenario: The Chief Financial Officer (CFO) requires the following reports:
A report that shows all outstanding invoices, their cash discount types including the new minimum threshold applicable, and the amount of the discount. The report must only be accessed by users who are members of the Accounts Payable Manager role.
Box 1: DataContractAttribute
DataContractAttribute - This attribute is applied to an X++ class and specifies that the class can be used as a data contract (that it should be serialized).
Box 2: DataMemberAttribute
DataMemberAttribute - This attribute is applied to a parm (parameter) method on an X++ data contract class and specifies that the data member should be serialized.
Box 3: SRSReportParameterAttribute
You set the SRSReportParameterAttribute attribute to the data contract you created for the RDP class.
Reference:
https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/how-to-use-a-report-data-provider-class-in-a-re
Topic 3, Munson's Pickles and Preserves FarmBackground
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 565 Finance.
Current environment
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 wen 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 rs set up to use a custom model named GPExtensions.
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 36S 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.
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 m Dynamics 365 Finance.
Requirements
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 m Dynamics 365 Finance.
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 m 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.
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 gnd. 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.