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):