Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Suggested answer

Time recording on Projects and Production Orders

Posted on by 726

.Wondering if anyone had any experience on this.

Worker A works on a production order and records their time (MAnadfacturing execution>job card device)

He/She then works on a project and record his /her time in the Project time sheet. 

He/She then completes time in separate application which includes vacation/sick etc for payroll

Has anyone any suggestions how to unify these processes?

Thanks for any suggestions

  • Christoph Thaler Profile Picture
    Christoph Thaler 5,442 on at
    RE: Time recording on Projects and Production Orders

    Hi Simon.

    Great to hear that you got some additional ideas how to solve your problem. Do you need any further information? If not, may you please close this question by answering „did this solve your question“ with „yes“.

    Thanks a lot

  • simonsmith101 Profile Picture
    simonsmith101 726 on at
    RE: Time recording on Projects and Production Orders

    Thanks for this fantastic post. It has helped me a lot. Re  your question currently manufacturing staff charging hours in a project via an hour journal and not via a manufacturing process in a project. Maybe it’s worth investigating changing the hour journal to a manufacturing job card that charges Project Wip. 
    cheers simon 

  • Suggested answer
    Christoph Thaler Profile Picture
    Christoph Thaler 5,442 on at
    RE: Time recording on Projects and Production Orders

    Hi Simon.

    If you think about your own application to collect the data and want to transfer them via data management you can use the excel template "HourJournalTransEntryTemplate" for project time information.

    pastedimage1584506865775v1.png

    for production orders you have to decide if you post route card journals or job card journals. The problem here is that there are not standard entities available. So you have to create your own entity. Important to know is that when you use entities to import some data you have to post them afterwards manually. This is not done by the entity as it is a journal / journal line.

    We had a similar topic in the past (connect an external MES system) and solved it in that way that we collect all the data in a new table, not in the journal itself. A batch job is using the data out of the new table to post the journals. Based on a row identifier different journal types where posted. So we where able to handle BOM consumption as well.

    To streamline the process one question from my side: You wrote the Worker A works on a project. Is this work like a production order? I`m asking because maybe it is an option to create a project related production order. In this case the worker will always have a production order. Of course this is just possible if you produce an item. If the job of the worker is something like a service or design work where you do not have a (dummy) item. you cannot use this way.

    I´m not 100% sure but i think it is also possible to have project tracking in the job card device. Maybe you can check this website as it is a very good source for all questions regarding time tracking: https://dyntips.com/ax7ta/

  • simonsmith101 Profile Picture
    simonsmith101 726 on at
    RE: Time recording on Projects and Production Orders

    Thanks Rahul.

    This is sort of what I was thinking. At a very high level are you suggesting Worker A inputs in one place all of their data and underneath the relevant journals for import are created? Would this be using DMF data entities?

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: Time recording on Projects and Production Orders

    if time are not related could just create/upload directly to respective journals in project and production module

  • gkumar Profile Picture
    gkumar 740 on at
    RE: Time recording on Projects and Production Orders

    Hi Smith,

    As there are separate  journals for each type of transaction: Project(Hour), Production (Job/Route card) and Payroll(vacation time) you need a customization to unify and based on checkbox or additional  fields value trigger corresponding journal.

    Regards,

    Ganesh

  • simonsmith101 Profile Picture
    simonsmith101 726 on at
    RE: Time recording on Projects and Production Orders

    Thanks. Unfortunately if the time is on a production order it is NOT related to a project.

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: Time recording on Projects and Production Orders

    if your production order is connected to project, then capture time in project timesheets

    could skip time entry at production order level

    alternatively could capture job card time in production and it would rollup in project

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans