Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
finding orders with discounts.
Here is the business process- We offer an 8% commission on sales at full price. If there is a discount (closeout order) then we only offer a 4% commission.
To facilitate this we have a custom field "Commission Rate" where the order entry person is supposed to choose "Full Commission" or "Closeout". If this is not chosen correctly we are in danger of overpaying commission on the sale.
Ideally I would like a report that shows me invoices or cash sales where:
1.) Items are sold at a price level other than the default price level set on the customer record.
OR
2.) There is a discount entered on the order.
0