tag:blogger.com,1999:blog-7833645889341614736.post7925043757347275107..comments2024-03-22T09:57:30.581-07:00Comments on NetSuite Development Notes: Search that totals Sales Order and Purchase Order per ItemNetsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-7833645889341614736.post-91256693670030788522020-03-05T05:42:37.567-08:002020-03-05T05:42:37.567-08:00New to Netsuite and I'm not sure exactly how t...New to Netsuite and I'm not sure exactly how to setup the items under #5 - where does the custom label go and where do i plug in the formulas?<br /><br />-- Formula (Currency)<br />- Custom Label "Purchase Order Total" - case when {type}= 'Purchase Order' then {amount} else 0 end<br />- Custom Label "Sales Order Total" - case when {type}= 'Sales Order' then {amount} else 0 end<br />- Custom Label "Variance" - (case when {type} = 'Sales Order' then {amount} else 0 end)-(case when {type} = 'Purchase Order' then {amount} else 0 end)Netuser453543https://www.blogger.com/profile/08575669577688684388noreply@blogger.com