Francesca Nicole Mendoza-Oracle Gold Crown

Hello @Dext3r, This is possible with scripting. You can use the code we worked with in the discussion thread below as your reference. https://community.oracle.com/netsuite/english/discussion/4492343/unable-to-set-location-at-line-level-on-inventory-adjustment-record I hope this helps! If you find this reply to your…

Hello @Ken Davies, I'm sorry to hear that. This is the only workaround I could think of right now. Seems like it would ultimately come down to scripting.

Hi @Benjamin Paul - USA, This is expected behavior because purchase orders are considered expenses.

Hello @Ken Davies, The field type I used is a free-form text. Long text won't work on the Saved Search. is it still feasible for you to change it?

Hello @Ken Davies, Glad to hear you found it. May I know if it is working now?

Hi @Ken Davies, Can you provide a screenshot of the configuration of your custom body field for custbody17 so that I can replicate it on my account? As for the created from field, here is how I was able to get the Create From : Internal ID.

Hi @User_RG1MF, The next approver field could have been set by a client or user event script upon creation/edit via the UI.

Hello @Ken Davies, The field in the search column should be the field in your Item Fulfillment, which is Customer Notes(custbody17) if I am not mistaken.

Hi @CDuf, I have not encountered NetSuite instances that have stored SQL procedures so far. I believe it is currently not yet within standard NetSuite features for SuiteQL. Tagging here some of our members in the community in case they know a workaround: @Tigran Shahnazaryan @MTL_MIA @Amanda Edwards @Hormese Paul @Brian…

Hello @Ivan Babiichuk, Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter.

Hello @CDuf, I will be splitting this discussion so it won't mix with Benjamin's concern. Thank you!

Hello @Benjamin Paul - USA, If I am not mistaken, you were referring to the NetSuite SuiteQL Query Tool created by a third party. Due to this, we cannot provide insights as it is not a standard NetSuite application. Please correct me if I am wrong. Reference: https://timdietrich.me/netsuite-suitescripts/suiteql-query-tool/

Hello @Vernita, Sure thing! We sent you an email for the account details and will file a case on your behalf.

We're searching for the value of the IF Notes field in the Item Fulfillment linked to the SO using the Item Fulfillment's "Created From" field. And then assign this saved search to the custom field's Search field in the Validation and Defaulting subtab. The result of the search will be set as the value of the field.

Hello @Vernita, Good day. I've exhausted every possible value for the date field but none seems to work. It is not limited to custom fields as I also tried this with standard date fields. All the previous cases filed with this concern are resolved by format.format(options) but even that is not working. It would be best to…

Here's the setup I did for the Sales Order notes field: Note: Since I used the Maximum summary type, the text may change if you have multiple Item Fulfillments against one sales order.

Hello @Ken Davies, To source the Item Fulfillment's notes field into Sales Order, I tried using summary search to set the value of the custom notes field in the sales order but it only works after editing the Sales Order. To source data from the Item Fulfillment instead of Sales Order when creating invoices, you must use a…

Hello @Elizabeth Vance, Sourcing sublist line fields can only be done with scripts. As of now, it is not possible to do it via formula or workflow. We apologize for this limitation. I also believe that this would be convenient to have. If you'd like to, you can file this as a SuiteIdea. I hope this clarifies it. If you…

Hello @Rags_pro, Just following up in case you missed my previous comment. Thanks!

Hello @Dext3r, Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter.

Hello @H3NO5, Good day and thank you for posting this new thread! Hello everyone! We kindly seek your support. Your active participation in aiding a fellow member is genuinely appreciated.

Hello @User_THXYN, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support.

Hello @User_2HBPR, Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter.

Hello @Elizabeth Vance, What formula did you use to get the vendor name?

Hello @Rags_pro, It is now possible to create Scheduled Scripts and Map/Reduce instances within any server-side script type using task.create(options). I hope this helps. If you find this reply to your question useful, others might as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be…

Olá @User_YU40U, Eu queria verificar para ter certeza de que você não perdeu minha mensagem anterior. Se você precisar de mais ajuda, não hesite em nos contatar.

Hello @Jay_Mutual Assurance, Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter.

Hello @User_WXEKR, Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter.

Hello @Menno Verbon, Just a quick follow-up to ensure you didn't overlook my earlier message. If there's anything more, please don't hesitate to inform us.

Hi @Vernita, We're still investigating this. I can replicate the behavior but have not found the root cause of it. There are also no recently reported cases or issues related to this so far. I'll get back to you once we have updates. Thank you.