Question about hiding a field using multiple criteria

This will show the note for any Orders except ‘RQ’ unless the note is not empty. Simply put, always show non-empty notes and always show any note when not an ‘RQ’ order:

=IIF([SOOrder.OrderType]<>'RQ' Or [Note.NoteTest]<>'')

I’m guessing you want this:

=IIF([SOOrder.OrderType]<>'RQ' And [Note.NoteTest]<>'')

which will show the note for any Orders except ‘RQ’ only if the note is not empty

The [Note.NoteText] needs to be OR because if the Quote is not an RQ, then the NOTE textbox needs to be shown in case there are notes in the [Note.NoteText]. I did try both logic earlier that you have shown, but for some reason, the NOTE textbox still showed up when used in conjunction with the OR and the AND. Any other suggestions? Thank you.

Can you explain what you're expecting (in English, not code) and how you're testing?

Sorry, I just realized the likely issue. Try this:

=[SOOrder.OrderType]<>'RQ' Or [Note.NoteTest]<>''

Or if that doesn't work:

=IIF([SOOrder.OrderType]<>'RQ' Or [Note.NoteTest]<>'',True,False)

I am able to get either of the conditions to work when they are not together, but together, as in your samples above, the NOTE textfield still shows up.

Did you try these with an 'And'? 

The whole point of checking <>'' is that the note doesn't need to be shown if it's empty.

This is definitely possible, but I think your logic is slightly askew.

ChatGPT and CoPilot both had the same suggestions that you suggested and which I have tried before reaching out to the Acumatica Community. I’ve tried OR, AND, IIF statements, and SWITCH. I am certainly open to any other suggestions, and appreciate any help I can get. Individually the statements work, put together they are flawed. Maybe I’m missing something?

Could you attach the report please?

Attached is the report. Down in the left hand corner is the NOTE and another field for the [Note.NoteText], which will have the same logic behind it as the NOTE. I am planning to put a subreport where the NOTE currently resides only if the [SOOrder.OrderType] = ‘RQ’ since this report is multi purpose. I originally had it as a separate report, but that is not what the user wants or need, thus the extra coding for the OrderType and NOTE field(s).

The report actually is SO641000 as it has been modified for any and all quotes we may have. There is also another subreport  (SO641000Sub.rpx) which we are using for the packing information. I just tried using your formulla above, and it appears to be working perfectly for not only the NOTE field but the {Note.NoteText] field also. I apologize for the misspelling of the word Text as Test. I thought I was copying an old formula. Thank you for your patience and working with me on this on a weekend. Now I just have to add a second subreport that has data from the CRRelation table to appear when the [SOOrder.OrderType] = ‘RQ’. Stay safe and many thanks.