mwready
Author Archives: mwready

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

 

 

 

Video – Custom TATEMS Spreadsheet No. 129 Inventory Type Totals Installed

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!

Video – TATEMS Auto Resizing Coming to 4.6.24v Explained

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.

1 2 3 11