What logic is creating Cost of Sales Adjustment GL rows in Item Receipt? We have multiple Receipts that does not have these rows but one receipt that has them

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** The Cost of Sales Adjustment GL rows in Item Receipts can be created due to several reasons: 1. Negative Stock Levels: If your inventory goes into negative, it can cause a Cost of Sales Adjustment. This is because NetSuite tries to adjust the cost of the item sold when there is no stock available. 2. Inventory Transfers: If items are transferred between different inventory locations with different cost basis, it can cause a Cost of Sales Adjustment. This is because the cost of the item might be revised for all inventory movement after the transfer. 3. Backdated Receipts: If someone backdates a receipt, it can cause a Cost of Sales Adjustment. This is because the cost of the item might be revised for all inventory movement after the receipt. 4. Item Record Setup: If an item has its asset account setup as COGS adjustment on the item record, it can cause a Cost of Sales Adjustment. To fix this, you can check the following: - Ensure that your inventory levels do not go into negative. - Check the cost basis of your inventory locations and ensure that they are consistent. - Avoid backdating receipts. - Check the setup of your item records and ensure that the asset account is not set up as COGS adjustment. You can also check the 'override cost' and 'override rate' on your Item Receipts that have GL impact. If 'override cost' is checked, it might be causing the Cost of Sales Adjustment. In addition, there is a setting in Setup_Accounting-accounting preferences that allows you to 'use item cost as transfer price'. This setting will keep the item value when transferring, etc. Sometimes people fill in a 'base price' which will then change the value of the item. You can check and compare the different cost basis for each location by looking at the "Stock Ledger". You can modify the report to sum total by location and filter by date and item to determine average cost for an item on a given date.