Create a custom lookup for the purchase agreement of the vendor selected

-

 Today we have a requirement to create a a custom look up for the purchase agreement for the vendor which is selected


1) Create a custom lookup on the table level 

2) Call on the form 


1) create a custom lookup for the purchase agreement  


/// <summary>

    /// look up for Purchase Agreement against the vendor

    /// </summary>

    static void ihslookupVendPurchaseAgreement(FormStringControl _callingControl, VendAccount _vendAccount)

    {

        Query                   query = new Query();

        QueryBuildDataSource    queryBuildDataSource;

        QueryBuildRange         qbrVendAccount, qbrAgreementState, qbrBuyingLegalEntity;

        VendAccount             vendAccount;

        PurchAgreementHeader    purchAgreementHeader;

        CompanyInfo             companyInfo =    CompanyInfo::findByCompany_IN(curExt());


        select purchAgreementHeader

            where purchAgreementHeader.VendAccount == _vendAccount

                && purchAgreementHeader.BuyingLegalEntity == companyInfo.RecId;


        SysTableLookup          sysTableLookup = sysTableLookup::newParameters(tableNum(PurchAgreementHeader), _callingControl);

    

        sysTableLookup.addLookupField(fieldNum(PurchAgreementHeader, PurchNumberSequence));

        sysTableLookup.addLookupfield(fieldNum(PurchAgreementHeader, DocumentTitle));

        sysTableLookup.addLookupField(fieldNum(PurchAgreementHeader, VendAccount));

        sysTableLookup.addLookupMethod(tableMethodStr(PurchAgreementHeader, vendName));

        sysTableLookup.addLookupField(fieldNum(PurchAgreementHeader, AgreementState));


        queryBuildDataSource = query.addDataSource(tableNum(PurchAgreementHeader));


        qbrVendAccount = queryBuildDataSource.addRange(fieldNum(PurchAgreementHeader, VendAccount));

        qbrVendAccount.value(_vendAccount);


        qbrAgreementState = queryBuildDataSource.addRange(fieldNum(PurchAgreementHeader, AgreementState));

        qbrAgreementState.value(enum2Str(AgreementState::Effective));


        qbrBuyingLegalEntity = queryBuildDataSource.addRange(fieldNum(PurchAgreementHeader, BuyingLegalEntity));

        qbrBuyingLegalEntity.value(int642Str(companyInfo.RecId));


        sysTableLookup.parmQuery(query);

        sysTableLookup.performFormLookup();

    }


======================================================================


Call the above method on form control level


[ExtensionOf(formControlStr(EntAssetWorkOrderTable, IHSEWasteManagementGroup_PurchAgreement))]

Final class IHSEntAssetWorkOrderTableFrm_EWastePurchAgreementCtrl_Extension

{

    public void lookup()

    {

        FormStringControl    eWasteManagement_fsc   = any2Object(this) as FormStringControl;

        FormDataSource       eWasteManagement_ds = eWasteManagement_fsc.formRun().dataSource(tableStr(IHSEWasteManagement));

        IHSEWasteManagement  eWasteManagement = eWasteManagement_ds.cursor();


        next lookup();

     

        IHSEWasteManagement::ihslookupVendPurchaseAgreement(this, eWasteManagement.VendAccountNum);

    }


}

Comments

Post a Comment

Popular posts from this blog

Customization on Sales invoice Report in D365 F&O

-
 We have a requirement to create a new design and show some new fields in the sales invoice report.  So for that we need to consider the below steps :-  1) Controller class than extends standard class and create alogic. 2) Create a print management class to call the new design. 3) Extension of DP class to write a logic. 4) Report design. ==================================================================== 1) Controller class : -  /// <summary> /// Extension of the controller class to call the custom design of report "MMSSalesInvoice.report" for MMS legal entity. /// </summary> class MMSSalesInvoiceController extends SalesInvoiceController {        public static MMSSalesInvoiceController construct()         {             return new MMSSalesInvoiceController();         }         public static void main(Args _args)         { ...
Read more

75) COC - Create a coc of the table modified method

-
 /// <summary> /// The <c>AvaEntAssetChecklistVariableOptionsDbt_Extension</c> contains the TransMountain extending logic for the <c>EntAssetChecklistVariableOptions</c> table. /// </summary> [ExtensionOf(tableStr(EntAssetChecklistVariableOptions))] final class AvaEntAssetChecklistVariableOptionsDbt_Extension {     /// <summary>     /// Processes the modified field event for TransMountain fields.     /// </summary>     /// <param name = "_fieldId">reference to field id</param>     public void modifiedField(FieldId _fieldId)     {         EntAssetChecklistVariableOptions entAssetChecklistVariableOptions;         next modifiedField(_fieldId);         // Default must be marked for only one check list line for the varaible.         if (_fieldId == fieldNum(EntAssetChecklistVariableOptions,...
Read more

46) D365 FO: SHAREPOINT FILE UPLOAD USING X++

-
Image
Requirement : Uploading a file in Sharepoint online using X++ and inside from Microsoft Dynamics 365 finance and operations. Prerequisites: The current user id of Microsoft Dynamics 365 Finance and operations should have proper rights and privileged in Sharepoint Online. Sample Code: In this scenario i am creating a text file in Microsoft Dynamics 365 finance and operations and then uploading its memory Stream in Sharepoint online using X++ . You can modify the X++ code in D365 finance and operations as per your need. class RunnableClassRun { /// /// Runs the class with the specified arguments. /// /// The specified arguments. public static void main(Args _args) { System.UriBuilder builder = new System.UriBuilder(“ https://XXXXXX.sharepoint.com&#8221 ;); str extId = xUserInfo::getExternalId(); Microsoft.Dynamics.AX.Framework.FileManagement.SharePointDocumentStorageProvider provider; Microsoft.Dynamics.AX.Framework.FileManagement.DocumentLocation documentLocation ...
Read more