Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Update your Profile with your Support type to get your Support Type badge.
Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.
Don't miss out on our Question of the week! You only have until tomorrow, July 25, 2024, 2PM ET to comment your answers and earn rewards! Click here for more details.
Community Poll: What sort of content would you like to see more of?
Get ready to take on exciting new challenges and become the next SuiteMaster of the Month!

Why does MAX not work within CASE?

Hi All,

I have an 'Item' level search and am also pulling in from its child custom record 'Item Breakdown' to determine items available on hand.

The general idea is that items that come in bulk can be broken down into single items. The 'Item Breakdown' record contains the bulk item code, single item code, and conversion ratio.

The issue is that sometimes there are multiple child Item Breakdown' records that link to one parent 'Item' record. In that scenario I don't need to be exacting and error to the max wth this formula which works:


Formula (Text)Minimum

MAX({custrecord_brkdwn_single.custrecord_bulk_item_available}) * MAX({custrecord_brkdwn_single.custrecord_brkdwn_single_qty})

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

Community Whiz

Quarter 3 (Jul-Sep 2024)

This Week's Leaders

This Month's Leaders

All Time Leaders