It looks like I should be able to do this with AMClockItem and AMClockTrans but has anyone done this?
We want to have a status screen for production that shows all production orders that currently have an employee clocked in and show the operation(s) that are clocked in as well as the elapsed time it has been clocked in.
Best answer by claytonsummers
We did find a solution but in a different direction. Since we are not set up with the clock time tracking anyway, we are using the Move to do what we need.
When a person starts an operation, they create the move and save it but do not release it. When the operation is completed, the person completing the op releases the Move. The lets us track the operation start and end as well as who started it and who completed it. So far this is doing what we need.
One gotcha, we ended up needing to update to 2022R2 to get the control point in the BOM. Making all of the operations control points insures that each operation get released before the following operation can be released.
It’s not perfect, but is working so far.
+8Hi
I was interested in your question as I think this would be very useful for other as well!
Based on my initial investigation of the data it looks like everything required is in the AMClockItem DAC. To find the clocked in entries look for records in AMClockItem where the StartTime is not empty. Disclaimer is that this I have not yet tested fully.
The AMClockTran record is created when the employee clocks out.
I’ve attached a simple GI that might serve as a starting point.
+3I also created one. The client wanted to know who had clocked on but not off. We also added it as a widget to a dashboard. This is for 2022R2.
Thanks for both of these. I’m looking at them today and will post back if these get us what we need.
OK, dgodsill97’s GI gets us the list of clocked on. Thanks!
Now, for production management, I would like to add the clocked off from AMClockTran as well to have a list of all valid clock entries, both clocked on only and completed.
The goal is to have a side panel on the Production Order Maintenance screen that show all clock items and transactions for a given production order.
Thanks again for your help on this.
Now it opens to a web screen with all the code. Has anyone else ran into this and figured out a way to download it as an xml file?
Update: Incase anyone else had this issue, right click and “Save Link As”
It will automatically save it as an xml file.
+8Hi
It might depend on your browser. In Chrome, you can right-click and choose “Save Link as...”
Hi
We did find a solution but in a different direction. Since we are not set up with the clock time tracking anyway, we are using the Move to do what we need.
When a person starts an operation, they create the move and save it but do not release it. When the operation is completed, the person completing the op releases the Move. The lets us track the operation start and end as well as who started it and who completed it. So far this is doing what we need.
One gotcha, we ended up needing to update to 2022R2 to get the control point in the BOM. Making all of the operations control points insures that each operation get released before the following operation can be released.
It’s not perfect, but is working so far.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
