The requirement is to display the lines related to the currently logged-in customer in the customer center and eliminate the lines associated with other customers from the custom record. Use Formula Numeric in the saved search Criteria “decode({custrecord_vr_thirdparty_ship_cust.id},{user.id},1,0)”
Tag: formula numeric
How to distingush between normal item and Matrix child item in a saved search?
To distingush between normal item and matrix child item, we can use Formula(Numeric) field in the result tab of item saved search. Before applying this formula, we need to display the ‘parent’ field in the result tab. Then on saving the search we will get the results i.e 4 and 1 accordingly.
Calculate Date Difference in Saved Search if one of the Date is empty
Have been using the formula numeric to compare two dates in NetSuite via saved search. This was required in purchase order update sync.This formula is used to check whether there are any latest updates on the purchase order. After the PO update sync we will set the updated date on custom date field. The formula… Continue reading Calculate Date Difference in Saved Search if one of the Date is empty