Auto-Populate Last Price on Transaction Line in CPQ

Hello CPQ Community,

I’m working on a requirement in Oracle CPQ and need guidance on the best way to implement it. Here’s the scenario:

Requirement:

• On the Transaction Line of a quote, I want to auto-populate a field called “Last Price”.
• The value should come from the most recent quote where:
  • The Customer matches the current quote
  • The Item / Part Number matches the current transaction line
  • The quote status = OrderedBeingFulfilled
• The field should display the line amount from that previous quote.
• If no previous quote exists, the field can remain blank or 0.

What I’ve Done / Considered:

• Created a Transaction Line field