Condition Statement in Epicor 9 - Need Assistance

Epicor ERP 9
1

Hello Everyone,

I need assistance in creating a simple if statement.
My logic if a date field is blank then type No if not blank then type Yes.

Here is the code I put into the calculation

image
image750×600 41.8 KB

and it said the logic was fine. Until I executed the report and I received this error.
image

I would appreciate any assistance on this.

Thanks in Advance.

2

Try replacing the “0” with ?

3

Hello Marc,

Now I get the following message.

image
image913×597 60.5 KB

4

If you remove this condition the report works fine? Just trying to confirm it is indeed this expression that is causing the issue.

Try != “” instead of > “0”

5

If JobHead.UserDate2 = “” Then “Y” Else “N”

Now getting this error from the setup (See below)
image

6

If JobHead.UserDate = ? Then ‘Y’ Else ‘N’

1 Like
7

Try this. Do you have another field that is definitely always going to be blank.
If so, then try this, in this example UserDate2 field will always be blank.

If String(JobHead.UserDate1) = String(JobHead.UserDate2) Then “No” Else “Yes”

8

Hello Aeron,

That worked. Thank you.