OliverOO Red Ribbon

Thanks, I have already done this. The challenge I was having is saved search formula.

Thank you Red Velasco, it would be great if you can elaborate on #1 second bullet.

Hi, I am trying to create a customer saved search that shows country iso 3 letter code. NetSuite currently is able to display iso 2 letter code. Some suggest saved search formula like CASE WHEN… but that would not possible for 250 countries. I believe there should have a better option.

There are about 250 countries and the formula will be very very long. Isn't there a better way?

Unfortunately there are over hundred users and more than one to two years to track. So system note approach is not productive for us. Thanks, anyway.

Thanks for the saved search Michelle. I tried to run the search and it took for a long long time and timed out/unexpected errored. We have over 100 users and half an dozen integration users. I filtered non admin/integration role, but still having performance issue due to gigantic data. Any suggestion to optimize the saved…

Great! Thank you so much for your help, Francesca. You are the best!

True

We have around thousand scripts. It's not productive way to open each script and look for the Ext JS Library. Any suggestion to find them with better way?

Thank you so much for your in-depth analysis and sharing detail road map how it should be proceeded. I'll definitely reach out to our inhouse developers and see how it works out. I really appreciate your help. Oliver

No worries, Jack. When asset depreciation is run, journal (system generated) is created automatically (So is true for other types). On that journal the Journal Entry Type field pic#2 should be inherited from Asset's JE Type pic# 1 which is Fixed Asset. Thanks, Oliver

Hi Jack, Hope things are going well for you. Please see screenshots below. We want to map from Asset custom field (JE Type that is a list/record type) pic# 1 which is always Fixed Asset to a custom field (JOURNAL ENTRY TYPE that is a transaction body field type and list/record type) pic# 2 of system generated journal for…

Thank you, Micah. I'll check again in next month.