"I am trying to recreate the production detail report..."
GOOD LUCK eating that elephant! PDR is a big report with a lot of data in one place. I hope you just want a few bits and pieces.
To answer the basic questions of "what happened?", you should find most of the main data you need in for JobHeader, JobAsmbl, JobOper, LaborDtl, JobMtl, and PartTran. And depending on the level of detail you're looking for, you may not even need all of them.
Basic Structure should be as follows:
JobHeader
____JobAsmbl
________JobOper
____________LaborDtl
________JobMtl
____________PartTran
You're not going to get this data together in a simple BAQ so you'll need to do some back end queries and do some sub-reports to put it all together. The other possibility is to break it up into separate reports. E.g. Labor Detail Report and Material Detail Report or possibly Production Summary Report at higher level without the detailed transactions.)
What are you looking for with the adjustments? I'm not sure what you mean when you say where to the adjustments "go". Labor hours adjustments or mtl/labor qty adjustments are exactly the same as any other "normal" job transaction and hit the same tables. Material qty adjustments create a PartTran record and updates the JobMtl.IssuedQty or JobAsmbl.IssuedQty (depending on whether it's a material or subassembly in the BOM). Labor qty/hours adjustments create a LaborDtl record (no header as I recall) and update the JobOper.ActProdHours (or ActSetupHours) and/or JobOper.QtyCompleted.
Hopefully that's enough to get you started.
Regards,
Chris
GOOD LUCK eating that elephant! PDR is a big report with a lot of data in one place. I hope you just want a few bits and pieces.
To answer the basic questions of "what happened?", you should find most of the main data you need in for JobHeader, JobAsmbl, JobOper, LaborDtl, JobMtl, and PartTran. And depending on the level of detail you're looking for, you may not even need all of them.
Basic Structure should be as follows:
JobHeader
____JobAsmbl
________JobOper
____________LaborDtl
________JobMtl
____________PartTran
You're not going to get this data together in a simple BAQ so you'll need to do some back end queries and do some sub-reports to put it all together. The other possibility is to break it up into separate reports. E.g. Labor Detail Report and Material Detail Report or possibly Production Summary Report at higher level without the detailed transactions.)
What are you looking for with the adjustments? I'm not sure what you mean when you say where to the adjustments "go". Labor hours adjustments or mtl/labor qty adjustments are exactly the same as any other "normal" job transaction and hit the same tables. Material qty adjustments create a PartTran record and updates the JobMtl.IssuedQty or JobAsmbl.IssuedQty (depending on whether it's a material or subassembly in the BOM). Labor qty/hours adjustments create a LaborDtl record (no header as I recall) and update the JobOper.ActProdHours (or ActSetupHours) and/or JobOper.QtyCompleted.
Hopefully that's enough to get you started.
Regards,
Chris
--- In vantage@yahoogroups.com, "brad.ebright" <bebright@...> wrote:
>
> I am trying to recreate the production detail report and need to find out some information. I need to know where the adjustments to jobs go, such as material adjustments, and labor adjustments. I looked through data dictionary viewer, but was having trouble locating where that information is kept.
>
> Thanks,
> Brad
>