Est. Gross Profit in Sales Order went high and incorrect. What are the possible reasons?

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 Estimated Gross Profit in Sales Order can be affected by several factors: 1. Cost Estimate Type: The type of cost estimate you are using can significantly impact the estimated gross profit. For instance, if you are using an Average Cost, the system will use the average cost of the item at the time the Sales Order was created. If the inventory was not in stock at the time the Sales Order was created, the cost associated with the item would be $0, leading to a higher gross profit. To fix this, you can edit the Sales Order and refresh the Cost Estimate Type for each item. This will update the Estimated Extended Cost and provide a more accurate Gross Profit. 2. Discounts, Shipping, and Tax: These can also affect the Estimated Gross Profit. If you have any of these applied to your Sales Order, they could be causing the discrepancy. 3. Amount vs Amount (Gross): Make sure you are comparing the correct fields. If you are comparing the Amount to the Estimated Gross Profit (Line) with main line = false, this should give you the Estimated Gross Profit. However, if these numbers do not match, there could be other factors at play. 4. Timing of the Sales Order: As mentioned earlier, if the Sales Order was created before the inventory was in stock, the cost associated with the item would be $0, leading to a higher gross profit. If you are looking to make decisions based on expected margins, you might want to enable the "Gross Profit" feature in NetSuite. This feature can help you calculate the gross margin on sales orders.