cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
JhoannaG
Level 2

Changing inventory item code without affecting previous period

Hi, I would like to update an inventory item Sales and COGS GL account code without affecting previous periods. I'm using QB Enterprise. Please let me know if this is the default or will it always change previous period? If it will change it, is there a button to prevent it?

Thanks,

Jhoanna

Solved
Best answer February 13, 2020

Accepted Solutions
JessT
Moderator

Changing inventory item code without affecting previous period

It's great to see you in the Community, Jhoanna.

 

I'm happy to shed light on how the change of COGS and Income account works for inventory items, and we'll talk about your option.


By default, you will get a prompt with an option to affect the change in previous transactions or not when changing the income account of an inventory item. However, it’s not the case for the COGS account. If you change this, it will also affect the historical transactions. 


Your option would be to create a new item with the new accounts. Then, you can inactivate the old one to prevent from using it in future transactions.

 

 

If you have additional questions about changing the accounts of your items, please feel free to go back to this thread.

View solution in original post

4 REPLIES 4
JessT
Moderator

Changing inventory item code without affecting previous period

It's great to see you in the Community, Jhoanna.

 

I'm happy to shed light on how the change of COGS and Income account works for inventory items, and we'll talk about your option.


By default, you will get a prompt with an option to affect the change in previous transactions or not when changing the income account of an inventory item. However, it’s not the case for the COGS account. If you change this, it will also affect the historical transactions. 


Your option would be to create a new item with the new accounts. Then, you can inactivate the old one to prevent from using it in future transactions.

 

 

If you have additional questions about changing the accounts of your items, please feel free to go back to this thread.

JhoannaG
Level 2

Changing inventory item code without affecting previous period

thank you so much!

barrett59105
Level 1

Changing inventory item code without affecting previous period

Creating a new item works but the problem is your historical data on 1 item is now spit between two part numbers/items and that is not ideal.  

LinkLynn
Level 1

Changing inventory item code without affecting previous period

I think if you add a sub-category COGS account under the mail COGS account, it would still be in the same accounting GL and  yet separate the items that are different. Does this make sense? 

Need to get in touch?

Contact us