Best Of

Quick update -

Support pushed out a fix for this on 6/25

Defect 676224: Global search not displaying certain records

In order for everything to work again I had to follow these steps for each of the custom records we had the issue with:

1. Go to the custom record and go to Edit mode

>Uncheck the INCLUDE IN GLOBAL SEARCH checkbox

>Save the record

2. Go back to the custom record on Edit mode

>Check the INCLUDE IN GLOBAL SEARCH checkbox

>Save the record

Everything is now back working again ?️

User_QN43D

Just to set the stage: Our implementation is for NetSuite standard (not OneWorld). We do not license NetSuite Planning and Budgeting separately.

We leverage "Multiple Budgets" in SetUp>Company>Enable Features>Accounting>Advanced Features. (check or ask your administrator to see if you are entitled to it).

We then load a Budget by Budget Category for each year we are forecasting(as you can se we can Budget by Customer, Item, Class, Department, Location and Account Type)

There are some delivered Budget vs Actual Reports available.

We also leverage the ODBC connection to pull data into a SQL database for varied reporting.

Hope this gives you some ideas.

Thanks for confirming and apologies for not so soon reply @Amjad Kasem.

To be able to filter the Receive Shipments field on the Package record per your requirement using the Custom Field Filtering feature, the Request to Forward Shipments Child Record sublist on the Received Shipment Record must be converted to a List/Record or Multiple Select field to be matched with the Ship Request to Forward Reference field in the Package record, since Child Record Sublists are not yet supported in the filtering options.

Also, there should be a Customer field created in the Received Shipment Record to use as a matching filter field for the customer on the Package record.

After you make the above adjustments, configure the filtering settings for the Received Shipments field on the Package record according to the screenshot below to get your desired result:

Related SuiteAnswers Articles:

10093: Dependent Dropdown Lists

99662: Dependent Dropdown Lists Example

Hope this helps.

If you find this reply to your question useful, others might be as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to help the community members who might have a similar concern find the answer easier and you will also get closer to earning your next Answer Accepter badge.

-Jack

Good morning Joy

Just to update you, this problem was a browser issue.

If users start to report issues of this nature which seem localised then the answer is usually local. I instructed the users using the below to clear their browsers and cached data and this resolved the issue.

The way in which it was identified as being a browser problem was that I asked them to use another browser to see if the same problem occurred.

Thank you for your time and input.

Kind regards

Oliver

Hi,

I think that :-

CASE WHEN {quantity}-{quantitybilled}>0 THEN 0 ELSE 1 END

and test for this being 0 again would work.

Kind regards,

Steve

Hi @RobertBongers,

Adding the Work Order and Financial History permissions gave me access to the Work Order's Related Records tab.

Can you confirm if a different form is set as the preferred for the roles in question? If so, the Related Records tab may be hidden from the form.

Hi @Kristoffer Viray-Oracle

That wouldn't work as it's not looking for a particular phrase and is just extracting a number (while here, I need to extract anything after the phrase and before the first blank space after the phrase).

The following is working

REGEXP_REPLACE({incomingmessage}, '^.*?(our purchase order number|the purchase order number|the purchase order number is|purchase order no|PO number|po number|po no|purchase order)\s+([0-9a-zA-Z-_()/]+)?.*$', '\2',1, 1,'imn')

It does need a second field to get rid of the additional text that is extracted by this formula. The second field's formula is:

NVL(SUBSTR({custevent_po_lookup}, 0, INSTR({custevent_po_lookup}, CHR(10))-1), {custevent_po_lookup})