Best Of

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})

Hi All

I found this Knowledge Article 8930 useful. Please let me know if there is any other way for mass attachments using import method, thanks!

Attaching Files to Records

Published 03/04/2011 11:44 AM  |   Updated 05/08/2022 11:02 PM  |   Answer Id: 8930