Has anyone got a genius solution for the interaction between Netsuite period names and excel "helping" you when you open a csv? I have lots of frustrated users (they forget to set back the date format on the period column) - and looking up internal ID is also painful. We're occasionally posting into locked periods so would want to be specific about the period a transaction lands in I was thinking of adding external IDs to the accounting periods but it doesn't appear that you can 😞

Could you create a formula text field that adds a character before the period name

maybe the fully qualified name would work? FY 2015 : Q2 2015 : May 2015 @MGBC it's mainly on csv uploads that we have the issue. A transaction errors, we download the csv, fix the error, then boom. Another error as the period doesn't exist

Yes the full hierarchy would help. But I can’t remember if that is accepted in Csv imports

I'll give it a go