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!

Rookie Asked on May 4, 2021 in Saved Searches.
Add Comment
1 Answer(s)

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.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor