here is what other AI has kicked out
1. Custom Field + Workflow (Best Low-Code Approach)
Goal: Show expected PO receipt date next to SO line item (ETA).
How:
1.
Create a custom transaction line field on the Sales Order called “Expected PO Receipt Date” (Type: Date).
2. Create a
Saved Search on Purchase Orders with columns:
◦ SO Number (via linked field)
◦ Item
◦ Expected Receipt Date
3. Use a
workflow or Map/Reduce script (if needed) to:
◦ Match PO line items to SO line items (by item and SO reference).
◦ Copy the
earliest expected receipt date to the SO line custom field.
🔁 You can make this update periodically (e.g., daily) with a scheduled workflow or scheduled scrip