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

image.png

Hi all, attempting to create a report to show all outstanding purchase orders to accrue, however I can't get the account field to pull into the report. The 'Related Account' gives me '-split-' but doesn't give me the accounts that it would be posted to if the Purchase Order was approved, received &amp; billed. We don't use 'Category', instead entering the account, dept and class.

Easier to do this via saved transaction search

You can even format it close to a JE, so you can just export it and then import it back as JE (and have it auto-reversed on the first day of next month).

thanks I've done it through a saved search