I have a custom record, which has a field (with id custrecord_ntnx_asset_tran_num) set as 'record is parent', so that it appears as a sublist on a sales order.
i would like to be able to render the sales order, and fields in the sublist on a suitlet. The role i'm using has view access to the sales order, and the custom record.
the code i have is something like this, based on KB article 65795 (https://netsuite.custhelp.com/app/answers/detail/a_id/65795)
var soRec = record.load({type:'salesorder', id: soId });
var sublistCount = soRec.getLineCount({sublistId: 'recmachcustrecord_ntnx_asset_tran_num'});
for (var i=0;i<sublistCount ;i++) {
var assetLine = soRec.getSublistValue({sublistId: 'recmachcustrecord_ntnx_asset_tran_num', fieldId: '
custrecord_ntnx_asset_tran_line_num', line: i });
/// use assetLine to do something
}
This works great for a role that has edit permission to the sales order and the custom record, However, for roles that just have view permission the sublistCount is coming back as 0. This custom role can view the sales order, and the sublist shows fine in the NetSuite UI, but does not seem to be usable using recmach in SuiteScript.
Anyone have any suggestions (besides the obvious - give the role edit permission ;) )?