Linking part transactions to which department the user is logged into?

Epicor ERP 10
1

Hello All,

I’m new to the Epicor world so please bare with me. We’re trying to build a report that tracks how many transactions a user is responsible for, but want it separated out by which department the user is clocked into at the moment.

I was looking at building a SP that finds clockin and clockout times and then finds transactions based on a time frame, but the only time stamp I could find in PartTran is sysdate and systime. However, i noticed the sysdate and trandate sometimes do not match. What is the difference between these two fields?

Any suggestions would be greatly appreciated!

2

sysdate is date of actual record creation - where trandate is the date of the transaction.