Populate Grid in X++

If you to populate the grid through code, You must create a temp table in the project.

1- For creating the temp table, filter any temp table in AOT like BOMCalcTransTmp Table.

2- Duplicate the BOMCalcTransTmp table in the project and change the name of the table and the fields of the table as you like.

3- Now add the temp table BOMCalcTransTmp in the Datasource field of the grid.

4- Now the main part is how to populate the grid. You can populate the grid on the init() method or on the button clicked method as shown in the code below;

5- Kindly make the temp table BOMCalcTransTmp table-type InMemory.

BOMCalcTransTmp bomCalcTransTmp;

                while Select bOMCalcTrans where bOMCalcTrans.CalcType == ItemCalcType::Process

                {

                    bomCalcTransTmp.clear();


                    bomCalcTransTmp.CalcType = bOMCalcTrans.CalcType;

                    bomCalcTransTmp.CostGroupId = bOMCalcTrans.CostGroupId;

                    bomCalcTransTmp.Resource = bOMCalcTrans.Resource;

                    bomCalcTransTmp.UnitIdBOMCalcTrans = bOMCalcTrans.UnitId;

                    bomCalcTransTmp.Level = bOMCalcTrans.Level;

                    bomCalcTransTmp.Oprid = bOMCalcTrans.Oprid;

                    bomCalcTransTmp.ConsumptionSum = bOMCalcTrans.consumptionSum();

                    bomCalcTransTmp.CostPricePcsBOMCalcTrans = bOMCalcTrans.costPricePcs();

                    bomCalcTransTmp.CostPriceSumBOMCalcTrans = bOMCalcTrans.costPriceSum();

                    bomCalcTransTmp.DisplayDescription = bOMCalcTrans.displayDescription();

                    bomCalcTransTmp.SalesPricePcsBOMCalcTrans = bOMCalcTrans.salesPricePcs();

                    bomCalcTransTmp.SalesPriceSumBOMCalcTrans = bOMCalcTrans.salesPriceSum();

                  bomCalcTransTmp.insert();

                    }

             SLDBOMCalcTransTmp.setTmpData(bomCalcTransTmp);

        this.formRun().design().controlName("CostGroupDetailGrid").dataSourceObject().executeQuery();

        

5- When the grid is open, then it populates with the fields.


Happy Coding.

Feel free to comment and share.

Comments

Post a Comment

Popular posts from this blog

Create custom workflow in D365 X++

Image
 For the creation of Custom Workflow in Dynamics 365 F&O, Kindly follow the following steps; 1. Create a custom Enum WorkflowStatus or you can use an existing one.   2. Create a new table EmployeeLeave as defined below and add the above Enum as a field and name it LeaveStatus . 3. Create a new form EmployeeLeaveForm by using the above table as a data source.   4. Create a new Display Menu Item EmployeeLeaveForm for the above form and add to any  Module by creating an extension of the Module Menu from the application Explorer. 5. Create a new Query EmployeeLeaveQuery  and add  EmployeeLeave as a data source.                 6. Create a new Workflow Category EmployeeLeaveCategory .   7. Create a new workflow type EmployeeLeaveWorkflowType .   • Category: Select the workflow category from the previous step • Query: Select the query created for the document table • Document menu item: Sel...
Read more

Convert amount from one currency to another currency using X++

  You can use the following X++ code snippet for currency amount conversion.     CurrencyExchangeHelper currencyExchangeHelper;     AmountMst amountMST;     CurrencyCode FromCurrency =  'PKR';     AmountCur amountCur = 5000;     currencyExchangeHelper = CurrencyExchangeHelper::newExchangeDate(Ledger::current(), systemDateGet());     amountMST =  currencyExchangeHelper.calculateCurrencyToCurrency(fromCurrency, SLDFabCostSheetsCalculation.Currency,amountCur,true);        info(strFmt("%1", amountMST));
Read more

How to Create Extended Data Types (EDTs) in Finance and Operations of Dynamics 365 -- F&O Customization Part 2

Image
For Creating Extended Data Types (EDTs) in Finance and Operations of Dynamics 365 follow the following steps: Step # 1:        Right-click on the project to Add -> New Items as shown in the figure;     When you click the New Item ,  the new window is open as shown in the figure;     Select the Data Types from the Side Bar and click on the Add button as shown in the figure; Step # 2:          Now right click on the EDT and select the Properties as shown in the figure;               When you click the Properties button, the left panel is open, you can set the properties of EDT here,           mostly used properties are Label and Help Test. I have created four EDTs as shown in the figure;           You can check the EDTs in the Application Object Tree ( AOT ) as shown in the figure;          If ...
Read more