Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
How to show Total amount from multiple vendor bills.
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
0