Default the negotiated flag to yes when the sum of the PO for that supplier exceed $35k

Summary: Default the negotiated flag to yes when the sum of the PO for that supplier exceed $35k.

When want to have a rule in VB to default the Negotiated flag to Yes for "Enter Requisition line" Page, when the sum of the approved PO's for a supplier exceed $35,000.00. I was thinking about an advance expression.

That could be in one or multiple Suppliers.

Example:

First, Approved PO 1 for supplier A: $15,000.00

Second: Approved PO 2 for supplier A: $15,000.00

Third, Requisition amount for the supplier A: 10,000, 00 it should have the Negotiated flag to Yes.

Can we do this?

Content (please ensure you mask any confidential information):