Job Cash Flow Report

The Job Cash Flow Report helps Commercial users monitor projects based on the cash flow activity. It provides visibility into how payments, costs, and budgets align throughout the project lifecycle.

Navigation: RFMS Navigator>Sales Reports>File>Sales>Job Cash Flow Report

Report Criteria

Environment	Included Orders
Non-ERRM	• Delivery Date is blank • Invoice Print Date is not blank
ERRM	• Delivery Date is blank • Age From Date is not blank

Report Options

Stores

• Select the store(s) to include by single clicking on the store number(s).
• To include all stores, click Tag All, .
• Group By Store: Groups stores together in the report output.

Sales People

• Select the salesperson(s) to include by single clicking on their name(s).
• To include all, click the Tag All, .

Print Options

• Print Preview: Preview this report before printing.
• Break after Salesperson: Prints each salesperson's data on a separate page.
• Output to CSV file To: Specify the location to save the report (e.g. c:\\Reports).

Report Columns

Each row in the report represents the totals of all orders meeting the criteria, aggregated by Ship To Name.

Column	Description
Invoice Number	May represent multiple invoices sharing the same Ship To Name.
Budget Sales	Total of lines from Order Entry.
Budget Cost	Total of costs from Order Entry.
Requisition	Total of order lines in Cut or Delivered status. Lines in Cut status are included regardless of billing status. This value does not include lines in Gen PO, On Order, Reserve, or None status. Notes: As of version 22.99.2, this behavior is confirmed as intended. PC00 lines contribute to Labor Costs and should be considered when analyzing total costs. Staged lines are not reflected in the Requisition total until they move to an eligible status (e.g., Cut or Delivered). For percentage-billed orders, ensure that payments are applied to the correct order to maintain accurate cash flow representation.
Balance to Bill	Budget minus billed amount.
Material Cost to Date	Material cost of order lines in Gen PO, On Order, Reserve, Cut, or Delivered status. Does not include None status.
Labor Cost to Date	Labor cost of provider records.
Projected Costs	Budget minus (Material Cost + Labor Cost).
Payment	Payments made on the order.
Cash Flow	Payments minus (Labor Cost to Date + Material Cost to Date).

Version Notes

• Version 22.99.2: Confirmed that the Requisition column includes lines in Cut status regardless of billing status.
• Current Behavior (Version 24 and later): Functionality remains the same.