Hi every one,
I have a custom field on POLine named “Custom Note” (UsrCustomNote)
I want to bring this field to POReceiptLine when creating Purchase Receipt by click button “ENTER TO RECEIPT”
The goal like:
Could you please help me?
Regards,
Khoi
Answer
Copy value of field from POLine to POReceiptLine when creating Purchase Receipt
Best answer by Naveen Boga
Hi
I have verified with the below and it is working fine.
public class POReceiptLineExt : PXCacheExtension<POReceiptLine>
{
[PXDBString(100,IsUnicode =true)]
[PXDefault(typeof(Search<POLineExt.usrCustomNote,Where<POLine.orderType,Equal<Current<POReceiptLine.pOType>>,
And<POLine.orderNbr,Equal<Current<POReceiptLine.pONbr>>,
And<POLine.lineNbr,Equal<Current<POReceiptLine.pOLineNbr>>>>>>), PersistingCheck = PXPersistingCheck.Nothing)]
public string UsrTestField { get; set; }
public abstract class usrTestField : PX.Data.BQL.BqlString.Field<usrTestField> { }
}
+19Hi
I have verified with the below and it is working fine.
public class POReceiptLineExt : PXCacheExtension<POReceiptLine>
{
[PXDBString(100,IsUnicode =true)]
[PXDefault(typeof(Search<POLineExt.usrCustomNote,Where<POLine.orderType,Equal<Current<POReceiptLine.pOType>>,
And<POLine.orderNbr,Equal<Current<POReceiptLine.pONbr>>,
And<POLine.lineNbr,Equal<Current<POReceiptLine.pOLineNbr>>>>>>), PersistingCheck = PXPersistingCheck.Nothing)]
public string UsrTestField { get; set; }
public abstract class usrTestField : PX.Data.BQL.BqlString.Field<usrTestField> { }
}
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Hi
thank you very much for your question.
In addition, How to update value of this field when we make an update on the field usrCustomNote on POLine? it means: update field usrCustomNote on POLine → sync this value to the field on POReceiptLine
Could you please help me on that?
Regards,
Khoi
+19- Extend the POOrderEntry Graph
- Override the Persist method to write a logic to update the field in the POReceiptLine
- In logic, you can create the POReceiptEntry graph object
- Fetch POReceiptLine with the fields POOrderType, POOrderNbr and POLineNbr
- assign the value from POLine field to POReceiptLine field
- Update the cache
- Save the POReceiptEntry graph.
Note: You cannot edit the PO when status is in OPEN and can only edit when PO is in HOLD status.
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.