In this video, you'll discover the history of the Parts For This Equip tab, how it was originally used and how it can be used now.
I did not mention it in the video but you can also hide this tab and any other unused tabs by going to
Tools->Simplify TATEMS
And then un-checking the tabs you want to hide.
You can also see the Parts For This Equip related reports by going to
Reports->More Reports->Report Type: Parts Installed
There is also the quick report for this tab for the currently selected piece of equipment under
Reports->Current Equipment Reports->Parts Report
Information from this tab is also included in the Unit Information Reports With All Equipment Data under
Current Equipment Reports
and
All Equipment Reports
It is also one of the choices for totals to be included in the Cost Per Mile/Km / Hour Report under
Reports->All Equipment Reports
And you will also find some custom spreadsheets that will pull data from the Parts For This Equip tab here
TATEMS Fleet Maintenance Software Custom Spreadsheets
When you get to that page you can press F3 on your keyboard to search the keyword “PartsForThis” without the quotes but all run together just like that.
At the time of this post, the following spreadsheets have Parts For This Equip Tab data that you can pull from your live TATEMS database.
42. TATEMSPartsForThisEquipTotalForEachYear
44. TATEMSPartsForThisEquipNumberOfTimesPartNumberUsedAndCost
132. TATEMS-PartsForThisEquipWithAllColumns
I hope this has been helpful to you!
This video shows you how to find and remove the extra backups that are created in the special backup folder.
WARNING: Make sure you are in the correct folder called “tatems2005beBackup” before you delete anything!
When you create backups in TATEMS you can choose where to save the backup.
In addition to the location that you choose, TATEMS also creates an extra backup that it saves it to a special folder called “tatems2005beBackup” .
Once that special folder called “tatems2005beBackup” has 30 backups saved to it, you will start seeing a message telling you that you may want to clean out some of the older backups.
I hope this video has been helpful to you!
Thanks Again,
Marc
The 7 and a 1/2 minute video below shows you what's inside and how to use the TATEMS Fleet Maintenance software report called:
All Work Orders Parts Totals By Equipment Number
This report can be found in TATEMS under:
Reports->More Reports->Report Type: Work Orders
You will discover how to use the various criteria like:
Date Completed Range (so you can see parts costs over a specific period)
Equipment Number
Part Description and how to use wild cards so you can show costs for specific items like tires or brakes.
Part Number.
Work Order Number
The report gives you the total parts costs for each equipment and a grand total of parts costs of all the equipment included in the report
Enjoy!
The video below shows you the new features added to TATEMS version 4.6.26.011 released Mar 22, 2019
This includes a huge time saver, that allows you to edit a work order from the Parts Inventory Screen instead of the old way of having to:
1. Note the Equipment Number Note
2. Note the Work Order Number
3. Close the Parts Inventory Screen
4. Go find the equipment
5. Find the work order
6. Then open the work order for editing.
Now… instead of doing all that, you can just double click on the Work Order in “Where This Part Installed List” on the Parts Inventory Screen
You can get always the latest update here:
This video shows you what you will find inside the Work Orders report called All GRouped By Equipment Number
This report is found in TATEMS under
Reports->More Reports->Report Type: Work Orders
You will also discover how to use the various criteria for this report so you can narrow down what you see and the cost totals it provides.
Thanks for stopping by!
In the 9 minute video below I go over some of the new improvements included in TATEMS version 4.6.26.009 released May 9, 2019
You can get the current update here:
I hope this video and the updates to TATEMS are helpful for you 🙂
Watch for more new updates coming very soon!
Thanks Again
Marc
This video goes shows you how to link spreadsheet number 130 TATEMS-WorkOrdersTotalsByYearPerEquipment to your TATEMS database using:
Excel 2016 (should also be the same for Excel 2013 and Excel 2019)
and
Excel 2010 (should also be the same for Excel 2007)
It also goes over how to create the same spreadsheet from scratch if you get an error when you try to link it to your TATEMS data.
You'll also see the spreadsheet columns and how to filter the columns in Excel
the columns are
Equipment Num
Year (Work Order Completed)
Labor Totals
Parts Totals
Misc Totals
Discounts
Tax
Totals Costs
So to sum it up you will see the Work Order Totals For Each Year For Each Piece of Equipment In Your Fleet
The video below shows you how to link and use the TATEMS Custom spreadsheet called TATEMS-WorkOrderPartsInventoryInstalledByCustomerbyYearAndInventoryType
This spreadsheet is number 129 and can be found here:
https://tatems.com/fleetmaintenancesoftware/spreadsheets.cfm
The columns in this spreadsheet are
Customer (From Custom Selected on the Equipment Summary Tab. If you have no customers this would be “In House”)
Year Work Order Parts Installed (from the Work Orders Completed Date)
Inventory Type (from the Parts Inventory screen)
Parts Cost (from the Work Order Parts Screen)
The video above shows you how to link this spreadsheet using Excel 2016 or 2019 and it might also be similar for Excel 2013
If you have Excel 2010 or 2007 then the video here will show you how to link these spreadsheets to your TATEMS data.
https://tatems.com/blog/new-inspectionspermits-spreadsheet-and-video
Thanks for stopping by!
UPDATE: Version 4.6.24v was released on Oct 1, 2018.
The current update is available here:
In the video below I show you the new Auto Resizing feature we are adding to TATEMS starting with version 4.6.24v (scheduled for release the first week of October 2018)
You may want to go to full screen on the above video to get a better feel for this cool new feature.
This feature is may cause instability of TATEMS on some systems causing unannounced shutdowns of TATEMS in which case you would need to keep the Auto Resizing feature turned off.
We will continue to make improvements to this feature in order to mitigate any instability issues people experience after version 4.6.24v is released.
The feature will be turned off by default.
In the video below I show you how to use Excel 2016 to link the spreadsheet called All Parts Inventory no Grouping to your live TATEMS data.
You can use this video as a guide for to help you link the other over 120 custom spreadsheets we have created for you here:
Fleet Maintenance Software Spreadsheets
In the video, I also show you a failed attempt at trying to get Excel 2016 to act like older versions of Excel using the data Legacy options.
I'll keep experimenting with that and post something when and if I can show how to do what I wanted to do.