Best Of

Re: AP automation integration

What business problem are you trying to solve?
What do you need that NetSuite does not already provide?
Do you already have a list of requirements/business gaps?
I know you said you are in Australia do you have the OneWorld version?

Have you considered business process change instead of purchasing additional software, if NetSuite handles what you need…

Have you searched Customization>SuiteBundler>Search & Install Bundles for NetSuite Platform Solutions Group or several other terms…(payable, Bill, etc) for options.

Or look in SuiteApps>… I first search for Oracle NetSuite solutions. If you see something that will solve your business issue, discuss with your account manager (some might be included)

If you still need to look for a different solution… my advice is if a product has BOTH the features you are looking for AND a "delivered" integration to NetSuite.

Using a 3rd party integrator can work if someone in your organization is already familiar with it.

Building a custom integration is my LAST choice.

Interested in which way you go. Best Regards,

CDuf

2

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

1

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. :-)

Frankey

1

Re: How to remove unwanted items from a bundle

Thank you @Angelica Mae Segador-Oracle!

Indeed, the fields were used in Workflows! :)

Elina Kourouzidou

1

Re: issue with set up new account

No Problem, did that!

User_JRLEH

1

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.

Tafara

1

Re: Timezone used on PDF Documents

HI @Nicole Mendoza-Oracle,

Great! I'm finally on top of it. I really appreciate your help with this matter.

Many thanks,

Edo

Edo_Aroni

1

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.

Tiru Chembeti

3

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? 🙂

Patrick Fresnosa-Oracle

1

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.

Niks Blando-Oracle

1