Search results for query: *

The fields are declared as dates, but there is no value assigned in the database for the "empty" date fields. No data was entered in the date for that inventory item. I am guessing this means a Null value. I need the formula to give me back the last receipt date when the last sold date is null...

Can someone please help me? I am running a crystal XI report showing what the inventory turnover is, and the timeline. I have a column with "Last Sold Date" and another with "last receipt date". I built a formula to show the last active date (shown below)...

Thank you all very much for your replies. I did get a hold of our data manager and got the location of the job ops table layout files. They were located on a different server. For anyone else whom may need help with this, I was able to finally write the report by going into Mas 90, Job Ops...

Yes, that was my initial thought as well. My company just purchased JobOps to add to the MAS90 modules, and the resource section in MAS has nothing for JOBOps. I have tried linking a variety of tables to get the work ticket detail but Crystal Reports keeps locking up on me.

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...

Thank you very much, this was just what I needed.

Can someone please help me identify which tables I need to link in order to pick up the expense accounts for specific depts and a time frame? I have never written a report in Crystal for the GL and am having a hard time finding the table relationships. What tables do I need to link to obtain the...