X++ code to show price and discount percentage when user select item id from fromstring control and clicked on getData button in actionpane


link : https://alexdmeyer.com/2022/02/01/how-to-use-temp-tables-as-grid-datasources-for-data-analytics-in-d365fo/


[Form]

public class BAS_PriceandDiscount extends FormRun

{

    



    [DataSource]

    class BAS_PriceandDiscounts

    {

        /// <summary>

        ///

        /// </summary>

        public void init()

        {

            super();

            BAS_PriceandDiscounts.linkPhysicalTableInstance(BAS_PriceandDiscounts);

        }


        /// <summary>

        ///

        /// </summary>

        public void executeQuery()

        {

            //RetailPricingSimulatorSalesLine retailSimulator;

            RetailDiscountLineOffer discountLine;

            RetailGroupMemberLine memberLine;

            InventTable inventTable;

            EcoResProduct ecoResProduct;

            BAS_PriceandDiscounts Priceanddiscounts;

            delete_from BAS_PriceandDiscounts;


            FormStringControl itemNumber = this.formRun().design().controlName("ProductNumber");

            while select * from discountLine 

                join memberLine where discountLine.RetailGroupMemberLine == memberLine.RecId 

                join ecoResProduct where ecoResProduct.RecId == memberLine.Product

                && ecoResProduct.DisplayProductNumber == itemNumber.text()

            {

                

                select * from inventTable where inventTable.ItemId == itemNumber.text();

                real price= inventTable.salesPcsPrice() - (inventTable.salesPcsPrice() * (discountLine.discPct / 100));

                ttsbegin;

                BAS_PriceandDiscounts.Price         = price;

                BAS_PriceandDiscounts.Discount      = discountLine.discPct;

                BAS_PriceandDiscounts.OriginalPrice = inventTable.salesPcsPrice();

                BAS_PriceandDiscounts.insert();

                ttscommit;

            }

            super();

        }


    }


    [Control("Button")]

    class GetData

    {

        /// <summary>

        ///

        /// </summary>

        public void clicked()

        {

            BAS_PriceandDiscounts_ds.executeQuery();

            super();

           

            

        }


    }


}

Comments

Post a Comment

Popular posts from this blog

how to post trade agreement journals automatically using x++ code

  In Microsoft Dynamics AX, you can post trade agreement journals automatically using X++ code. Here are the steps to do so: Create a new job in X++. Write a code to fetch data from the trade agreement table. Create a journal header and journal lines based on the fetched data. Call the post() method of the journal header to post the journal. Repeat steps 2 to 4 for each trade agreement. Here's a sample code in X++: static void postTradeAgreementJournals(Args _args) { TradeAgreementTable tradeAgreementTable; GeneralJournalHeader generalJournalHeader; GeneralJournalLine generalJournalLine; // Fetch data from the Trade Agreement table select tradeAgreementTable where tradeAgreementTable.JournalPosting == NoYes::No; // Loop through each trade agreement while (tradeAgreementTable) { // Create a journal header generalJournalHeader = new GeneralJournalHeader(); generalJournalHeader.initValue(); generalJournalHeader.tra...
Read more

How to Create a wizard in x++ d365

Image
 step1: Create a form and apply form pattern as wizard step2 : create a class and extend the class with SysWizard. code :            class BAS_WIzardScreen extends SysWizard {     #MACROLIB.AviFiles     FormName formname()     {         return formstr(BAS_WIzardForm);  // name of the wizard form     }     public void run()     {         info(strFmt("Thankyou"));     }     public void setupNavigation()     {     }     public boolean validate()     {         return true;     }     public static str description()     {         return "BASOFA WIZARD";  // title of the wizard     }     public static void main(Args _args)     {         BAS_WIzardScreen wizard = new BAS_WIz...
Read more

x++ code to submit and approve and reject the invent movement workflow in d365 F&O

 class Class1 {     public  void submitworkflow()     {         InventJournalTable journalTable;     WorkflowWorkItemTable   WorkflowWorkItemTable;    WorkflowVersionTable        workflowVersionTable;                journalTable = InventJournalTable::find('00446');               // submit to workflow         if (journalTable.WorkflowApprovalStatus == InventJournalWorkflowApprovalStatus::NotSubmitted)         {             Workflow::activateFromWorkflowType(workFlowTypeStr(InventJournalMovementTemplate), journalTable.RecId,                                     'Workflow submitted by button', false, Curuserid());         }    ...
Read more