@Dext3r Yes, your assumption is correct. Thank you so much for your keen observation. You've accurately identified the issue: the last line's join field value (custitem_sw_parts_remarks5) is being duplicated at every lines. I've also checked the record catalog, and the assemblyitem sublist isn't listed in the BOM. This…

@Dext3r @Alex Joves -Oracle It's not a problem with the field ID. It surely exists.

@Francesca Nicole Mendoza-Oracle Sorry, i mean… Netsuite, we can export the xls. from Reports, right? I want to get the xls. in a SUiteScript function.

@Francesca Nicole Mendoza-Oracle I appreciate your reply but think the link doesn't contain how a saved report .xlsx is exported in SuiteScript. Could you show a sample of the code?

Ref No. was what we wanted. A member of our team found this. I appreciate all your help.

@Nicole Mendoza-Oracle I appreciate your work. We use a normal record.submitFields(options). If record.submitFields(options) really doesn't kick sourcing… I found the following reference, so it would be a considerable bug… options.options.enablesourcing boolean optional Indicates whether to enable sourcing during the…

@Nicole Mendoza-Oracle I appreciate your reply. Affirm. The field is sourced from another custom field(The source field). The record.submitFields set the source field. Regards,

This resolution can also be adapted to vendors.

I found this suite answer but the item is a normal resale service. So this post cannot solve this problem. https://suiteanswers.custhelp.com/app/answers/detail/a_id/78494

@Vajrala Madhu Reddy Sorry, I failed to tag you in the last comment…

@Vajrala Madhu Reddy I appreciate your reply but I mean, Advanced numbering, not the normal one. I'm seeking a way to let users edit document numbers (tranid) via UI while advanced numbering is ON.

@Vajrala Madhu Reddy Yes, we would like to do it sometimes even though we're using the Advanced Numbering Rule.

Content-Type was wrong, now it is solved.

@Donna Bernardo-Oracle @Richard James Uri-Oracle The link doesn’t work for my environment, so could you check if the link is valid? Anyway, the latest JS: ES 2023 version is available for both Suite Apps, is it correct?

@Donna Bernardo-Oracle I appreciate your message, I would share the apps and their versions. SuiteCommerce Advanced 2021.2.3 SuiteCommerce Extension Management 2023.2.0

@Niks Blando-Oracle It says "Field Not Found".

@Niks Blando-Oracle I appreciate your help. I confirmed that {pricing.saleunit} is not sourced in my account. I guess it might be related to the feature configuration but which one makes this behavior? Best Regards,

@Edwards_05 It's hard to understand why my environment throws this error... I think the formula contains only normal fields so "Field Not Found" is really weird...

@Edwards_05 @Niks Blando-Oracle I appreciate your help. I tried the saved search you taught me but I got the error: ERROR: Field Not Found Is it still working in your environment? Best Regards,

I got one more question, is it possible to set the Payment item type on the vendor bill list?

Lists - Perform Search We found that this is what it needs. needs no further investigation.

I found the solution, which is nlapiLookupField('customrecord_sw_vessel_company', nlapiGetFieldValue ('custrecord_sw_vessel_company'), 'custrecord_sw_vessel_company_name' ). So we don't need a further investigation. Thank you for your support.

@Nicole Mendoza-Oracle I appreciate your help. I took a look at the suiteAnswers link but it didn't touch on getTimezoneOffest behavior. Hopefully, soon we understand the specifications with your investigation. Best Regards,

@Nicole Mendoza-Oracle I appreciate your help. I refer to the normal exchange rate, I mean, that normal "exchangerate" all transactions commonly have. Best Regards,

@Michaela Christova-Oracle I appreciate your reply. Has valuable information been found about my question? Best Regards,

@Dinesh Babu Gadhamsetty I appreciate your help, I tried to attach some captures but I got the following permission error. Permission Problem You need the Garden.Uploads.Add permission to do that. @Richard James Uri-Oracle Could you guys check my account and add permission to it? Best Regards,

@Richard James Uri-Oracle I appreciate your help, also on your side, nlapiGetFieldValue didn't work there? Could you ensure the specifications in the document that the Oracle has? Best Regards,

@Richard James Uri-Oracle I appreciate your help. Did it work on your end even when you use custom transactions, not the NS default transaction? I tried the way just now but it still throws an error in rendering.

@Richard James Uri-Oracle I tried this already but when I put a custom transaction on "renderer" with .addRecord, it still returns null. Is the .addRecord method available also for a custom transaction or not? I wonder if there is a restriction on the NS about this... Now everything that we found doesn't work and we're…

@Richard James Uri-Oracle I appreciate your reply, but the article is not about what we need. We would like to merge multiple custom transactions, the same record type, into 1 pdf file. Do you guys have a solution like this?