Hello,
how can I add LotSerialNbr from SOShipline (SO302000) in SO303000 (Invoice) in detail grid ?
Thanks in advance
Answer
How can I add LotSerialNbr from SOShipline (SO302000) in SO303000 (Invoice) in detail grid
Best answer by darylbowman
If you want the ARTran to lookup the current value of the SOShipLine (every time), you can place this on a custom unbound field in ARTran:
[PXDBScalar(typeof(SearchFor<SOShipLine.lotSerialNbr>.
In<
SelectFrom<SOShipLine>.
Where<SOShipLine.shipmentType.IsEqual<ARTran.sOShipmentType>.
And<SOShipLine.shipmentNbr.IsEqual<ARTran.sOShipmentNbr>>.
And<SOShipLine.lineNbr.IsEqual<ARTran.sOShipmentLineNbr>>>>))]If you want to copy the value (once) from SOShipLine, this might help you. As I recall, the same method gets executed regardless of it the invoice is created ‘from’ ‘Sales Orders’ or ‘Shipments’.
I did my best to get it right with the help of the article, but I failed.
+15If you want the ARTran to lookup the current value of the SOShipLine (every time), you can place this on a custom unbound field in ARTran:
[PXDBScalar(typeof(SearchFor<SOShipLine.lotSerialNbr>.
In<
SelectFrom<SOShipLine>.
Where<SOShipLine.shipmentType.IsEqual<ARTran.sOShipmentType>.
And<SOShipLine.shipmentNbr.IsEqual<ARTran.sOShipmentNbr>>.
And<SOShipLine.lineNbr.IsEqual<ARTran.sOShipmentLineNbr>>>>))]If you want to copy the value (once) from SOShipLine, this might help you. As I recall, the same method gets executed regardless of it the invoice is created ‘from’ ‘Sales Orders’ or ‘Shipments’.
Daryl ⚡Freelance Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
Here is the sample code
[PXString(100, IsUnicode = true)]
[PXUIField(DisplayName = "Lot/Serial Nbr", Enabled = false)]
[PXDBScalar(typeof(
Search<SOShipLineSplit.lotSerialNbr,
Where<SOShipLine.shipmentType.IsEqual<ARTran.sOShipmentType>.
And<SOShipLine.shipmentNbr.IsEqual<ARTran.sOShipmentNbr>>.
And<SOShipLine.lineNbr.IsEqual<ARTran.sOShipmentLineNbr>>>>))]
public virtual string UsrLotSerialNbr { get; set; }
public abstract class usrLotSerialNbr : PX.Data.BQL.BqlString.Field<usrLotSerialNbr> { }Hope this helps
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.