Requirement: Client would like to see GST and TDS in separate columns in the search. Using NetSuite Standard behavior, it is obtained as Amount (Tax) in search.
Solution:
Create a Transaction Search.
In Criteria Subtab,
-Add Type is Bill
-Mainline is False
In Results Subtab,
Add necessary fields.
For TDS,
Field: Formula Currency, Function Absolute value, Formulae: DECODE(ABS(NVL({taxamount},0)),0,0,NVL({amount},0)*NVL({custcol_in_tdsid_tds.custrecord_in_tds_setup_rate},0))
For GST
Field: Formula Currency, Function Absolute value, Formulae:
DECODE(ABS(NVL({taxamount},0)),0,0,ABS(NVL({taxamount},0))- (NVL({amount},0)*NVL({custcol_in_tdsid_tds.custrecord_in_tds_setup_rate},0)))
In the result page, we can obtain:
