Open Forum

Expand all | Collapse all

MFG Time Entry - How to reallocate hours across punches

  • 1.  MFG Time Entry - How to reallocate hours across punches

    Posted Apr 21, 2021 04:02 PM
    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
    Twinsburg OH

  • 2.  RE: MFG Time Entry - How to reallocate hours across punches

    Posted Apr 22, 2021 01:00 PM
    No solutions for you unfortunately, but if you figure this out or come across a solution that handles this scenario you laid out, please share and you will have many friends.  This is like the holy grail of shop floor time tracking (OK, that is probably a bit of an exaggeration).  :)

    Ken Sebahar
    Solution Systems, Inc.
    Podcast: A Shot of Business Central and a Beer!

  • 3.  RE: MFG Time Entry - How to reallocate hours across punches

    Posted Apr 27, 2021 04:24 PM
    @Jenn Claridge you may want to jump in here.

    One way to address this Jason is to create 2 parallel resources that need to run at the same time.  One for the operator ​​and one for the punch.  You probably do want to know the time the punch was tied up as the overheads and other costs to operate the punch should be applied against the job for the entire duration it runs.  The other operation for the operator can collect the time the operator works and you can divide the $ per hour cost as you descrbed.

    I've done those calculations before and they can be really tricky.  I think dividing the $ values might be easier than allocating different times.  Maybe create a Fractional field to keep track of what you divided the $ by so you can run reports to calculate the time.

    I also think there might be other ISV solutions that do separate employee labor from machine time.


    Robert Jolliffe B.A.Sc, MCSE, MCS - NAV Manufacturing Expert
    Sabre Limited

  • 4.  RE: MFG Time Entry - How to reallocate hours across punches

    Posted Apr 28, 2021 10:00 AM

    Jason – There are several ways that time could be allocated depending. For instance, if you have a short run Operation that takes 10 minutes or less (ex: cutting operation) you would want the operator to clock on multiple Production Orders all at once and allocate clock time based on quantity % of each Prod Order or Planned time %. This makes the operator more efficient and avoids having to clock in and out multiple times on short run Production Orders.

    INSIGHT Works Shop Floor ISV does provide functionality to clock in on multiple Production Orders and allocate time. The solution captures actual time, provides an online dispatch list, time approval, payroll interface capabilities and a visual drag and drop scheduling tool. The solution provides a few options to allocate time back to Production Orders and I believe addresses the process you are describing.

    Best Regards

    John Grant
    Senior Application Consultant
    Innovia Consulting

If you've found this thread useful, dive deeper into User Group community content by role