Copy value from Sales Quote to Sales Order

Question

Hello Everyone,I have override the Convert To Order action in the Sales Quotes screen, and copying the line field value from the Sales Quote to Sales Order line with the below code.Value are getting copied properly but caches are not updating as expected, when try to edit any other value and try to save it is giving me an error. Here is the code, can anyone review and share your thoughts. [PXOverride] public IEnumerable createSalesOrder(PXAdapter adapter, Func baseMethod) { SOOrderEntry SOGraph = PXGraph.CreateInstance(); PXGraph.InstanceCreated.AddHandler(delegate (SOOrderEntry graph) { graph.RowUpdated.AddHandler(delegate (PXCache sender, PXRowUpdatedEventArgs e) { SOLine objSOLine = e.Row as SOLine; if (objSOLine != null) { foreach (CROpportunityProducts item in Base.Products.Select().FirstTableItems.ToList().Where(x => x.InventoryID == objSOLine.InventoryID)) { if (item.POCreate == true) { sender.SetValueExt((object)objSOLine, true); sender.SetValueExt((object)objSOLine, "D"); } } } }); }); return baseMethod(adapter); }

nsmith51 · Accepted Answer

Here is the code, finally I figured it out!!


  public class QuoteMaintExt : PXGraphExtension<QuoteMaint.CRCreateSalesOrderExt, QuoteMaint>
    {
        public static bool IsActive() => true;

		  [PXOverride]
        public IEnumerable createSalesOrder(PXAdapter adapter, Func<PXAdapter, IEnumerable> baseMethod)
        {
            PXGraph.InstanceCreated.AddHandler(delegate (SOOrderEntry graph)
            {
                graph.RowUpdated.AddHandler<SOOrder>(delegate (PXCache sender, PXRowUpdatedEventArgs e)
                {
                    SOOrder objSOOrder = e.Row as SOOrder;
                    if (objSOOrder != null)
                    {
                        // ==> the below code is for to copy the Header Quote fields to Sales Order Header fields
                        sender.SetValue<SOOrderExt.usrHeaderNotes1>((object)objSOOrder, objQuoteExt.UsrHeaderNotes1);
                        sender.SetValue<SOOrderExt.usrHeaderNotes2>((object)objSOOrder, objQuoteExt.UsrHeaderNotes2  );

                    }
                });

                graph.RowUpdated.AddHandler<SOLine>(delegate (PXCache sender, PXRowUpdatedEventArgs e)
                {
                    SOLine objSOLine = e.Row as SOLine;
                    if (objSOLine != null)
                    {
                        SOLineExt objLineExt = objSOLine.GetExtension<SOLineExt>();
                        foreach (CROpportunityProducts item in Base.Products.Select().FirstTableItems.ToList().Where(x => x.InventoryID == objSOLine.InventoryID))
                        {


						   // ==> Below code is copy to Quote line items to Sales Order line items
                            CROpportunityProductsExt objItemExt = item.GetExtension<CROpportunityProductsExt>();

                            sender.SetValue<SOLineExt.usrNotes1>((object)objSOLine, objItemExt.UsrNotes1);
                            sender.SetValue<SOLineExt.usrNotes2>((object)objSOLine, objItemExt.UsrNotes2);
                            sender.SetValue<SOLineExt.usrNotes3>((object)objSOLine, objItemExt.UsrNotes3);

                        }
                    }
                });

            });
            return baseMethod(adapter);
        }


    }

JWS539 · Answer

Hi nsmith51,Thanks so much for your solution.Being able to add an event handler toa Graph instance programmatically is something I didn’t even know you could do. Have replicated in one of my customisations. Works a treat!

Copy value from Sales Quote to Sales Order

3 replies

Reply

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded