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.
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