How can the Map Entity be overridden to Data Source, and when can it be used?
How to Override Map Entity to Data Source in D365 F&O MapEntityToDatasource(): It maps the fields from the staging table to the data source used in the entity. Used more for import operations. Purpose: Whenever we are exporting the data and trying to import it for another legal entity in the Excel sheet, we don’t […]
How to convert UTC Date Time to String using X++?
How to convert UTC Date Time to String using X++? Purpose: Whenever a user creates a record with a UTC Date Time value, the exact time may not be displayed correctly in SQL. To retrieve the precise time, we convert the UTC Date Time value to a string format. High Resolution steps Detailed Resolution steps: […]
How to Use Unmapped String Control and Override the Post-Load Method in Data Entities?
How to use unmapped string control and override post load method in data entities? Scenario: Creating the unmapped control (virtual field) in the data entity and when exported the data entity implementing the business logic for the field control. High Resolution steps Detailed Resolution steps Step 1: Create the data entity with the virtual field. Navigation: […]
How to Enable the Row Version from Finance and Operations and Power Apps.
How to enable the row version from Finance and Operations and Power Apps. Scenario: Enabling the Row Version Tracking property in Finance and Operations, along with tracking changes in Power Apps, facilitates data synchronization by ensuring accurate and consistent updates across systems. High Resolution steps Detailed Resolution steps Step 1: Create the table with the row […]
How to write a Dynamic Query in DP Class to Fetch all the Data if there is no Report Parameter?
How to write dynamic query in DP class to fetch all the data if there is no Report Parameter? Scenario: If the user does not specify any parameters in the report, it should display all records by default. High Resolution steps Detailed Resolution steps Step 1: SCEContractDPReportDP Process report() Code: Code Snippet: public void processReport() […]
How to Purge any Files from Azure Blob Storage Container using X++?
How to purge any files from Azure blob storage container using X++? Scenario: User needs to access the storage container files to delete them from D365 F&O. Here, in this scenario I am explaining step by step how we can delete the container files using X++ code. High Resolution steps Detailed Resolution steps Step 1: Create […]
How to Utilize the Table Properties in X++?
How to utilize the table properties in X++? Scenario: When a user creates a table, it is necessary to set the appropriate table properties to ensure data integrity, improve performance and enhance overall usability. High Resolution steps Detailed Resolution steps: Step 1: Create a field in the table and set its extended data type to […]