We have been using Netsuite for 12 months so very much new to the system. I have a set of sales orders for which the average cost calculation captured in the unit estimated cost was zero or incorrect due to errors in the opening inventory records. These sales order have been fulfilled, invoiced and paid and the team has not clocked and actioned the errors in the estimated cost. Because of these errors, none of the accoutning periods have been closed to allow them to be corrected. In trying to correct the cost we have used a script to update the sales order cost estimate type to be custome and updated the unit cost estimate. We have replictaed this to the invoice and updated the item fulfillment rate to reflect the correct amount. We have removed the invoice payment and re-applied it, removed the fulfillmewnrt and re-fulfilled it and none of these actions change the G/L impact to Purchases for resale / COGS cost as we would expect. What so we need to do to have Netsuite re-adjust the G/L impact for cost ?
