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!

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 5 days ago.
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