usejurissuite.blogspot.com
Using Juris Suite: March 2010
http://usejurissuite.blogspot.com/2010_03_01_archive.html
Michael Wasco, CPA, has been working with Juris for over 10 years, and has been with Kinol Sharie Leyh and Associates in Pittsburgh for 12. He is the author of this blog, and has years of experience in report writing to share with you! Wednesday, March 31, 2010. The most commonly used data types in the Juris database are: varchar(#), decimal(#,#), money, int, datetime and text. Int - holds an integer value. Integers are whole numbers only. If you attempted to enter 1.9 into an integer field, ...Text - a ...
usejurissuite.blogspot.com
Using Juris Suite: Writing Queries in Juris: Colors!!
http://usejurissuite.blogspot.com/2010/04/writing-queries-in-juris-colors.html
Michael Wasco, CPA, has been working with Juris for over 10 years, and has been with Kinol Sharie Leyh and Associates in Pittsburgh for 12. He is the author of this blog, and has years of experience in report writing to share with you! Tuesday, April 13, 2010. Writing Queries in Juris: Colors! When you begin writing queries in Juris Suite, you will see that certain words and phrases get special colors. These colors will help you because each color is associated with something special in SQL. Client.C...
usejurissuite.blogspot.com
Using Juris Suite: May 2010
http://usejurissuite.blogspot.com/2010_05_01_archive.html
Michael Wasco, CPA, has been working with Juris for over 10 years, and has been with Kinol Sharie Leyh and Associates in Pittsburgh for 12. He is the author of this blog, and has years of experience in report writing to share with you! Monday, May 24, 2010. Sorry for the lack of updates. Things are.busy. You would have to first design the scoring matrix for each value. Let's say our firm has a partner minimum hours worked per month of 150. The question is do you give some leeway? Next, let's say that his...
usejurissuite.blogspot.com
Using Juris Suite: Writing Queries in Juris 101 - Step 3 (defining the query)
http://usejurissuite.blogspot.com/2010/10/writing-queries-in-juris-101-step-3.html
Michael Wasco, CPA, has been working with Juris for over 10 years, and has been with Kinol Sharie Leyh and Associates in Pittsburgh for 12. He is the author of this blog, and has years of experience in report writing to share with you! Thursday, October 7, 2010. Writing Queries in Juris 101 - Step 3 (defining the query). OK, so you've got your marching orders to write a report. Now what? Now, you can check the boxes that you want to show. Obviously, the utility of such a query is limited because you'd ha...
usejurissuite.blogspot.com
Using Juris Suite: "Grading" Professional Staff
http://usejurissuite.blogspot.com/2010/05/grading-professional-staff.html
Michael Wasco, CPA, has been working with Juris for over 10 years, and has been with Kinol Sharie Leyh and Associates in Pittsburgh for 12. He is the author of this blog, and has years of experience in report writing to share with you! Monday, May 24, 2010. Sorry for the lack of updates. Things are.busy. You would have to first design the scoring matrix for each value. Let's say our firm has a partner minimum hours worked per month of 150. The question is do you give some leeway? Next, let's say that his...
usejurissuite.blogspot.com
Using Juris Suite: December 2011
http://usejurissuite.blogspot.com/2011_12_01_archive.html
Michael Wasco, CPA, has been working with Juris for over 10 years, and has been with Kinol Sharie Leyh and Associates in Pittsburgh for 12. He is the author of this blog, and has years of experience in report writing to share with you! Tuesday, December 6, 2011. Writing Queries in Juris 101 - Step 4 (Date Functions). Before I get into the actual post.I'm going to try to better at updating this. So bear with me. Year(@date) extracts the year from a given date. WHY would you use this? So, to utilize these ...
usejurissuite.blogspot.com
Using Juris Suite: Writing Queries in Juris 101 - Step 4 (Date Functions)
http://usejurissuite.blogspot.com/2011/12/writing-queries-in-juris-101-step-4.html
Michael Wasco, CPA, has been working with Juris for over 10 years, and has been with Kinol Sharie Leyh and Associates in Pittsburgh for 12. He is the author of this blog, and has years of experience in report writing to share with you! Tuesday, December 6, 2011. Writing Queries in Juris 101 - Step 4 (Date Functions). Before I get into the actual post.I'm going to try to better at updating this. So bear with me. Year(@date) extracts the year from a given date. WHY would you use this? So, to utilize these ...
usejurissuite.blogspot.com
Using Juris Suite: Schemas
http://usejurissuite.blogspot.com/2010/04/schemas.html
Michael Wasco, CPA, has been working with Juris for over 10 years, and has been with Kinol Sharie Leyh and Associates in Pittsburgh for 12. He is the author of this blog, and has years of experience in report writing to share with you! Monday, April 5, 2010. For example, look at the AR Fee Allocation Schema. This links the ARBill, ARFTaskAlloc, Employee, Matter and Client tables together. What could you get out of this? How can you get all of these different items? Subscribe to: Post Comments (Atom).
usejurissuite.blogspot.com
Using Juris Suite: Writing Queries in Juris Suite 101 - Step 1
http://usejurissuite.blogspot.com/2010/06/writing-queries-in-juris-suite-101-step.html
Michael Wasco, CPA, has been working with Juris for over 10 years, and has been with Kinol Sharie Leyh and Associates in Pittsburgh for 12. He is the author of this blog, and has years of experience in report writing to share with you! Tuesday, June 1, 2010. Writing Queries in Juris Suite 101 - Step 1. OK, so since I write in text, and because it offers to me the most powerful options available, I tend to teach what I know. And since I know the text-based side, I'll teach that. My Linked In Page.