Hi all. New to Slack so bare with me. What is the best way to change an Income Account on an item (inventory, other charge, service, shipping,etc) when the item has postings in closed periods? I've reached out to N/S support and they recommended creating a new item with the new income account and inactivate the old item. Easier said than done considering the item needs to be updated on open transactions, bill of materials, etc. It just seems like there should be an easier way.

Short answer is you can't

@Roy L What @KevinJ of Kansas said is correct. It's because if you change the income account for an item, ALL transactions that relate to that Item will have the account amended (which affects the P&L and BS). So when you try to change the account for items that are in closed periods, NetSuite can't change them. I would suggest never changing any item accounts if you can avoid it.

Thanks all. I appreciate the responses and confirming my suspicion. It would be nice to have effective dates for accounts on items so prior periods wouldn't be impacted when the account is changed on the item master.

Technically, you could build something in Suitescript that does something similar to what you said. The script would basically do a journal entry as soon as a transaction was created for that Item. You will have a tonne of journals potentially, but it could work. To be honest, I think it's overkill but it really depends on how important it is for you and how likely it is that you can't create a new SKU instead.

Would be more efficient to use a GL impact script to do that instead of something that created JEs

I've never written a script that only affects the GL Impact, but if that's possible, that sounds like a better solution.