Promised Date from PO Order line to ReceiptLine

Question

I would like copy the Promised Date from the Purchase Order (PO802388) Line to the Purchase Receipt Line (PO302000) when creating the PO Receipt.

I am trying the customisation project but could not find how to link the PO Receipt line to the Order Line to get the required date field. On the PO there will be multiple line for the same Inventory Item.

Any help will be appreciated. Many Thanks

Answer 1

Ignoring CompanyID which is automatically managed by the framework, there are three required key fields to select a POLine record:

Fortunately those key values are available from POReceiptLine so you can link them like this:

POReceiptLine receiptLine = […];

PXResultset<POLine> poLine = PXSelectReadonly<POLine,
                             Where<POLine.orderType, Equal<Required<POLine.orderType>>,
                             And<POLine.orderNbr, Equal<Required<POLine.orderNbr>>,
                             And<POLine.lineNbr, Equal<Required<POLine.lineNbr>>>>>>.Select(Base,
                                                                                            receiptLine.POType,
                                                                                            receiptLine.PONbr,
                                                                                            receiptLine.POLineNbr);