Ron Mc Blue Ribbon

I did see your last comment, but I have not had time to fully test it. I did do a preliminary test and did not seem to solve problem. The Sql tool was se to run as Admin and I changed it to run as current user. It seemed to still be wrong, but have not had time to fully verify.

I am using the same roles for each

Here is my Payload. Do you see anything wrong with it. { "entity": { "id": 588 }, "subsidiary": { "id":7 }, "memo": "Auto Created Bill from UPS Invoice Import", "tranDate": new Date().toISOString().split('T')[0], // YYYY-MM-DD "item": { "items": [{ "item": { "id": 329478 }, "quantity": 1, "rate": 123.45, "location": { id:…

I do have item id in the items array: is this not correct: Some resource say not use items but place the array directly under item "item": { "items": [ { "item":{"id":"329478"}, "quantity":1, "rate":9.55, "description":"UPS Inbound Freight" } ] }

I am close to a working model now. Thanks for all the help.

Thanks Abin Pious that was exactly what I needed for that portion of the setup. Now I am running into the problem that my image tag on email template is no being activated on the email receipt.

Thank you for help and answer. This got me where I needed to go. I was making it far to complicated. irRec.setValue({ fieldId: 'landedcostmethod',value: 'QUANTITY' }); irRec.setValue({ fieldId: 'landedcostsource18',value: 'OTHTRAN' }); irRec.setValue({ fieldId: 'landedcostsourcetran18',value: 2345851 });

Thank you for your response. Yes I can see these field names in the UI and in the XML. But I can't figure out how to access them in suitescript. Are they in a subrecord or a sublist? What is the path to access them via suitescript?

I had some other issues to deal with, @Richard James Uri answered the question I asked. Thanks.

Using this code: taxGroupRecord.setCurrentSublistValue({ sublistId: 'taxitem', fieldId: 'taxname', value: taxCodeId }); taxGroupRecord.commitLine({ sublistId: 'taxitem' }); Which appears to me to be like the suggested solution: taxgroup.setCurrentSublistValue({ sublistId: 'taxitem', fieldId: 'taxname', value: '-1425' //…

Hi @Jervin Nicholas Teopengco-Oracle Not sure I fully understand. Can you give me example query only get Inventory Details in Transaction assignments? Thanks

From the WOIssue Record Line item I want to retrieve the invenoryassignment. What Bin and Quantity it was issued from.

Corrected this statement: let invDetail = inventoryTransfer.getCurrentSublistSubrecord({ sublistId: 'item', fieldId: 'inventorydetail' }); TO: let invDetail = inventoryTransfer.getCurrentSublistSubrecord({ sublistId: 'inventory', fieldId: 'inventorydetail' }); sublistId: should be 'inventory' instead of 'item'.

The code below give the error: Field inventorydetail is not a subrecord field async function createInventoryTransfer(requestBody) { try { var inventoryTransfer = record.create({ type: record.Type.INVENTORY_TRANSFER, isDynamic: true }); // Set main fields inventoryTransfer.setValue({ fieldId: 'subsidiary', value: 7 });…

Thank you @Luis G you led me to the solution. The solution was to set the subsidiary value. I had failed to set the subsidiary value in the original script.

{"type":"error.SuiteScriptError","name":"INVALID_FLD_VALUE","message":"You have entered an Invalid Field Value 6 for the following field: location","id":"","stack":["Error\n at RecordInvoker.setValue (suitescript/resources/javascript/record/serverRecordService.js:443:5)\n at NetSuiteObject.thenableFunction()…

According to Netsuite support this feature is not currently available. So we did a work around: We created another custom field that contains the image URL. When we add and image to file we also populate the URL field. We are then able to get the URL linked to the item via SuiteQl.

Thank you Francesca Nicole Mendoza-Oracle Here is the essential code for to change the File attributes: const map = (context) => { try { const internalId = context.value; const myFile = file.load({ id: internalId }); myFile.isOnline = true; myFile.save(); } catch (e) { log.debug('Error', e); } };

log.debug("77", rBody.body.role[0]);

Here is what Netsuite Support had me do that worked: Set the Advanced Item Location Configuration by navigating to: Setup > Company > Enable Features > Items/Inventory Advanced Item Location Configuration = T Click Save Open Item record Under the Purchasing Inventory subtab > Scroll down to Location sublist Click Edit on…

Yes it is the autopreferredstocklevel field

So the problem is that record.Type.WORK_ORDER is an enum and it can't be passed as string (or at least sometimes it can't this is what confuses me is that with some record types it works at least some times) Since it is an enum it can not be addressed with a sting (What throws me though is that it works sometimes). So I…

I come back to this an redeploy and it does not work again. Giving the same error: {"type":"error.SuiteScriptError","name":"INVALID_RCRD_TYPE","message":"The record type [RECORD.TYPE.WORK_ORDER] is invalid.","id":"","stack":["Error\n at new Promise (native)\n at suitescript/resources/javascript/record/recordImpl.js:96:12\n…

I have run the same code this morning and it is working now. I did comment out a few sections redeployed and then uncommented and redeployed and it is working. There must be something in the deployment engine that didn't update until commented out.

The work Order Record is a Standard Work order. The function being used: async function createSublistRecord (recordObj){ try{ log.debug('110',recordObj); log.debug("79", recordObj.recordType); log.debug("83", recordObj.recordId); //retrieve Record let curRecord = await record.load.promise({ type: recordObj.recordType, id:…

You are right. I apologize to the community. I don't know what I had wrong before, but when I run it now, it works. Thanks for point it out.

Yes, it works with this expression: type: record.Type.EMPLOYEE, when I try to use a variable: type: recordObj.RecordType, it does not work. The variable of recordObj.RecordType is of type string, but it does not include the quotes as part of its value. It's value is record.Type.EMPLOYEE, which is a string.

Setting the value to true fixed it. Thank you

I tried put the subsidiary field in Single Quotes. It does not give the error but it does not return any records. I know there are records, because if I comment that clause out it returns records with that subsidiary value.

Yes it was helpful, I have not been able to test and confirm that it solved our problem as of yet.