Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
Formula needed to remove GL codes from transaction total
I have a workflow that calculates the sales commission for sales orders based on the Sales Rep's individual rates and enters that amount in a custom field on the SO. This formula is: ({total}-NVL({altshippingcost},0)-NVL({taxtotal},0))*[insert rate]
Sometimes the shipping or tax is entered as a line on the SO instead of in the shipping tab or using Netsuite tax rates. Therefore, I have been asked if my formula can remove these line level items.
I am completely blank on how this might be able to be done. If there is a way to either exclude the value of certain items (this would be several criteria) or the value of items that are coded to a certain GL (this would only be 2 criteria), that would be ideal.