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.
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