Hi,
I have a workflow that validates the amount on the bill against the PO and will flag exception if there is a discrepancy. It works fine when the amount on vendor bill is lesser and/or greater than purchase order. However, when there are mutliple bills to a PO, my saved search doesn't seem to recognize that.
Saved Search: Total Bill Amount
CRITERIA:
Transaction Type / Bill
Applied to Transaction: Type/Purchase Order
Main Line/False
Tax Line/False
Approval Status/Pending Approval
RESULTS:
Amount(Debit)/Sum
Document Number
Applied To Link Amount
Applied To Transaction
In my workflow:
State = Amount Validation
Group / Saved Search Condition: Total Bill Amount
Set Field Value = T
Exception Record = I keyed in a message that says "Total bill amount does not match PO"
I think I need to have a formula in the criteria, to add the total VB amount.
Thanks,
Preethi