Hello! Does anybody know how to retrieve the Shipping Tax Code and the Handling Tax Code in a Transaction Search? I know that Handling Cost and Shipping Cost are available both as main line fields and as separate lines, and that, in the latter form, I can retrieve all the tax information of the line. But in that case I wasn't able to find a field saying if a line comes from handling or from shipping. Thanks in advance. By the way, I think that is at least confusing to have such different data model between records and searches. It is a complete waste of time to find a way to retrieve such data that should be easily accessible.

That's a big part of what NS was trying to solve with the SuiteAnalytics Workbook tool

"Tax Item" on the transaction line for the shipping item (you can check against

{item.type}

for "shipping cost item"). This is the tax code. What I'm not sure on is how to distinguish the shipping line and handling line. Maybe compare the amount against the body-level "Shipping Cost" and "Handling Cost"?

Thanks David. Your solution is exactly how we implement it but I would like something more solid coming directly from Netsuite without the need to use tricks like that.