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

Anyone know how to add the field “Start Date” to a Transaction report?

Did you try searching for it in the "search fields" box?

I did! Strangely enough, the field isn't showing for the transaction start date.  Only the Accounting Period

What type of transactions are you trying to show the start date for?

isnt the Start Date used for SO for future billing?

The Invoice would be a reflection of that billing

We renamed this field to suit a clients needs - they won't actually be using sales orders.  This is a standard transaction report.

Look for the new name, sometimes Netsuite will keep the original name and sometimes they switch to new name, I am sure there is reasoning behind it

Unfortunately, that one isn't showing either.  I'm really stumped by this one.

Depending on what you're trying to accomplish with the report, sometimes it's easier to go saved search route

You said this is a standard transaction report which transaction? I was asking so I can see on my screen 

The only reason in going to the report side is so that I can do the grouping based on a custom field for the invoice type.  The saved search pulls all results, I just can't get the same sort of grouping / delineation

I tried in open invoices and I don’t see that field either, Netsuite might not have exposed that field 

You might create a custom field, source that field from start date and than get it on the report 

Would I need to update the record to get this to source?

Yes, mass update script should update historical 

You can't bring non stored values into reports - so you'll have to have some kind of scheduled process or something to update the values

I'll try to create a workflow that updates the records and sources that field.  Thanks!

Workflow won’t do the historical, would it?

I'm thinking maybe a schedule search to update records?

I'm hesitant with the mass update because we're in production, but I can see if it's something our developer feels comfortable with.

to populate one field value? I'd imagine risk is pretty low...

Maybe it's also because i haven't done a mass update as of today :slightly_smiling_face:

Not much different than doing a scheduled workflow - do what you're comfortable with I guess.

If you have developer it’s a very small script maybe 10 lines 

I'll look into it - it sounds like that will be the easiest route

The scheduled workflow worked everyone.  Thanks so much for your insight!