Best Of
Re: Sourcing with Custom Records
Hi Angelica
thanks for the SA reference.
the thought of solution is not working and has limitations. we will choose the scripting as guided by you. thanks for offering the help during the implementing the scripting solution. i have the refered SA ID will help us start.
thanks
Ahmed
AhmedM
Re: Introduce Yourself!
Hi All,
I've been deploying Netsuite to customers for over 10 years. Finally able to move beyond configuration and getting others to do scripting. Got my hands dirty doing scripting since mid-2022, learning Javascript and SuiteScript 2.x at the same time. Moving a little beyond novice and still finding endless new grounds with curiosity.
Fun facts…wanting to be able to cook something nice. Learning and often making a mess. Like scripting, there are endless nice possibilities, but unlike scripting, there won't be any bugs. :-)
Re: How to remove unwanted items from a bundle
Thank you @Angelica Mae Segador-Oracle!
Indeed, the fields were used in Workflows! :)
Re: PO saved search: how to get email of "Created By" person?
Hi @KevinWong
You could use the filling steps:
(1) Create a custom Created By field.
Type = List/Record.
Store Value = T.
List/Record = Employee.
Validation & Defaulting> Dynamic Default = Current User.
Save.
(2) Create a custom field Created By Email
Type = Email Address.
Store Value = T.
Source & Filtering> Source List = custom Created By
Source & Filtering> Source From = Email.
Save.
Then you can pull the send field onto your report.
Re: Timezone used on PDF Documents
Great! I'm finally on top of it. I really appreciate your help with this matter.
Many thanks,
Edo
Re: Enabling statistical accounts
Hi @Elina Kourouzidou
Yes @Patrick Fresnosa-Oracle is correct, Pls check your NS license
NetSuite Advanced Financials brings additional financial management functionality. It includes budgeting, expense allocations, and amortization, and statistical accounts.
Re: How to Create a NetSuite Formula to Display Blank for Project End Dates Past Today's Date?
You're welcome @CDuf I have updated the title to How to Create a NetSuite Formula to Display Blank for Project End Dates Past Today's Date?
Hi @User_8ITTC,
Will this formula work for you? 🙂
Re: How to turn off Inventory Status Control
Hi @DMurph,
This is maybe caused by existing inventory counts. Kindly do the following:
- Navigate to Lists > Supply Chain > Inventory Statuses
- On the Inventory Statuses Page, right click on any part of the page > Click Inspect > Click Console
- On the Console, kindly paste the details below:
var filters = new Array()
filters[0] = new nlobjSearchFilter('custrecord_sc_inventory_status',null,'anyof',['2','3','4','5'])
var columns = new Array()
columns[0] = new nlobjSearchColumn('internalid')
columns[1] = new nlobjSearchColumn('custrecord_sc_inventory_status')
var searchResultObj = nlapiCreateSearch('customrecord_sc_item_count_details', filters, columns).runSearch()
var resultObjects = searchResultObj.getResults(0,100)
for(i = 0; i < resultObjects.length; i++)
{
console.log(resultObjects[i]);
nlapiDeleteRecord('customrecord_sc_item_count_details',resultObjects[i].id);
}
- Once pasted, click enter and wait for it to finish, then refresh the page.
After the steps above, you may now delete the non-default status:
- Open [non-default] Status
- Click Edit
- Click on Actions, then click ‘Delete’
You should now be able to delete the [non-default] Status.
To disable Inventory Statuses, kindly perform the following steps:
- Navigate to: Setup > Company > Enable Features
- Click on the Items & Inventory Tab
- Look for and uncheck Inventory Status
- Scroll to the Top of the page and Click Save
The Inventory Status should now be disabled on the account.
Re: Revenue Arrangement Issue
That's very helpful thanks both! I've learned a lot about this subject over the past few days!!



