I apologize for the subject of this thread, as it may not adequately describe what I'm trying to accomplish.

1. We use MFG Time Entry from Cost Control to capture labor against prod. orders in our factories.

2. We have enabled the option that allows for one badge to be clocked into multiple prod. orders at a time, as we have some work cells where a single employee will have 4 separate prod. orders running through the power coating line at once. They punch into each as they hang the parts on the line and punch out of each when they take the last of the items down from the line. There are also scenarios where a single Employee may process multiple Prod. Orders concurrently across multiple mesh welders. The scenario comes up fairly often.

3. The problem is that the duration of the punch is being applied to each prod. order directly. In the above example, let's say the Employee is clocked into 4 prod. orders all for exactly 1 hour each. Today, the system is treating that as 4 hours of labor applied to each prod. order (that Employee is somehow completing 4 hours of work in 1 hour). In reality, the Employee is spending equal time on each, so 15 minutes each. Posting 60 minutes of labor skews the labor cost of the prod. order when realistically it's just 15 minutes of effort.

I don't believe this is part of the MFG Time Entry add-on (unless a new version accommodates it?), so I'm looking to modify it myself. I was thinking of adding an action to the Time Entry Approval page that the approver could click prior to approving entries, and somehow this action would update the duration being approved. Has anyone done something similar that would not mind sharing their approach with me? I'm at a bit of a loss as to how to write the C/AL function to process this. It gets tricky because in the real world, the concurrent punches don't always start and stop at the same time, and I would need to come up with a way to somehow calculate the proper redistribution of that labor.

Here's a more realistic example:

RPO1 - punch in 1:45PM punch out 3:15PM (1.5 hour duration)

RPO2 - punch in 2PM punch out 3PM (1 hour duration)

RPO3 - punch in 2:15PM punch out 2:45PM. (0.5 hour duration)

So, the Employee has 15 minutes at the beginning, where they are only working RPO1. Then, there is 15 minutes of overlap between RPO1 and RPO2. Then the Employee is concurrently logged into RPO1, RPO2, and RPO3 for 30 minutes. There is then another 15 minutes where RPO1 and RPO2 overlap, before finally the Employee wraps up with 15 minutes on RPO1.

For the 15 minutes where two prod. orders are concurrent, each would get 7.5 minutes. For the 30 minutes where 3 are concurrent, each would get 10 minutes.

RPO1: 15 + 7.5 + 10 + 7.5 +15 = 55 minutes (vs 90 minutes in the current model)

RPO2: 7.5 + 10 + 7.5 = 25 minutes (vs 60 minutes)

RPO3: 10 = 10 minutes (vs 30 minutes)

------------------------------

Jason Luchka

Senior Enterprise Applications Analyst

siffron

Twinsburg OH

------------------------------