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

Hey all. In a Sales Order REPORT, what field field do I select to filter for End Date. I can’t find it. I thought it was Cancel date, Booking: End Date or Transaction: End Date, but those aren’t the ones. Driving me crazy…..

Since it was impossible to pull the end date into a report filter, I found a good workaround. I created a new date field and set a workflow to change the field date to the end date whenever added or created. Then I did a csv update to all previous SOs. Now the Custom End Date field is available for report filter.