Hi everyone - new NetSuite user here. I’m a consultant implementing on behalf of an NFP (not-for-profit). We are live on the Accounting functions but just have aggregate journal entries right now. We have Customer data ready to import, and would also like to bring 5 years of order history from various systems into NetSuite (this will be the first time this organization has a central system). I would love to just create a custom object and import to that, but our PS person hasn’t been much help with solutions, and I don’t know enough to figure that out on my own. We, of course, do not want to hit the GL. I have come up with a solution, and would like some seasoned professionals to help punch holes if you can see any. I have created one item called “Historical Purchase” and will use the memo field to say what the transaction was and how much they paid. I would like to use the actual transaction date. I have not figured out the Accounting Periods yet. Should we create 5 periods for the historical annual purchases, and have each period span 1/1 - 12/31? We will have some overlap in periods for 2019 (all closed) & 2020. Can anyone offer insight to that? Or, an alternative? Thanks in advance!

Angela, I'd suggest evaluating Custom Sales Transactions for this purpose - you can make them non posting and even use your normal items and keep your historical dollar values and descriptions correct.

Just the title “Custom Sales Transactions” makes me hopeful, lol! The reporting wouldn’t have been seamless with the other way either, but as long as the data is there that would make me very happy. I’ll read up on it and see if I can figure it out. We are on the NFP version, not sure if that makes a difference.

You can read about it in SuiteAnswers @Angela Simon Search for Custom Transactions and the related topics

I’m trying to decipher it all now. It seems that every time I need to do something I have to ask PS for extra permissions. What is the difference between Help Center and SuiteAnswers? Thanks!

SuiteAnswers is basically the help center of NetSuite

You would need to enable the feature but it shouldn't require any additional purchases