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.
Update: Narrative Insights has been restored and is now available.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Subtracting SO amount-PO amount
Hi All,
I have 2 saved searches one which shows list of purchase orders with amount.
and other shows list of salesoders with amount.
in both searches we group by the results with a custom field called reffid.
means a sales order has only 1 reff id.
so for that reffid we may have so many purchase orders.
Now can i have a chance of getting a result which is equal to total of sales order of a particular reff id-total of purchase orders with the same reff id...
I used a formula which seems not working..
sum(decode({type},'Sales Order',{amount},-{amount}))- (sum(decode({type},'Purchase Order',{amount},-{amount}))
0