[Video] Parts For This Equipment Tab

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!

 

 

How To Remove Extra Backups From Special Backup Folder

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

Video Work Order Parts Totals By Equip Num Report

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!

New Video for TATEMS Version 4.6.26.011

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:

 

https://tatems.com/updates

 

 

Video – Lube Service Reminder With Filters Report

This 4-minute video shows you what you will find inside the Lube Service report called Lube Service Reminder With Filters and can be found  found in TATEMS under Reports->More Reports->Report Type: Lube/Service

You will also discover how to use the unique sorting criteria for this report so that you can sort by multiple To Go before it's due columns.

Video For Spreadsheet 50

This video goes shows you how to link spreadsheet number 50. TATEMS-PartsVendorHistoryOfInstalledPartsCosts, 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

Parts Vendor

Reference #

Part #

Part Desc

Cost Each

Qty Installed

Total Cost

Date WO Requested

Date WO Completed

Work Order#

Equip #

So to sum it up you will see the Parts Vendor Costs For All Work Orders In Your Fleet and you'll be able to filter by any af these columns.

For example, you can choose to see only what you spent and the parts purchased from a specific vendor for a spefic date range.

You can get this and the other spreadsheets by clicking here

If You get an error when you try to link to the TATEMS database I have another video here that shows you how to get it working

I hope you found this helpful!

Thanks Again

Marc

 

New Video For Spreadsheet 130

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

 

 

 

1 … 9 10 11 12 13 … 22