X++ code to create purchase order manually in D365 F&O

  

Using NumberSequence we can create purchid automatically but this is old method of doing

         NumberSeq   numberSeq;

        PurchTable  purchTable;

        PurchLine   purchLine;

        ;

    

        ttsBegin;

        // geting number sequence

        numberSeq = NumberSeq::newGetNum(PurchParameters::numRefPurchId());

        numberSeq.used();

        // Asign purch id

        purchTable.PurchId = numberSeq.num();

        // calling table initvalue method

        purchTable.initValue();

        // find the vendor account

        purchTable.initFromVendTable(VendTable::find('1001'));

        // validation

        //if (!purchTable.validateWrite())

        //{

        //    throw Exception::Error;

        //}

        //// insert data


        purchTable.InventSiteId= 'DC';

        purchTable.InventLocationId= 'DC';

        purchTable.insert();


        //purchLine.clear();

        purchLine.initValue();

        purchLine.PurchId   = purchTable.PurchId;

        purchLine.ItemId    = '0001';

       

        // Purch line creation

        purchLine.createLine(true, true, true, true, true, true);

        ttsCommit;

        info(strFmt("Purchase order '%1' has been created",purchTable.PurchId));



                                             or 


Using Data entities also we can do this (Prefered way of doing)


class BASPurchOrderCreation

{

    public static void main(Args _args)

    {

        PurchPurchaseOrderHeaderV2Entity    purchPurchaseOrder;

        PurchPurchaseOrderLineV2Entity        purchPurchaseOrderLine;

        //Header creation

        purchPurchaseOrder.initValue();

        purchPurchaseOrder.OrderVendorAccountNumber='1001';

        purchPurchaseOrder.insert();


        PurchId purchId = purchPurchaseOrder.PurchaseOrderNumber;


        //Line creation

        purchPurchaseOrderLine.initValue();

        purchPurchaseOrderLine.PurchaseOrderNumber=purchId;

        purchPurchaseOrderLine.ItemNumber='0001';

        purchPurchaseOrderLine.ReceivingSiteId='DC';

        purchPurchaseOrderLine.ReceivingWarehouseId='DC';

        purchPurchaseOrderLine.insert();


        info(strFmt("Purchase Order number is %1",purchPurchaseOrder.PurchaseOrderNumber));      

    }


}

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