X++ code to process the multiple selected data from a form with multiple selected helper class

  Requirement :- Create a trade agreement journal with multiple lines. For this you have to create a button called post in custom page form and create multiple lines in that form select all created lines 

and click button upon clicking button the trade agreement journal needs to be created.

Code :-

class BASTradeJournal

{

    public static void main(Args _args)

    {

        // BASTradeAgreementTable tradeAgreementTable = _args.record();

        BASTradeAgreementTable tradeAgreementTable;

        MultiSelectionHelper selectHelper = MultiSelectionHelper::createFromCaller(_args.caller());


        InventDim               inventDim;

        InventTrans             inventTrans;

        InventDimId             inventDimId;

        PriceDiscAdmTable       priceDiscAdmTable;

        PriceDiscAdmTrans       priceDiscAdmTrans;

        PriceDiscAdmCheckPost   priceDiscAdmCheckPost = new PriceDiscAdmCheckPost(false);

        PriceDiscAdmName        priceDiscAdmName = PriceDiscAdmName::find('Purch');

        try

        {

            // Create Journal number

            ttsbegin;

            priceDiscAdmTable.clear();

            priceDiscAdmTable.initFromPriceDiscAdmName(priceDiscAdmName);

            priceDiscAdmTable.insert();

            ttscommit;

            tradeAgreementTable = selectHelper.getFirst();

            while(tradeAgreementTable)

            {

                // Create Journal line

                ttsbegin;

                priceDiscAdmTrans.clear();

                priceDiscAdmTrans.JournalNum    = priceDiscAdmTable.JournalNum;

                priceDiscAdmTrans.AccountCode   = PriceDiscPartyCodeType::All;

                priceDiscAdmTrans.ItemCode      = PriceDiscProductCodeType::Table;

                priceDiscAdmTrans.ItemRelation  = tradeAgreementTable.ItemId;


                //Fetching inventdimId

                select firstonly inventDimId from inventTrans

                        join inventDim

                        where inventDim.inventDimId == inventTrans.inventDimId

                        && inventDim.InventSiteId == tradeAgreementTable.InventSiteId

                        && inventDim.InventLocationId == tradeAgreementTable.InventLocationId

                        && inventTrans.ItemId == tradeAgreementTable.ItemId;


                priceDiscAdmTrans.LineNum            = 1;

                priceDiscAdmTrans.Currency           = "USD";

                priceDiscAdmTrans.InventDimId        = inventTrans.inventDimId;

                priceDiscAdmTrans.Amount             = tradeAgreementTable.Price;

                priceDiscAdmTrans.UnitId             = tradeAgreementTable.UnitOfMeasureSymbol;

                priceDiscAdmTrans.QuantityAmountFrom = tradeAgreementTable.FromQty;

                priceDiscAdmTrans.PriceUnit          = 1;

                priceDiscAdmTrans.relation           = PriceType::PricePurch;

                priceDiscAdmTrans.FromDate           = tradeAgreementTable.FromTransDate;

                priceDiscAdmTrans.ToDate             = tradeAgreementTable.ToTransDate;

                priceDiscAdmTrans.DisregardLeadTime  = NoYes::Yes;

                priceDiscAdmTrans.insert();

                ttscommit;

                tradeAgreementTable = selectHelper.getNext();

            }


                //Check if journal created

                if(priceDiscAdmTable && priceDiscAdmTrans)

                {

                    Info(strFmt('Created Journal number %1', priceDiscAdmTable.JournalNum));

                    if(!priceDiscAdmCheckPost.checkJournal()) //Determines whether the price and discount agreement journal contains warnings.

                    {

                        priceDiscAdmCheckPost.initJournalNum(priceDiscAdmTrans.JournalNum);

                        priceDiscAdmCheckPost.run(); //Checks and posts the price and discount agreement journal.

                        Info(strFmt('Posted Journal number %1', priceDiscAdmTable.JournalNum));

                    }

                }

            

        }

        catch(Exception::CLRError)

        {

            error(enum2Str(Exception::CLRError));

        }

            

    }


}

Comments

Post a Comment

Popular posts from this blog

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

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

X++ code to CREATE AND POST A TRADE AGREEMENT IN MICROSOFT DYNAMICS 365 in D365 F & O

Reuirement : I have to create a table called BASTradeAgreementTable with fields like following Item number Product Name ToDate FromDate InventSiteId InventLocationId Amount From Unit Step2: After Creating Table I have to create a form and add the created table into the form datasource and add all the fields of that datasource to form grid. I have to create a button called Post whenever user clicks on that button i have to create and post Trade Agreement Journals with the data provided in the form grid. [Control("Button")]     class Post     {         /// <summary>         ///         /// </summary>         public void clicked()         {             int             recordsCount;              BASTradeAgreementTable    tradeAgreement;     ...
Read more