Building And Index Cost Report

OVERVIEW

Purpose:  Cost report to show all work order phases charged to specific building, index, or both.

Link:  H:\Shared\Reporting\Production\Building_And_Index_Cost_Report\

End User:  Jeff Butler

CONTACT US


DETAILS


Date Created:  2/10/2020

Created By:  Justin Porter

Approved By:  Alex Koleber, 2/11/2020

Notes:  Created in Excel due to requirement to sort/filter further after data has been retrieved.

TECHNICAL NOTES


Platform:  Excel

Data Source:  AiM Prod

CHANGE LOG


Edit DateEdits Made
2/14/2020Fixed issue where a building with more than 3 characters would cause a truncation error.
2/19/2020Removed RSTO/ROSINV transactions.  Added JTD_Amount (Job To Date Amount) column.
2/25/2020Swapped building number and name in building drop-down list to make it easier to find the right building.