Microsoft Dynamics NAV (Archived)

Output Journals in a manufacturing environment

(0) Share

Report

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

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Neville Foyn 4,320 on at

Like (0)

Report

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

Was this reply helpful? Yes No
David Kuziara 1,048 on at

Like (0)

Report

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

Was this reply helpful? Yes No
David Kuziara 1,048 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Neville Foyn 4,320 on at

Like (0)

Report

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

Was this reply helpful? Yes No
David Kuziara 1,048 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Neville Foyn 4,320 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

constantin.andronic on at

Like (0)

Report

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!

Was this reply helpful? Yes No