Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Output Journals in a m...
Microsoft Dynamics NAV (Archived)

Output Journals in a manufacturing environment

(0) ShareShare
ReportReport
Posted on by David Kuziara 1,048

I want to write an app that posts output journals for released prod. order operations.

The pc is logged in as a data capture device rather than the machine operator.

The Production order, op and machine operator are selected and quantities done including set/run times posted via output journal.

My aim is to record "Who" the Machine operator was for that output journal entry so we can then see the 'star operators' and the ones not pulling their weight.

ie. Jo Bloggs produced 120 items in 1 hour for prod order 1234567 op 10.

but Fred produced 30 in 1 hour 15 minutes etc.  (so Jo Bloggs gets reward :-)  )

I was thinking of posting Resource Journals for the 'Person' Resource with 'time' UOM eg minutes.

But, and here is my problem : I can populate the document number (=prod order no) but where do I record the op number for the Resource journal?
(in order to link the output ledger with the Resource ledger line) 

Is there a better way to achieve this aim ?

*This post is locked for comments

  • Suggested answer
    constantin.andronic Profile Picture
    constantin.andronic on at
    RE: Output Journals in a manufacturing environment

    I defined Work center codes for each employee with his own operation and as well a dimension for department/cost center! Based on it we have a Capacity ledger entries report that can allow me to see how many minutes was working each workcenter/employee and with total by dimension cost center as well!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Output Journals in a manufacturing environment

    A good option would be to use an add-on explicitly designed for that purpose.  There are a few out there, including www.dynms.com/.../time-tracker-software and others.

  • Neville Foyn Profile Picture
    Neville Foyn 4,320 on at
    RE: Output Journals in a manufacturing environment

    Happy to help

    Another reason why i would suggest dimensions is they post to the sub ledgers so you can easily do GL and production analysis of the actual transactions in the ledgers

    Cheers

    Nev

  • David Kuziara Profile Picture
    David Kuziara 1,048 on at
    RE: Output Journals in a manufacturing environment

    With that in mind, it's a choice of either  the "Production Order Routing Personnel" table to record the machine operator against the operation, or use your Dimension suggestion.  

    If I use routing personnel, I could use the Employee No for the Personnel No and Employee Name for Description.

    The disadvantage with this is if Fred produces 20 and John produces 25 for the same operation, I would not be able to see who did what.

    This would suggest using Dimensions has the advantage over using the Routing personnel table.

    Thanks Nev.  

  • Suggested answer
    Neville Foyn Profile Picture
    Neville Foyn 4,320 on at
    RE: Output Journals in a manufacturing environment

    Hi

    It would be possible to get the resource ledger to link to manufacturing but would require a lot of customization, especially if you would be looking to do things like timesheets, it could get crazy thinking about allocation the time sheets and costs to the inventory, impact on the GL with the resource costs and usage, etc

    I would recommend against this route as the development could turn into a bit of a monster breaking resources to have it stop processing resource costs and rather start posting inventory overheads

    With this kind of requirement i would think about possibly writing something completely custom to handle the requirement as that will result in less customization to the standard system and the integration can be an exact fit to manufacturing

    Cheers

    Nev

  • David Kuziara Profile Picture
    David Kuziara 1,048 on at
    RE: Output Journals in a manufacturing environment

    There is also the possibility of using "Production Order Routing Personnel" to associate the Employee to the operation.

  • David Kuziara Profile Picture
    David Kuziara 1,048 on at
    RE: Output Journals in a manufacturing environment

    Thanks for that Neville.

    I wish to record the costs and quantities using the machine centres as you said.

    However, I would like to record the hours per Machine operator, which is why I was thinking of Resources.

    The only reason I can see to use the Dimensions is that I can easily associate the Machine Operator with the output journal - which I need to do.

    If I could find a way to associate the Resource ledger (for the operator hours) with the output journal ledger that would be perfect.  We could make use of the time sheets, resource skills etc. provided by the resources module.

    Is there a way to link the two ? (Resource machine operator hours / Output quantities) ?

    or are Resources really not supposed to be used with Manufacturing ?

    Thanks

    Dave Kuziara

  • Verified answer
    Neville Foyn Profile Picture
    Neville Foyn 4,320 on at
    RE: Output Journals in a manufacturing environment

    Hi David

    In manufacturing you don't use Resources for recording costs and quantities, you use Machine centers, however they work in pretty much the same way

    If you dont specifically need to allocate overhead costs and maintain a sub ledger then i would suggest that you rather add a dimension for employee and allocate this to the output lines, then use the dimension to report on the output per employee afterwards

    I have done an integration using machine and work centers and it can be pretty complicated, so i would suggest that you try and use the Dimensions rather if you can.

    Shout if you have any other questions

    Cheers

    Neville

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,492 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans