Hello everyone, I have a difficult issue with NetSuite that I need help with.
We are a company that manufactures and sells hair products.
We primarily buy components ourselves such as bottles, caps, pumps, and labels, which are needed for manufacturing the finished products.
We then send these components to an outsourced factory to manufacture the finished products.
In NetSuite, we set up a Bill of Materials (BOM) for each finished product we manufacture. For example, the BOM of finished product PS0030 consists of 1 bottle, 1 cap, and 1 label.
When we want to manufacture the finished product, we issue an Assembly PO (Outsource) to the factory, select the finished product we want to manufacture, choose the appropriate BOM, and specify the item for the PO, which represents the factory's labor. The labor charge essentially covers the mixing of all raw ingredients (purchased by the factory) and the filling of the empty components we provide, resulting in the finished product.
The problem I have is that, historically, the labor/manufacturing item (classified as Other Charge for Purchases) was incorrectly configured. Instead of assigning this item's account to Inventory, finished products (15001), it was set to COGS (now 50001-OLD). As a result, whenever we received new products into our inventory, and create and pay the Bill, instead of increasing the Inventory value, the entire new stock value was recorded as COGS. Moreover, when we sold these products, the sale was also recorded under COGS, creating an accounting distortion in our books.
That said, it looks like
I cannot change the item's account to Inventory because this item has been used in Purchase Orders, Assemblies, Item Receipts, and all related records since 2022—and that year is already closed in our system (for example, with a similar item that was used after 2023, I was able to change the account, and the change affected all related records).
My question is what is the best approch to fix this accounting distortion?
I see in this account Bills that Im able to change manually, but also Item Receipts which I cannot change.
That said, very strangely, when I changed the account of a finished product (for example PS0030 which was also configured with COGS instead of Inventory), it seems that all Assembly records under this old COGS account have changed to Decrease,
Help to understand this behavior and possible fix would be highly appreciated.
Thank you