This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Really don’t know this one. On a report, not a saved search, how do I count the number of transactions, Say… Purchases by Vendor?

via the report builder formula I don't think it can be done. Maybe one workaround is have a custom field in the Vendor record that sources from a Saved Search instead. Then just add the custom field in the report.

I actually figured it out.
Columns:
Month - Group
Vendor - Group
Document Number
Quantity
Formula - x/y  x=Qty  y=Qty (check Add Grand Total and uncheck Apply formula to Grand Total)
Total Revenue

Then roll up the results to 2nd tier and it gives me the transaction count

Just tried it. That's a neat workaround!:+1:

Could also use Transaction Number instead of Document Number in case there are transactions with blank document numbers.