Vernita Bronze Trophy

Hi @Richard James Uri-Oracle Any updates on this? Thanks

C. Text row: Displays static text or provides a blank row in between financial statement sections.

Thanks @Richard James Uri-Oracle does this mean it is possible to create a scheduled script to send the workbook's csv file via emaill?

Hi @Richard James Uri-Oracle No, there are no other scripts running. I have just created the custom record type prior to deploying the script. Is this some kind of Netsuite Suitescript limitaton? thanks

Hi @Jervin Nicholas Teopengco-Oracle Apologies for the late response. I just got the exact requirement from a colleague and customer of what they were trying to do. The requirement was for the 'To be printed' on a sales order record to be checked if an invoice has been raised for that sales order. I have tried this with a…

HI @Joy Noreen Magoling-Oracle I was after a saved search that retrieved the quantity picked or packed so I can add a sublist with those values on the invoice record. Thanks for the suggestion anyway. It would be useful for other future requirements

HI @Nicole Mendoza-Oracle I think the issue is with the script logic rather than an actual bug or defect. thanks

Thanks @Richard James Uri-Oracle Are there any issues with the field value being populated by a client script which creates a search of the custom record? I had heard from someone that a search should only be conducted with a suitelet and not a client script. Is that correct?

D. Vendor Prepayment

B The help guide states that 'create' level is needed for the Fixed Asset Reset data permission.

A. Comment Block e.g. /** *@NApiVersion 2.x *@NScriptType MapReduceScript */

C. List/Record

Hi @Richard James Uri-Oracle I tried to retrieve search results where the applying transaction: receipt/fulfilment had a status of 'picked' or 'packed'. However this would not return any results. I assume this is a limitation? thanks

Hi @Michelle Jabanes-Oracle How would I incorporate saved search fields on an email template? The email template in question is going to be used with a workflow . thanks

Hi @Jervin Nicholas Teopengco-Oracle The record creation state: Example of one of the actions: thanks

Hi @Jervin Nicholas Teopengco-Oracle Yes, it automatically goes to Pending Approval. There is a status condition though, by default, the record will be on pending approval when it is first created thanks

Hi @Richard James Uri-Oracle Is it correct that the 'Applying Transaction: Receipt/Fulfilment' table only returns item fulfilments with a status of 'shipped'? I am trying to find Item fulfilment records where the status is picked or packed as well

Hi @Jervin Nicholas Teopengco-Oracle The formula for a hyperlink didn't work for me. It kept returning free text reference to the sales order record number

D. All of the above

Hi @Richard James Uri-Oracle This is the full script after further revisions. /** * @NApiVersion 2.x * @NScriptType UserEventScript */ define(["N/record", "N/search"], function (record, search) { /** * @param {UserEventContext.beforeSubmit} context */ function beforeSubmit(context) { try { var transactionRecord =…

Hi @Jervin Nicholas Teopengco-Oracle My apologies, I had incorrectly stated that the sourcing and filtering criteria was blank (I had adjusted the field several times and had forgotten that the version where the field was returning a value had values in that tab). Once I adjust the field type to list/Record and…

Hi @Richard James Uri-Oracle Apologies for the delay in responding. I also got a null value when using the console log with the nlapiGetLineItemValue('item', 'itemfulfillmentchoice', '1'). The item fulfilment field in my screenshot is a custom field: field id: custcol_item_fulfillment

B. Only Statement 2 is correct Full Multi-Book Accounting supports a maximum of five active accounting books not six. In advanced Taxes, you can set tax codes and not just tax schedules against items records for USA editions.

Hi @Nicole Mendoza-Oracle Any updates on this please? thanks

Thanks @Michelle Jabanes-Oracle and User_ZCWF3 I had suggested the workflow option to the user though they wanted to do this through the saved search ideally. If it can't be done through a saved search, I will look to set it up via a workflow. Thanks

Hi @Nicole Mendoza-Oracle Yes please. Thanks

Hi @Richard James Uri-Oracle Apologies for the delay in response. This is the modified script and it is working correctly. I think the usereventtype=create and usereventtype=edit parts of the script were what was causing the issue /** * @NApiVersion 2.x * @NScriptType UserEventScript */ define(["N/url"], function (url) {…

Thanks User_ZCWF3 for the suggestion. I was wanting it to go out automatically rather than the person creating the task having to email the assignee from the record

Hi @Michelle Jabanes-Oracle Does that allow you to send it from a specific field? I couldn't get it to work since it kept asking for a the email in the format "name <emailaddress>" I wanted it to be sent from "<custbody_senderfield>"

Bumping this up again @Micah Timbol-Oracle