Finance | Project Operations, Human Resources, ...

DD Earnings Statements report hiding pay rate for pay codes

(1) Share

Report

Posted on by Vivian L

I am trying to hide Pay Rate for the COMM Pay Codes using Conditional Calculation fields for the Pay Rate in the DD Earning Statement RW Report..

To be able to have 0.00 PayRate and then to hide it I added expression:

uprWorkChkDesc.Pay Code Array[1]=COMM

True: 0.00

False: uprWorkChkPayRate Array[1]

Although the Pay Rate prints for this Pay Code still. What should I change to to make the result equal to 0.00 ? Should I use any other array field in the expression?

Thanks,

Vivian

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Hokuminaria 2,950 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Vivian,

Thank you for your forum question.

One thought i have is, what if you set the true case to be blank. Then you can set the field to hide when it prints blank in the Report Field Options window for your calculated field.

I hope this helps!

Thank you!

Was this reply helpful? Yes No
Vivian L 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Brandon. I will try it and will update you later on.

Was this reply helpful? Yes No
Vivian L 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Brandon,

I tested the report and empty value does not work for my calculated conditional field, it should be the value in True Case and False Case. True case should be Currency Value: 0.00. Although something does not work for this report and it shows Pay Rate for the Pay Code notwithstanding.

Was this reply helpful? Yes No
Hokuminaria 2,950 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Vivian,

Thank you for your response.

These reports that use arrays can be tough to modify.

Moving forward, what if you use the Payment Work Check Table for your initial expression like the TRUE case is using. The original Arrays are all off the Payroll Work Check Table. You are currently using the Payroll Check Description table.

If that does not work, can you provide a screenshot of your calculated field as well as a screenshot of how the report looks?

It might be faster to create a support case if this is urgent so an engineer can focus on this.

I hope this helps!

Thank you!

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like
a
(0)

Report
Copy link

Link copied!

In my opinion you need some dexterity code to fulfil this requirement.

Was this reply helpful? Yes No
Vivian L 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Brandon,

I am aware of the arrays and I have added 12 Arrays fields. I used Payroll Check Description Field for the Pay Code field that appears there while I do not find it in the Payroll Work Check Table. I do have a feeling that I have to try another field but I don't find which one because Pay Rate is based on the Pay Code that is available in the Check Description Table. Here is in my Conditional Calculated field. It is pretty simple but RW does not react to any condition even both zeros for both cases True and False. What field should I try instead of the uprWorkChkDesc.Pay Code Array?

uprWorkChkDesc.Pay Code Array[1]=COMM

True: 0.00

False: uprWorkChkPayRate Array[1]

Thanks,

Vivian

Was this reply helpful? Yes No