RE: Purchase Order Amount vs Vendor Prepayment Amount Saved Search

Looking to create a transaction saved search that either pulls purchase orders or vendor prepayments and compares to the other transaction. Because the PO isn’t billed yet, I can’t do applying transaction. I can’t seem to join to the PO when pulling Vendor Prepayment results.

Please help!

Dhuss Rookie Asked on May 4, 2021 in Saved Searches.
Add Comment
1 Answers

since PO is not billed or received yet, you do not have any connection to prepayments. Only common factor between these two records is the Vendor, try a vendor search and try to relate all transactions under the Vendor. You can also try using the SuiteAnalytics’ multi join and pivot functions too

Advanced Answered on May 4, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.