Deploy SSRS reports through Windows Powershell in Dynamics 365 Finance and Operations

Introduction:

In this blog, we will see how to deploy SSRS reports in Microsoft Dynamics 365 Finance and Operations  

Solution: 

For on-prem environment, we will open Windows PowerShell in administrator mode and run the below scrip step by step.

cd C:\AOSService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\

.\DeployAllReportsToSsrs.ps1

For online Cloudhosted/Dev environment, we will run below mentioned script

cd k:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\

.\DeployAllReportsToSSRS.ps1 -PackageInstallLocation "k:\AosService\PackagesLocalDirectory"

It appears as

When deploying reports are completed, It looks like

Thanks for reading !!!

Duplicate address record entry through Data entity in Dynamics 365 Finance and Operations

Introduction:
In this blog, we will see how to allow system for accepting duplicate addresses of customer, vendor or any other, through doing bit change in Data Entity 

Solution:
For allowing duplicate entries we will create one field in LogisticsPostalAddress. Here field name is as IsCreateFromEntity. Field-IsCreateFromEntity will be used as flag, type of boolean / NoYesId (EDT).

[ExtensionOf(tableStr(LogisticsPostalAddressBaseEntity))]
final class LogisticsPostalAddressBaseEntityCFSJSTable_Extension
{
    public static LogisticsLocationId resolveRemittanceAddressLocationId(LogisticsPostalAddressBaseEntity _postalAddressEntity, DirPartyNumber _partyNumber)
    {
        LogisticsLocationId locationId, locationIdCreateNew;

        locationId = next resolveRemittanceAddressLocationId(_postalAddressEntity, _partyNumber);

        if(_postalAddressEntity.IsCreateFromEntity)
        {
            locationId = locationIdCreateNew;
        }

        return locationId;
    }
}

Aforementioned code would replace the standard locationId variable with new locationIdCreateNew which will be null always. Once new variable locationIdCreateNew is replaced with standard code,  system will generate the new locationId in the LogisticsLocation(Table) and create the same duplicate address along with state, city, country, zipcode and all other respective fields.

Moreover, we will just need to pass YES value to the newly created field ISCreateFromEntity while creating the new address and run the execution. How easy it is!!!

Thanks for reading !!!

List of security roles for current user | D365FO

Introduction:

In this blog, we will see how we can get list of security roles assigned to a current user  

Solution: 

UserInfo         userInfo;
SecurityRole     securityRole;
SecurityUserRole securityUserRole;

while select securityRole
    exists join securityUserRole
        where securityUserRole.SecurityRole == securityRole.RecId 
    exists join userInfo
        where userInfo.id == securityUserRole.User 
        &&    userInfo.id == curUserId()
{
    info(securityRole.name);
}

Thanks for reading !!!

Table browser extension for Google Chrome | D365

Now table browser becomes much easier for Microsoft Dynamics 365 Finance and Operations. Here you go with Google Chrome Extension - Table browser caller for D365FO. It's very easy to install and use it. After installing the extension to the browser, it appears on the top bar and looks like



While clicking on the extension, You can find the tab named with config where you need to put the URL of the respective environment and save it.

Once config is setup, you need to go to the main tab that is Table Browser Caller as shown in above figure where you would setup mainly: 

• Search for table name: name of the table
• Company Id: name of the legal entity 

After that, you need to find the table in the search box and just press the Enter key.



And you will be redirected to the table in the new tab. 

In addition, Table browser has also few other features like

• Browse all table lists 
• Browse all data entities  

1. For getting the list of tables you need to click on Table list:

Result as, 

2. For getting the list of data entities you need to click on Data entities: 

Result as,