The IT_COS field stores the Cost of Sales value for each transaction. This field is updated whenever the Calculate Cost of Sales process is run.
If Clear IT_COS is selected, all existing IT_COS values will be reset to 0.00. The system will then recalculate the cost based on the selected period.
To recalculate the cost:
Go to Reports, Customer & Sales, Profit Margin, Calculate Cost of Sales.
Select the required Costing Method.
Select the relevant period.
Ensure Clear IT_COS is not selected.
Run the calculation.
If some items are still showing a cost of 0.00, run Calculate Cost of Sales again for Periods 1 to 10 and ensure Clear IT_COS remains unchecked.
This will repopulate the IT_COS values and update the Profit Margin report with the correct costs.