Any way to use Epicor calculated fields?

I think my problem might not that the field that I thought it should be actually is wrong and I won't need the calculated field if the fix goes through correctly. But the field that I am (was) looking for is on the time and expense screen. Tabs "time" "daily time" "Summary" "detail". The field is on the bottom row, total labor.

But like I said, I don't think that this is the actual field that I want. I'm looking for pay hours, and I think my system isn't taking out the lunches correctly so the pay hours is showing 30 min (or an hour depending on the shift chosen) too high because it's not taking out lunch automatically. The total labor is taking out that time, so I was thinking that the total labor was the pay hours with the lunch taken out, but through the process I'm realizing that total labor is actually the total time when someone is clocked into a job, or indirect labor, not actual clock in-out pay time. They are just basically the same in enough cases that I was tricked into thinking they were the same.

Once our test system comes back up I'll try to confirm this (we had lots of crashes yesterday on day 2 of our go live). On another thread, someone showed me that there is supposed to be a fix for this problem.

Thanks for your help.
Brandon
I'm trying to write a dashboard and want to the the Total Labor value that shows up in the Time and Expense entry. It looks like it's a calculated field in the form. Is there a way to use that value or find the SQL query that Epicor is using to calculate that field? I suppose if I had access to customization I would be able to get it out of there huh?

Anyone willing to copy and past the code for me?


Epicor doesn't typically share what goes into a calculated field.  Many of them you can figure out to the point that you are OK with the results.

As you infer with reference to customization, you can also use the Business Object that has the calculated field in its dataset.

You could also write a BPM that copies the value into a physical field that you can use directly in your dashboard.

Jim Kinneman
Encompass Solutions, Inc
Which field specifically? where is it on the screen?


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Wed, Mar 2, 2016 at 3:25 PM, brandonanderson7979@... [vantage] <vantage@yahoogroups.com> wrote:

Â
<div>
  
  
  <p>I&#39;m trying to write a dashboard and want to the the Total Labor value that shows up in the Time and Expense entry. It looks like it&#39;s a calculated field in the form. Is there a way to use that value or find the SQL query that Epicor is using to calculate that field? I suppose if I had access to customization I would be able to get it out of there huh?<br><br>Anyone willing to copy and past the code for me?<br></p><p><span><br></span></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>