Copy Custom Field Values from Shipment Line to Invoice Line and Copy Custom Field Values from Purchase Order Header to Purchase Receipt Header

Question

Hi I have 2 requirements,Copy Custom Field Values from Shipment Line to Invoice Line (SOShipLine → ARTran) Copy Custom Field Values from Purchase Order Header to Purchase Receipt Header (POOrder → POReceipt) How can I implement this? Is there a way I can use PXOverride and update the fields on invoice line creation and purchase receipt creation.For example this is an implementation I did for copying field values from sales order header to shipment header screen.public delegate void CreateShipmentDelegate(CreateShipmentArgs args); [PXOverride] public void CreateShipment(CreateShipmentArgs args, CreateShipmentDelegate baseMethod) { // Call the original method to ensure default behavior baseMethod(args); // Retrieve the current shipment and order SOShipment ship = Base.Document.Current; SOOrder order = args.Order; if (ship != null && order != null) { // Use the extension cache to access the custom fields SOShipmentExt shipExt = PXCache.GetExtension(ship); SOOrderExt orderExt = PXCache.GetExtension(order); // Update custom fields in the shipment header shipExt.UsrCommission = orderExt.UsrCommission; shipExt.UsrCustomerPickUp = orderExt.UsrCustomerPickUp; shipExt.UsrDuty = orderExt.UsrDuty; shipExt.UsrFreight = orderExt.UsrFreight; shipExt.UsrInsurance = orderExt.UsrInsurance; shipExt.UsrQtyShow = orderExt.UsrQtyShow; shipExt.UsrQtyNote = orderExt.UsrQtyNote; shipExt.UsrShippingTermsINCOTERM = orderExt.UsrShippingTermsINCOTERM; shipExt.UsrCurrencyTerms = orderExt.UsrCurrencyTerms; // Update and save the shipment header Base.Document.Update(ship); Base.Save.Press(); } } Thank you!

Naveen Boga · Accepted Answer

@TharidhiP Please use the below code to COPY the value from SOShipLine to ARTran and same way you try for other requirement as well.

  #region UsrAdditionalBox
   PXDBBool]
   PXUIField(DisplayName = "Test Box")]
   PXDefault(typeof(Search<SOShipLineExt.usrAdditionalBox,
                        Where<SOShipLine.shipmentType, Equal<Current<ARTran.sOShipmentType>>,
                        And<SOShipLine.shipmentNbr, Equal<Current<ARTran.sOShipmentNbr>>,
                        And<SOShipLine.lineNbr, Equal<Current<ARTran.sOShipmentLineNbr>>>>>>),
                        PersistingCheck = PXPersistingCheck.Nothing)]

  public virtual bool? UsrAdditionalBox { get; set; }
  public abstract class usrAdditionalBox : PX.Data.BQL.BqlBool.Field<usrAdditionalBox> { }
  #endregion

aiwan · Answer

Hi @TharidhiPYou could use a RowInserted Handler like so:protected virtual void _(Events.RowInserted e, PXRowInserted b){POReceiptLine row = e.Row; //find current recordif(row == null) return;POLine line = SelectFrom.Where.And>>.View.Select(base, row.PONbr, row.POType); // find related record in POLine tableif(order == null) return;POReceiptLineExt rowExt = row.GetExtension(row); //Get DAC Extension for POReceiptLinePOLineExt lineExt = line.GetExtension(line); //Get DAC Extension for POLine rowExt.UsrCustomField1 = lineExt.UsrCustomField1 //Set POReceipLine value.}

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded