Is it possible to make a search on vendor payments...
# suiteanalytics
n
Is it possible to make a search on vendor payments where you can see which bills they WERE applied to? I was thinking a system notes search but open to other ideas
n
So this is reflecting changes to how a vendor payment was made from how it was originally applied?
n
Yes - basically if a bill goes from approved -> pending approval -> approved, it gets unlinked from the payment that as applied to it and I wanted to find a way to see if I could track that back to reapply the payment
n
I played in my dev account with System Notes on the Bills and Payments. I didn't immediately see an entry by transaction that would help identify the link/broken link. One approach I think will get it for you. New Search of System Notes. Select (Record = Bill AND Document Status, New Value = Unapproved ) OR (Record = Bill Payment * AND [find something unique]) this should be showing you changes on both those records at the same time.
n
Hey NetSsuite Tragic - thanks for the response! What I ended up doing is the sum of the applied to transactions vs the sum of the amount on the bill payment. What I noticed is the bill payment amount stayed the same even though the bills got unlinked from the payment.. so I tried to track them down like that
1