Building And Index Cost Report

Owned by Justin Porter
Last updated: Feb 25, 2020
1 min read

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.