Page History: Project Budget Report
Compare Page Revisions
Page Revision: Tue, 21 Apr 2020 08:21
General Info
Default Menu Location Reports >> Project Management >> Project Budget Report
Function The Project Budget Report will provide the same information that the Budgeting tab displays in a report form for a project or selection of projects.
Filters
Project # Range: Range of Project numbers to include in the report results.
Date Range: Date Range used to determine the breakdown of Actual, Purchase Order, and Committed costs.
Actual Cost: Date referenced is itemact.adddate where itemact.type ='S' (S = Shipments). Labor and Sales Tax will only ever show up in the Actual Cost column. Labor uses sotran.tdate. Sales Tax uses apmast.invdate.
PO Cost: Date referenced pomast.podate.
Committed Cost:
-Produced Items: Date referenced is itemact.adddate where itemact.type='AI' (AI = Production Inputs)
-Packed Items: Waiting to be fixed, notes will be updated.
-Purchased Items: Date referenced is itemact.adddate where itemact.type ='PR' (PR = Items Received)Project Bill Type: Multi select filter to allow selecting a combination of Project Bill Types.
Project Status: References the Complete checkbox on the Project Master screen.
