Add Inventory Dimension Details in Purchase Receiving Log report in D365FO using Electronic Reporting

Add Inventory Dimension Details in Purchase Receiving Log report in D365FO

Requirements

Purchase Receiving log report is an SSRS report. The requirement is to have columns of different inventory dimensions. The present output of the report is given below:


Solution:

To achieve the above requirement, we will be creating the same report in the Electronic reporting. The main table record for the above report is "VendPurchReceivingLog". Let's start the configuration in Electronic reporting. 

This blog is more focused on the screenshot rather than explaining the steps to create the data model, model mapping, format, etc.

1. Create a data model.

2. Map the model to the data source. Here main data sources are Table records  - VendPurchReceivingLog and Inventory dimension details. We have added the Inventory dimension details (Data source types > Functions > Inventory dimension details) to achieve a dynamic selection of Inventory dimensions at runtime.

3. After completing the data model and model mapping. Create an excel template having the required columns. Also define name ranges for header part : InventDimNames for dynamically increase the columns based on inventory dimension names.

4. Import the excel file into format designer. Thereafter, we need to add ranges just above our cell "InventDimNames" and "InventDimValues" with replication as Horizontal. [similar to my last blog: ER - Use Horizontally Expandable Ranges To Dynamically Add Columns In Excel Reports- D365FO]


5. Bind the format to format mappings.

6. Change the status of the format to "Complete" and run the report. 
7. At run time, the user can select the required inventory dimension that is required in the report.


Final output:

We achieved our desired result. There were five inventory dimensions selected, so five columns are shown.



That's it for this blog. See you in the next blog. Please comment if you have any suggestions about the use of Inventory dimension details in any other reports.

Happy Learning! 
By Neeraj Kumar

Comments

Post a Comment