AiM Workorder/Phase Cost Analysis Reports
- Justin Porter
OVERVIEW
Purpose: To replace the built-in Cost Analysis tool with one that accurately reflects billed transaction information from a customer perspective. The built-in Cost Analysis tool sums up all transactions in the billed transactions table, which includes some transactions we have duplicated for the purpose of supporting cost of goods sold for PO's and inventory releases. In effect, the billed transactions can show up to double what the customer was actually charged for a particular job. The built-in Cost Analysis tool also does not properly reflect transactions that are not sent to banner. For example, labor costs from facilities workers billed to the service center generate transactions that are marked NO EXTRACT and are not sent to Banner since the payroll expense already resides in the service center.
Link:  https://fs-aim-prod-app.uoregon.edu/fmax/screen/WORKDESK?module=WORKMGT, then click on Cost Analysis (for the phase level) or Workorder Cost Analysis. Also accessible from the print menu of the Phase or Workorder screens.
End User:Â Facilities, FASS Accounting
CONTACT US
DETAILS
Date Created:Â 5/3/2019
Created By:Â Justin Porter
Approved By:
Notes:
TECHNICAL NOTES
Platform:Â BIRT
Data Source:Â AiM
CHANGE LOG
| Edit Date | Edits Made |
|---|---|
| 3/4/2020 | Modified SQL to include invoice or inventory transactions billed directly to the service center cost of goods sold. Excluded Billed and To Be Billed lines where the total is $0. |
| 3/17/2020 | Added link to Job Cost report. |
