A customer has 3 subsidiaries, sharing the same inventory items. They all have different currencies. They want to get control of their estimated gross margins on sales orders. The average cost is not correct to use for GM-calculation since it doesn't cover all costs (landed cost is not used due to other problems). One could use item defined cost on the item as the basis for GM-calculation, but there is only one item defined cost-field on the item, meaning it will only be correct to use that for one of the subisdiaries. Is there any other way to use the standard GM-functionality to work across subsidiaries without using average cost as the basis? (edited)

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the standard Gross Margin (GM) functionality in NetSuite does not directly support different item costs for different subsidiaries. However, there are a few potential workarounds: 1. Use Saved Searches or SuiteQL: You can create a saved search or use SuiteQL to calculate the average cost per item for each subsidiary. This would involve filtering the transactions by subsidiary and calculating the average cost manually. However, this would not directly integrate with the GM calculation. 2. Use Different SKUs: If you want to keep different costs for the same item in different subsidiaries, you could create different SKUs for each subsidiary. This would allow you to set a different cost for each SKU, effectively giving you different costs for the same item in different subsidiaries. However, this could complicate inventory management. 3. Consider Standard Cost: If you want to avoid the fluctuation of average cost, you might want to consider using the Standard Cost model. This allows you to set a fixed cost for an item, which could be used for GM calculation. Remember, these are workarounds and may not perfectly fit your needs. You might need to customize these solutions to fit your specific requirements. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******