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

Has anyone figured out a way to map from netsuite to netsuite2 schema? Additionally, is there any documentation that define what fields are doing. For instance, I am trying to figure out  what the `isInventoryAffecting` boolean truly means. The records catalog dosent explain what the fields really mean so its been challenging for our BI teams to self-serve on building reports

I just posted <https://netsuiteprofessionals.slack.com/archives/C2A1ZEMF0/p1744991013985599|this>, which might be helpful. Though that specific field is unfortunately not one of the ones I had to deal with and overall I'm not familiar with it.

That being said, I'm assuming it's just a reporting flag that shows whether the inventory balance is increasing or decreasing on the transaction line.

Also, out in SuiteAnswers, NS has a more extensive similar spreadsheet than the one I posted. I think I filled in a couple gaps with my version, but they have more info.

This is super helpful. Any chance you can make that sheet downloadable?

As for the inventory field, I can make assumptions about what it means, but if I am building reports based on its functionality, I just want to be sure haha

oh it's not downloadable? I'll have to take a look. I just hit "publish" on it, which I assumed would make it downloadable, but I also don't use Google Sheets often.

ahh gotcha- yea you may need to "share" instead. Thanks so much!