I am working on making reports for a client that wants the data filtered by Setup completion date. I’ve searched all through the database and cannot find where this would be coming from. I apologize, I am very new to Epicor data.
Welcome Cody!
You may need to provide more detail here. Are you looking at making a BAQ, or a report? Are you basing the report on some existing reports, or making a new one?
Are you familiar with the BAQ designer? There you can make queries into the Epicor database to get answers to questions your company may have. I expect that a BAQ would be the easiest approach for this request.
Setup is something that happens for each operation of a job. Setup is the time it takes to get the machine ready to produce parts, while production time is the time it takes to actually produce the parts.
If you wan to look at setup time, look into the LaborDtl table. The LaborDtl table holds the entries submitted by users on the shop floor for every operation they work on. In here a field called LaborType has either a P for Production, or S for setup. Filter by labor entries that have LaborType = S, and you have your setup labor entries.
Now you need to know which setup labor entries are complete, and which are not. There is another field in LaborDtl called Complete. This is checked when the setup or production operation is marked as complete. Just filter by complete labor entries that have labor type = S and you have your list of labor entries.
This should get you close to what you need. If you need additional tables attached, do that in this BAQ as well. Post back with any specific questions you have. Good luck!
Nate
Nate,
Thank you for your thorough and patient explanation.
I am creating SQL views of an Epicor database and querying these views into Power BI to create reports.
There is a date slicer at the top of the page that is filtering both reports by Job Completed date. The data is fine, however the client would like both of these filtered by “the date the setup was completed”. I’ve searched the Epicor data dictionary and cannot find where this would be coming from; would it just be the latest LaborDtl date?
I appreciate it
I think you need to dig into what they really mean by this. If your job has three operations, then there are three setups that could be complete or not. Do they want to know that setup is complete for at least the first operation, or that setup is complete for the last operation? (or some arbitrary operation in the middle of the job?)
In short, the setup dates are the labor dtl dates where complete is TRUE and labor type is S.