Dynamics Report Writer - Calculated Conditional Field with Three "OR" clauses

Like (0) Share

Report

Posted on 4 Jan 2023 17:12:28 by JGarcia123

492

I am working on a SOP Blank Invoice modification, adding a conditional calculated field. In the conditional field I have the following logic. If true it displays one set of text, if not another.

(SOP_Document_HDR_TEMP.DOC Number >= "SWI-0000000000" and SOP_Document_HDR_TEMP.DOC Number <= "SWI-9999999999" and RM_Customer_MSTR.Country Code = "CA") OR
(SOP_Document_HDR_TEMP.DOC Number >= "WEB-0000000000" and SOP_Document_HDR_TEMP.DOC Number <= "WEB-9999999999" and RM_Customer_MSTR.Country Code = "CA") OR
(SOP_Document_HDR_TEMP.DOC Number >= "INT-0000000000" and SOP_Document_HDR_TEMP.DOC Number <= "INT-9999999999" and RM_Customer_MSTR.Country Code = "CA")

The conditional works when evaluating the first or second clause, but the third clause with the "INT-" invoice does not. The supporting data and syntax is valid. My question is does Report Writer support the three "OR" options? Please advise. Looking for some feedback and advice. Thank you.

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

David Musgrave MVP ... 13,982 Most Valuable Professional on 05 Jan 2023 at 04:51:36

Like (0)

Report

RE: Dynamics Report Writer - Calculated Conditional Field with Three "OR" clauses

It should be able to handle multiple OR clauses.

But you could use multiple calculated fields to simplify the final 4th calculated field.

You could also use GP Power Tools to create custom Report Writer functions with any logic you desire in them.

Regards

David