Hi @ramya15 We can achieve your requirement using [PXDefault()] attribute.
Below code I have verified, with join conditions and it is fetching the data properly from Subcontracts screen to Bills and Adjustments screen.
Please find the code samples below, which you are looking for. Hope this helps!
Let me know if this is working for you as well.
public sealed class ARTranExt : PXCacheExtension<ARTran>
{
#region UsrLADperDay
[PXDBDecimal()]
[PXDefault(typeof(Search<POLineExt.usrLADperDay,
Where<POLine.orderType, Equal<Current<APTran.pOOrderType>>,
And<POLine.orderNbr, Equal<Current<APTran.pONbr>>,
And<POLine.lineNbr, Equal<Current<APTran.pOLineNbr>>>>>>),
PersistingCheck = PXPersistingCheck.Nothing)]
[PXUIField(DisplayName = "LAD Per Day")]
public virtual decimal? UsrLADperDay { get; set; }
public abstract class usrLADperDay : PX.Data.BQL.BqlDecimal.Field<usrLADperDay> { }
#region UsrLADAmount
[PXDBDecimal()]
[PXDefault(typeof(Search<POLineExt.usrLADAmount,
Where<POLine.orderType, Equal<Current<APTran.pOOrderType>>,
And<POLine.orderNbr, Equal<Current<APTran.pONbr>>,
And<POLine.lineNbr, Equal<Current<APTran.pOLineNbr>>>>>>),
PersistingCheck = PXPersistingCheck.Nothing)]
[PXUIField(DisplayName = "LAD Amount")]
public virtual decimal? UsrLADAmount { get; set; }
public abstract class usrLADAmount : PX.Data.BQL.BqlDecimal.Field<usrLADAmount> { }
}