Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Retrieve 'Amount' from transaction search
I have an existing saved search I'm calling via "var searchresults = nlapiSearchRecord( 'invoice', 57, filters, null );"
The search contains the date, amount and item internalID fields of all 'invoice' transactions. I can retrieve the date and itemID fields easily enough using
searchresult.getValue( 'internalid', 'item' )
searchresult.getValue( 'trandate' )
I can't seem to retrieve the generic 'Amount' field though. I've tried all the following with no luck. Is there a way to determine what field name to use when referencing saved seach results?
searchresult.getValue( 'amount' );
searchresult.getValue( 'amount', 'transaction' );
searchresult.getValue( 'amount', 'invoice' );
searchresult.getValue( 'Transaction_AMOUNT_raw' );
Thanks