Hi,
I'm having difficulties getting to pricing info with a nlapiSearchRecord function.
I've tried creating specific filters and keep getting errors on the filter when going to "price1" (USD pricing).
I've also tried creating a specific saved search, but can't seem to figure how to reference the columns in the search and also get a 'incorrect join' type error message.
An nlobjSearchColumn contains an invalid column join ID, or is not in proper syntax: currency
Here is the column definition I'm using. Any ideas of the exact syntax? I assume filters will be similar. (error is on last two Column definitions)
var columns = [
new nlobjSearchColumn('name'),
new nlobjSearchColumn('custitem_sku_num'),
new nlobjSearchColumn('custitem_item_revenue_category'),
new nlobjSearchColumn('custitem_item_sales_category'),
new nlobjSearchColumn('currency', 'price1'),
new nlobjSearchColumn('price_1_', 'price1')
]
Thanks,
Brian