New Help Video Shows Parts Inventory Report In TATEMS Plus Inventory Spreadsheets
In this TATEMS Fleet Maintenance Software video below I show you the Parts Inventory Report and Inventory related spreadsheets
I go over:
- Where to Find The Parts Inventory Report Inside TATEMS
- The Exclude Parts Types popup box that displays after you click preview or print
- What The Parts Inventory Report Actually Displays
- Parts Inventory Related Spreadsheets you can download and link to your live TATEMS data
- How to link those spreadsheets to TATEMS and how to filter the data for specific columns
This Video will also be added to the Help Videos page at
Thanks For Visiting and if you like this content please share and like it for us!
All The Best!
Marc
New Help Video Shows Latest Backup and Compact Data Features
In the video below I show you the latest backup features in TATEMS Fleet Maintenance Software.
I go over:
- Compact Checkbox
- How to Restore from a failed backup
- How To Choose A Backup Location
- How To Setup Preferences for Auto Backup when Closing or Ask To Backup When You Close TATEMS
This Video will also be added to the Help Videos page at
Thanks For Visiting and if you like this content please share and like it for us!
All The Best!
Marc
New Video Shows – The Monthly Miles Traveled and/or Hours Run Spreadsheet That Links to Your Live TATEMS Data
In the video below I show you the newest spreadsheet report that you can link to your live TATEMS data.
It will show you hours run and or miles/km traveled for each equipment per month.
I also show you how to link it to your live TATEMS data.
All the custom spreadsheet reports that you can link to your live TATEMS are here:
https://tatems.com/fleetmaintenancesoftware/spreadsheets.cfm
If you have any ideas for more spreadsheet reports for your TATEMS Fleet Maintenance software please let me know!
Thanks For Visiting and if you like this content please share and like it for us!
All The Best!
Marc
Video of Top 9 Updates to TATEMS Version 4.5.04 released Nov 16 2013
Hi,
I just wanted to give you a quick video rundown of the top 9 updates out of about 24 updates released starting with version 4.5.00 through 4.5.04
Click here to watch a non-YouTube version of video
Here is the list that I go over in the video:
1) Added Repair Codes Fields to Work Orders Labor and Parts Screens so that you can better categorize costs when multiple repair categories done in a single Work Order
2) Added list of 15 Repair Codes and descriptions to Repair Codes List
3) Added new report All Equipment Reports-Repair Codes Cost / Mile/km / Hour Report
4) Added new report under Work Orders in More Reports called All Work Orders Repair Code Totals by Repair Code
5) Added new report under Work Orders in More Report called: Work Orders Total Costs by Repair Code
6) Added Dropdown List Maintenance choice for Repair Codes
7) Added Work Orders List under forms menu to allow you to see all work orders in one sortable list that show you All or Completed or Non-Default Tax Rate work orders and be able to click to view/edit and work order in the list
8) Added new Work Orders report under More Reports called: All Work Orders with non-default sales tax charged
9) Added Edit button to Parts inventory screen to help prevent accidental overwriting of current parts in inventory and changed add button to prevent accidental scrolling to previous record
You can see all the updates here:
http://tatems.com/updates/updatelist.cfm
and I have added a new training video to the updates page where you can download the current update
Thank you for your interest and please leave any comments below.
Marc Ready
TATEMS Reminders Add-on Program Video Demo and a new spreadsheet Video too!
I hope you had a nice Christmas and New Year!
This first video is a demo of a new spreadsheet requested
It is called
TATEMSEquipPartsAndLaborTotalsWithCustomerAreaDeptLocationMakeModelYearAndCurrentODO
Another nice short (but descriptive) name, I know…
It was created because the client wanted to be able to see Parts and Labor Totals for Model and or Year of Equipment and other fields like Equipment Location.
It is spreadsheet number 64 at:
http://tatems.com/spreadsheets
I forgot to show you how to filter it by the columns at the top but you can see how on one of the other videos I made here:
http://blog.tatems.com/new-equipment-list-with-out-of-service-column-plus-video
at about the 40 second mark.
And this second video gives you about a 4 minute demo of the new TATEMS Reminders program that we are working on.
I did not use Zoom on the TATEMS Reminders video so you may want to click the Full Screen button on the lower right side of the player.
Let me know if you would like to see a custom spreadsheet created that we can share with our users too!
Make sure you click the Facebook like button and leave a comment if you would like to try the beta version of this new add-on.
Thanks Again And Have a Great Week!
New Inspections/Permits spreadsheet and video
I'm going to change things up a little and put the tip at the top…
Now on to today's Tip:
Last week one of our clients asked if we could create a spreadsheet that would display all the items on the Inspections/Permits tab in TATEMS for all equipment.
This new spreadsheet links to your live TATEMS data and will display the following fields which you can now filter and sort any way you want to in Excel.
Equip #
Desc
Last DOT Insp
Next DOT
Last 90 Permit
Next 90 Day
Last Annual State Insp
Next State Insp
Last Over OverAxTollerance Permit
NextOverAxle Permit
Last Motor Carrier Certificate Reg
Next Motor Carrier
Last Smoke Insp
Next Smoke Insp
The spreadsheet is called:
TATEMS-InspectionsAndPermitsLastAndNext.xls
It is spreadsheet number 62 on our Spreadsheets page:
http://tatems.com/FleetMaintenanceSoftware/spreadsheets.cfm
If you have Excel 2007 or 2010 and you are running a 32 bit version of Windows and your TATEMS data is NOT on a server or other computer then you should be able to simply open and run this spreadsheet.
In the video below I show you how to use it on either a 64 bit version Of Windows or if your data is housed on a server. I also show you how to Filter and sort the data in this spreadsheet.
Other random stuff…..
As I write this on Saturday afternoon, it's suppose get up to 94° F today and we've had a few thunderstorms here in Las Vegas. The Gas prices at our local Sam’s club is at $3.55 per gallon… It’s going up.
Our Sprolie puppy Kiba finished his recovery from neutering and is as feisty as ever.
Thanks for visiting and remember to share TATEMS with a friend or colleague.
All The Best!
Marc
New Equipment Filters Spreadsheet with More Info and Video Tutorials
I hope you're doing well so far this week
Our puppy Kiba is not doing so well, He got clipped (neutered) yesterday.
The Vet says he has to stay confined for 10 days and he's already getting antsy.
Gas prices are down to $3.35 per gallon at the Sam's club nearest to us here in Las Vegas.
It's supposed to get up to 102 ° F today. It's cooling down…
Now on to today's Tip:
I had a request from a client yesterday for a filters report that could be broken down by customer or a list of equipment.
So I created a spreadsheet that will link to your TATEMS data And display the following columns in Excel:
Equip Num
Customer
Location
Dept Or Area
Lube Primary
Lube Secondary
Air Filter
Air Inner
Fuel Primary
Fuel Secondary
Hydraulic
Trans Filter
Water Filter
Other Filters
Once you open it up in Excel you can sort it and filter it anyway you want.
I show you how in this video:
You will need to have Microsoft Excel to use this spreadsheet and have it link to your TATEMS data.
This spreadsheet will link to your TATEMS data if it’s in the default installation location on 32 bit Windows.
C:Program FilesTATEMS 2005tatems2005be.mdb
The video in a previous post below shows you how to change the data path in the spreadsheet if you have Excel 2007 or Excel 2010. Click here to see the previous post.
And the video below shows you what you will probably need to do in order to make it work on your computer if you are not running Excel 2007 or 2010
You can get this newest spreadsheet at our website and it’s called:
TATEMS-EquipmentFilters-WithCustomer-Location-DeptOrArea-Fields
It’s completed for you online and ready to download at the link above or here:
http://tatems.com/spreadsheets
This spreadsheet is number 61 in the list on that spreadsheet page.
I hope this tip has been helpful for you.
Please leave any questions, comments or requests for special Excel Spreadsheets below. If your spreadsheet requests are feasible I’ll get them created and posted in a future TATEMS Tip.
Thanks Again,
Marc Ready
PCHelp, LTD
P.S. We plan to have a updated version of TATEMS in a a day or two.
P.P.S. We are also about ready to release a beta version of our new TATEMS Reminders program. This program runs in the windows notification tray down by the clock separately from TATEMS. It will automatically send out different reminder types via email to as many people as you need to send them to. Let me know if you would like to try out the beta version.
TATEMS on Terminal Services Server As RemoteApp Video Part 2
In yesterday' video I showed you how to install and setup TATEMS on a Terminal Services Server and how to setup the icons for each user when they will be using Remote Desktop Connection.
That's where the user will log in to the server and see an entire remote desktop with a TATEMS icon on it.
In this video I show you how to setup TATEMS in Terminal Services Server as a RemoteApp.
This is where the user clicks an icon on their own desktop and TATEMS opens. It looks like TATEMS is running on their own computer but it is in fact running on the server.
It's also a great way to restrict users from having access to an entire desktop on your server.
Either way you setup TATEMS on a Terminal Services Server you will find performance improvement and better stability, especially if you want to use TATEMS on a wireless network or over the internet or via a VPN.
Usually you will have an IT person handle this for you and if you do you can point them to these videos.
If you need help with this or anything else please let us know.
Also please make sure you stay current on your Support and Version Upgrades extensions with us.
Thanks Again and Take Care,
Marc
TATEMS on Terminal Services Server Video Part 1
It's been a crazy world the past couple of weeks. We live in interesting times.
I pray you're doing well and staying safe wherever you are.
My wife and daughter drove to Arkansas last week to visit her parents and they decided to drive back though the Rocky Mountains of Colorado. It sounded nice. I'm still waiting to see the pictures though.
Gas prices here in Las Vegas this week are at $3.39 per gallon at out local Sam's club and it's going to be 104° today.
Now on to today's tip:
I have been getting more and more people interested in installing TATEMS on Windows Terminal Services Server.
This allows you to run TATEMS entirely on the server and can really speed things up if you have multiple users accessing TATEMS on a network.
It's the only way you can use TATEMS over the internet or from remote shops that are not on your local area network.
We are in the process of partnering with a company that will offer Terminal Services Servers over the internet with TATEMS pre-installed; for a monthly fee per user plus a setup fee to anyone who wants it. These servers are completely maintained by the company we are partnering with and we will make sure TATEMS is updated and running properly on them as well.
If you are interested in this service please let me know. You will also be able to install and run other applications besides TATEMS on the servers if you need to.
If there is little or no interest we probably won't proceed.
In this video I demonstrate how to setup TATEMS on a Terminal Services Server (TS) that needs to have multiple users accessing the program at the same time. There are two types of remote access to the server you can take advantage of when setting up TATEMS on TS.
The first way is to grant the user remote desktop access. This is where the user logs in and sees his personal desktop that resides on the server and the TATEMS icon is on that desktop. He launches and runs TATEMS on the Remote desktop.
The other way is to setup what's called a RemoteApp. This is where the user gets an application icon on his computer for TATEMS but when he launches the application the program appears to be running on his computer but it is actually all running on the server. I'll go over setting up TATEMS as a RemoteApp in a second video in the next couple of days.
What's nice about either method is that TATEMS back end data file and front end files reside on the same computer(the server). So you don't get the performance degradation you get when you access the back end file over the network.
Here is the first video showing the setup of TATEMS in Remote Desktop Access environment on Windows Terminal Services Server:
I am also including some written instructions from out knowledge base:
For Terminal Services do a Full Install Logged as Administrator
and using Add/Remove Programs or the Terminal Service Application
installer to navigate to the setup file called:
tatemsmsi.exe on the CD or download.
When TATEMS is installed on Terminal Services
or Cirix only one person at a time can access
via remote access.
If you need to let more than one person at a time
use TATEMS via remote access then each additional
simultaneous user will be required to have their own license.
Here is the work around to let more than one person at
a time have access to TATEMS.
After the install is finished…
Create a sub folder for each user that will log in to use TATEMS
in this folder
C:Program FilesTATEMS 2005
(or in C:Program Files (x86)TATEMS 2005 on 64bit)
For Example for you might use
C:Program FilesTATEMS 2005Scott
copy this file
TATEMS2005.mde
in the
C:Program FilesTATEMS 2005
folder to each users sub-folder folder
( EX.C:Program FilesTATEMS 2005Scott ).
Then log in as each user and send a shortcut to the desktop for that file in the corresponding folder that matches the user name.
You can use the wrench.ico as the icon for the shortcut you create.
Then use the shortcut you create instead of the one created by the installer.
You can delete or hide or move the one created by the installer.
Whenever you do an update you will need to copy TATEMS2005.mde to each of the users sub-folders. You can create an Xcopy batch file to do the job for you.
You will need to own a separate license for each different user when logged in to terminal services or Citrix server in this configuration.
Take Care and Thanks Again,
Marc Ready
PCHelp, LTD
New Labor Items spreadsheet and video and more
I hope your week is going well so far.
The last week or so around here has been a little crazy.
It was only 95 ° here in Las Vegas today, well below normal and the Gas prices have been getting lower. We filled up for $3.55 per gallon last Friday and have seen it as low $3.31 per gallon on the other side of town.
I usually make breakfast in the morning for my wife and me and a few days ago I did what I usually do.
I left my wife's breakfast on the counter and yelled upstairs to let her know it was ready.
Then I grabbed mine to sit down and watch TV.
She took longer than usual to come down. I was already finished when she walked over to her plate and found a plate full of ANTS! Oops…
So we spent the next few hours trying to eradicate them.
The next day as I'm making breakfast I noticed water in the kitchen sink. I thought it wasn’t draining because there were some plates on one side that were blocking the drain.
We removed the dishes and it still would not drain. So I grabbed the bathroom plunger and turned on the garbage disposal and stupidly tried to plunge the other side.
All of a sudden boom! The pipes burst, water goes spraying out the front of the cabinet, soaking my pants and flooding the cabinet under the sink and the floor.
Oh what Fun!!!
I took apart the pipes and used a 6 foot snake to try to clean it out, put it all back together, no go, tried multiple Liquid Plummer bottles, no go.
Finally got a hold of my landlord and she sent in the big guns drain cleaning service. He had to go in about 15 feet to the main drain and that did the trick.
Drama over…. For a few days.
So it’s about 6AM Monday morning and I’m downstairs in morning prayer and hear my 23 year old daughter coming downstairs to let the puppy “Kiba” out (Kiba means fang in Japanese).
A few minutes later I hear the door open and then a big bang, and the cats go flying, bells jingling and I’m thinking “what’s going on” So I look up, I don’t see my daughter, then I look behind me, the cats are staring towards the door, then I look down, and my daughter has collapsed on the floor.
I freak!
I jump up and she is laying there on her side, and the floor is hard tile, she is unconscious and her eyes are open.
As I keeled over her and starting asking if she was aright she slowly came back around.
Well thank God, it turns out she just fainted and after a while she was able to get up and eat something.
We figure it was just low blood sugar. She said as she was sitting out back waiting for the dog to finish his business she started feeling ill, like she wanted to lay down. She thought she could make it back inside but just couldn’t make it.
Scared me to no end… the sight of her laying is something I’ll probably never forget. You never want to see your child hurt in any way.
And now on to today's tip…
Shelly, one of our clients was looking for a report to show all the Labor hours and costs even if the Work Order was still open.
We did not include a time clock feature for labor items in TATEMS in order to keep it as simple as possible for technicians to use.
But due to popular demand we will be adding a way to track start and Stop times and dates on each labor item in a future
update.
In the meantime I created this spreadsheet that will let you see all the dates associated with each work order and the
associated labor so I created the spreadsheet profiled in the video below:
It’s called:
Labor on Work Orders Pending and Completed.
And it will link to you TATEMS data and display the following columns:
Equip #
Work Order #
Date Requested
Date To Complete By
Date Completed
First Name
Last Name
Labor Description
Labor Notes
Hours/Units
Cost Per H/U
Total Cost
You will need to have Microsoft Excel to use these spreadsheet and have it link to your TATEMS data.
The video also shows you what you will probably need to do in order to make it work on your computer if you are not running
Excel 2007 or 2010 or if you have a 64 bit version of Windows or if your TATEMS data is on a network then
see this video:
You can get the spreadsheet at our website it’s called:
TATEMS-LaborOnWorkOrders-PendingAndCompleted.xls
It’s ready for you online and ready to download here:
http://tatems.com/spreadsheets
It is spreadsheet number 60 in the list on that page.
I hope this tip has been helpful for you.
Have a great Weekend and a Happy 4th of July
Thanks Again
Marc
P.S. If you need a custom spreadsheet let me know below and if you are on Facebook please click the like button… If you do… actually like this post that is…