Hi @User_JPTT1, Upon checking, the User Notes record used to be a Beta record in REST but is now pulled out in the NetSuite version 2024.1. There is no guarantee if this feature will be available again in the future. We apologize for this limitation. But for your reference, a simple call like this used to work: POST…

Hi @User_ZBIQA, Can you please check the permissions assigned to the role you're using for your integration? (Navigate to Setup > Users/Roles > Manage Roles) Here are some of the permissions I have in my test role that can view custom item fields in the item table. I hope this helps! If you find this reply to your question…

Hello @User_JPTT1 The ability to link standalone vendor bills to purchase orders is currently tagged as an Enhancement under 97075 Bills>Enter bills manually and link them to purchase orders. Its current status is "Future Enhancement", therefore it could be updated on any NetSuite release in the future. The ability to link…

Hello @User_JPTT1, It should be enclosed in an "items" tag. Here is a sample data that I confirmed to work: { "entity": 315, "expense": { "items": [{ "account" : 42, "amount" : 100 }] } } 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…

Hello @Ivan Babiichuk, Good day. Per checking similar cases raised with NetSuite Support, the Last Inventory Count Date is not supposed to be modifiable via Script and even if you are able to modify it, it could be subject to change and stop working anytime. In this case, you will be advised to use a workaround which would…

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

Hello @Dext3r, The parseFloat(1) sets the value of the adjustqtyby to 1. the parseFloat() method ensures it is setting a number. More info on parseFloat() can be found here (not official NetSuite documentation): https://www.w3schools.com/jsref/jsref_parsefloat.asp rec.setCurrentSublistValue({ sublistId: 'inventory',…

Hello @User_ZBIQA, Is this happening to all custom fields or only to a specific field?

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.