Create a custom dialog on form opening and have a customer lookup for a specific financial dimension in D365 F&O. | Stoneridge Software

PHOTO EMBED

Wed Oct 30 2024 08:36:26 GMT+0000 (Coordinated Universal Time)

Saved by @pavankkm #csharp

/// <summary>
    /// This is the custom lookup code for the LocationSite financial dimension field on the user prompt dialog
    /// </summary>
    /// <param name = "_control"></param>
    private void dimLookup(FormStringControl _control)
    {
        
        Query query = new Query();
        QueryBuildDataSource qbdsDimensionFinancialTag = query.addDataSource(tableNum(DimensionFinancialTag));
        QueryBuildRange qbrFinancialTagCategory = qbdsDimensionFinancialTag.addRange(fieldNum(DimensionFinancialTag, FinancialTagCategory));
        qbrFinancialTagCategory.value(strFmt('%1', DimensionAttribute::findByName(dimName, false).financialTagCategory()));

        SysTableLookup sysTableLookup = sysTableLookup::newParameters(tableNum(DimensionFinancialTag), _control,true);
        sysTableLookup.addLookupfield(fieldNum(DimensionFinancialTag, Value), true);
        sysTableLookup.addLookupfield(fieldNum(DimensionFinancialTag, Description));
        sysTableLookup.addSelectionField(fieldNum(DimensionFinancialTag, FinancialTagCategory));
        sysTableLookup.parmQuery(query);

        sysTableLookup.performFormLookup();
    }
content_copyCOPY

https://stoneridgesoftware.com/create-custom-dialog-on-form-with-customer-lookup-for-a-specific-financial-dimension-in-d365-finops/