Hello Experts. I have a client who uploaded a bunch of inventory records that have the wrong costing method. I deleted and recreated the records that have no transactions. Those with Transactions, I'm not sure what to do. Should I make the item inactive and recreate a new record? What will be the effect in reporting if I leave it inactive? Please advise Also transactions were paid via credit cards that is why I am hesitant to modify the transactions. Thanks in advance for your help.

It sounds like this happened recently. If the volume of transactions is low enough, and there are no 3rd party involvement that would need to replicated like taking a new payment from a customer through NS or having a vendor cancel one PO to replace it with a new one, I would consider deleting the transactions so you could delete and recreate the items. If that isn't an option, then marking them inactive and recreating is the right path forward. As for reporting, inactive items display in reporting unless excluded in a custom report/search. The system will treat the new items as unrelated items unless you create a link between them. Setting the inactive item as a subitem of the replacement is one way to address that.

hello @Nicholas LaHara thank you for this response

Where is payment processing done? Webstore or NS?

NS

I would let those fly then, inactivate and recreate items for future transactions.

So just to be clear, It is advisable to not change anything on the transactions

That's correct. If I were tackling this, I'd start in the sandbox and test the impact of working with an inactive item on all applicable transactions.

what if there were items that has on hand qty?

Inventory adjustment, zeroing one, increasing the new.

thanks @Nicholas LaHara

Np, best of luck.