Adam Partee
05/22/2025, 6:26 PMCeligo AI
05/22/2025, 6:26 PMAI generated answer (using internal Slack threads):To calculate the gross margin per line item using a sales order and invoice in NetSuite, you can follow these steps: 1. Enable the "Gross Profit" feature in your NetSuite account. This feature will allow you to see the gross profit on each line item in your sales orders and invoices. 2. Once the "Gross Profit" feature is enabled, you can view the gross profit on each line item by navigating to the sales order or invoice and looking at the "Gross Profit" column. This column will show the gross profit for each line item, calculated as the sales price minus the cost of goods sold. 3. If you want to calculate the gross margin percentage, you can create a custom field with a formula that divides the gross profit by the sales price and multiplies the result by 100. This will give you the gross margin percentage for each line item. 4. If you want to include discounts in your gross margin calculation, you can use Non-Posting Discount Items. These are discounts that are applied directly to the line item, rather than being added as a separate line item on the order. This can make it easier to calculate the gross margin for each line item, as the discount is directly attributed to the item. 5. If you want to automate the calculation of gross margin and commission in your sales orders, you may need to use advanced HTML templates or look into SuiteApps or bundles that offer this functionality. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
05/22/2025, 6:26 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.829160213
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.827938199
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.819727778
Celigo AI
05/22/2025, 6:26 PM