Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Inventory Last Active Date Calculation with empty date values
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)...- MBGuidry
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
MAS 90 and Crystal Reports XI Work Ticket Transaction Detail Report
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...- MBGuidry
- Thread
- Replies: 5
- Forum: Sage 100 ERP (fka Mas90/Mas200)
-
MAS 90 and Crystal Reports GL Detail Posting
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...- MBGuidry
- Thread
- Replies: 3
- Forum: Sage 100 ERP (fka Mas90/Mas200)
