Creation of multiple PO and posting invoices for the same through X++

 Upon a clicking a button POs will be creating and posting invoices by using data which are stored in custom table (Mandatory data have been stored in data source)

On Clicked():-

 [Control("Button")]

    class BASPostButton

    {

        /// <summary>

        ///

        /// </summary>

        public void clicked()

        {

            BASPurchaseOrderEntity purchOrder;

            while  select * from purchOrder

            {

            //Data entity declaration  

            PurchPurchaseOrderHeaderV2Entity  purchTable;     

            PurchPurchaseOrderLineV2Entity    purchLine;      

            //Create Purchase header     

            purchTable.initValue();     

            purchTable.OrderVendorAccountNumber    = purchOrder.VendorAccount;     

            purchTable.insert();   

 


            //Fetching PurchId to create lines    

            PurchId purchid = purchTable.PurchaseOrderNumber;     

            //Create Purchase lines        purchLine.initValue();    

            purchLine.PurchaseOrderNumber         = purchid;      

            purchLine.ItemNumber                  = purchOrder.ItemNumber;    

            purchLine.OrderedPurchaseQuantity     = purchOrder.Qty;  

            purchLine.PurchasePrice               = purchOrder.UnitPrice;

            purchLine.ReceivingSiteId             = purchOrder.Site;     

            purchLine.ReceivingWarehouseId        = purchOrder.Warehouse;     

            purchLine.insert();          

            Info(strFmt("Purchase order %1 has been created.",purchTable.PurchaseOrderNumber));     

            //Update PO by using PurchFormLetter class      

            PurchFormLetter   purchFormLetter;

     

            // Get Purchase Order      

            PurchTable PurchUpdate   = PurchTable::find(purchId);  

   

            //Posting PO Confirmation  

            purchFormLetter = PurchFormLetter::construct(DocumentStatus::PurchaseOrder);    

            purchFormLetter.update(PurchUpdate, strFmt("PO_%1", purchTable.PurchaseOrderNumber));  

            info(strFmt("Purch Order %1",purchTable.PurchaseOrderNumber));

            ;        

            //Posting Product receipt    

            purchFormLetter = PurchFormLetter::construct(DocumentStatus::PackingSlip);     

            purchFormLetter.update(PurchUpdate, strFmt(purchOrder.ProductReceiptNumber));

            info(strFmt("Product receipt  Posted for %1",purchOrder.ProductReceiptNumber));  

               

            ;    

            //Posting PO Invoice      

            purchFormLetter = PurchFormLetter::construct(DocumentStatus::Invoice);     

            purchFormLetter.update(PurchUpdate, strFmt(purchOrder.InvoiceNumber),

            DateTimeUtil::date(purchOrder.InvoiceDate));     

            info(strFmt("Invoice posted for %1",purchOrder.InvoiceNumber)); 

            info(strFmt("Invoice Date for %1", purchOrder.InvoiceDate));

           //Updating created PO Ids as well 

               ttsbegin;

                purchOrder.selectForUpdate(true);

            purchOrder.PurchaseOrder = purchid;

            purchOrder.update();

                ttscommit;


                BAS_CreatePurchaseOrder_ds.research();

                BAS_CreatePurchaseOrder_ds.refresh();


         

            }


          

            super();


        }

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