Creation of Trade agreement journal for Purch through X++ code

 Create a class :- 

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