MAS 90 and Crystal Reports XI Work Ticket Transaction Detail Report
MAS 90 and Crystal Reports XI Work Ticket Transaction Detail Report
(OP)
Could someone please guide me on what tables should be linked in Crystal Reports XI to create the work ticket transaction report by item? I need to create a detail ticket breakdown of hrs worked, labor cost and burden cost by employee. I am currently using tables JT_Transaction History, JT_workticket, and SO_salesorder.TransactionHeader. I am not getting the correct hours worked and labor cost.
Any help would be greatly appreciated!!
Any help would be greatly appreciated!!
RE: MAS 90 and Crystal Reports XI Work Ticket Transaction Detail Report
Dawn
Visit Sage's Online Community mmunity.sa gemas.com/ sagemas/?c ategory.id =SageMAS90 and200Disc
http://co
RE: MAS 90 and Crystal Reports XI Work Ticket Transaction Detail Report
I have tried linking a variety of tables to get the work ticket detail but Crystal Reports keeps locking up on me.
RE: MAS 90 and Crystal Reports XI Work Ticket Transaction Detail Report
http://co mmunity.sa gemas.com/ sagemas/?c ategory.id =SageMAS90 and200Disc
RE: MAS 90 and Crystal Reports XI Work Ticket Transaction Detail Report
Dawn
Visit Sage's Online Community mmunity.sa gemas.com/ sagemas/?c ategory.id =SageMAS90 and200Disc
http://co
RE: MAS 90 and Crystal Reports XI Work Ticket Transaction Detail Report
For anyone else whom may need help with this, I was able to finally write the report by going into Mas 90, Job Ops, Custom Reports and selecting to run the Crystal Reports File Generation. This allowed MAS to populate report fields in Crystal Reports that would otherwise be empty.
Next I built the report using the following tables:
JT_21CRWWorkTicketLines
JT_31CRWLaborTrans
JT_3xCRWTransactions
SO_SalesOrderHeader
JT_ActivityCode
Thanks again for trying to help. You did point me in the right direction, I had not considered contacting our data administrator.
Maria