EXCEL Add-in D365 FO

EXCEL add-in USED FOR D365 DATA ENTITY

To use excel add-in for D365 data entities for CRUD operations. You can easily follow below mentioned steps:

1. Open Excel from any Desktop or VM and click on Add-ins option under insert tab:

2. Check if you have Microsoft Dynamics Office Add-ins, If not then download it from Microsoft store:

3. If you have above mentioned Add-in click on this and click add server information:

4. In server URL add your environment URL either dev, UAT or PROD and click OK. for e.g: (https://xxxxxxxxxxxxxxxxxxx.dynamics.com/)

5. Click on Design button and it will display below mentioned screen:

6. Click on Select entity data source and choose your desired data entity from list on which you need to perform CRUD operations and click on NEXT:

7. Double click on each field present in AVAILABLE FIELD SECTION to get them in SELECTED FIELD SECTION:

8. Click on Refresh Once and you will be able to see data in your entity in Excel:

9. After making changes to your data, click on the button on right PUBLISH so that your changes will be made to the entity:

HEY HEY HEY!! HACK OF THE DAY!!

Always make sure that your cursor should be on row A1 before clicking on the button REFRESH to get entity data.

Comments

Edit Method on Form

Edit Method D365 for a form Data Source 1. To create an edit method first create a controller class. with following properties public static edit MainAccountNum LedgerJournalTransLedger(LedgerJournalTrans _ledgerjournal, boolean _set, MainAccountNum _id) { MainAccountNum accountId = _id; MainAccount mainAccount = MainAccount::findByMainAccountId(_id); if(_set) { if(_ledgerjournal.AccountType== LedgerJournalACType::Ledger) { mainAccount = MainAccount::findByMainAccountId(accountId); if(_ledgerjournal.LedgerDimension) { DimensionDefault defaultDim = LedgerDimensionFacade::getDefaultDimensionFromLedgerDimension(_ledgerjournal.LedgerDimension); _ledgerjournal.LedgerDimension = LedgerDimensionDefaultingEngine::getLedgerDimensionFromAccountAndDim(mainAccount.RecId, DimensionHierarchy::getAccountStructure(mainAccount.RecId), defaultDim); } else { _ledgerjournal.LedgerDimension = LedgerDimensionDefaultingEngine::getLedgerDimensionFromAccountAndDim(mainAccount.RecId, DimensionHierarchy::getAcc

Security Objects In D365

PRIVILEGES, DUTIES AND ROLES IN D365 FinOps To add customize security privilege, duty and role you should follow this flow because it is considered as the best practices Role---> Duty---->Privilege Duty and Privilege would be created at the back end and where as role would be created at front end 1. create privilege from solution explorer in a project and add new entry point for output, display or action menus to refer in privilege that for which entity we have to give privilege to the user 3. Now Create a duty from solution explorer same as privilege and add this new created privilege to the duty Now you can refer this duty to the role created on the front end. HEY HEY HEY !!!! HACK OF THE DAY !! THE HIGHEST ACCESS LEVEL FOR ACTION MENU ITEM IS DELETE

Deep Links

DEEP LINKS FOR SALES ORDERS In this blog we will discuss about generating deep links for any form , record or datasource. Deep links are basically termed for generating URL's through code for any specific record in D365. Using Deep links other environments can access D365 records by using this URL generated from it. 1. In below blog I am creating Deep links for sales order header record. 2. To Access these links one should always be added the user in FinOps to access through URL. Step #1 Create and extension class of URLUtility class and also add following code snippet to access this class : using Microsoft.Dynamics.AX.Framework.Utilities; using Microsoft.Dynamics.@Client.ServerForm.Contexts; public static str generateRecordUrl(str _menuItemName, MenuItemType _menuItemType, DataSourceName _dataSourceName, Map _indexFieldValuesMap, DataAreaId _dataAreaId = curExt()) { System.Uri host = SessionContext::Get_Current().Get_RequestUrl(); UrlHelper.UrlGenerator generator = new Url

TechYard

Search This Blog