This generic inquiry form is available if the Extended Financial Data Collection feature is enabled on the Enable/Disable Features (CS100000) form.
Initially, the form shows projects with all statuses, but you can filter the data in the table to show projects with any status.
The form toolbar has only standard buttons.
In this area, you select the date through which the system shows projects in the table.
In the table, you can view each project’s date-specific cash flow, revenue budget backlog, and cost budget backlog. You can also see the total amounts across all listed projects. Each row represents a project.
Below you can find information about the columns that contain the project’s calculated values, along with the formulas that the system uses for these calculations.
The table toolbar has only standard buttons.
Revised Contract - Budgeted Cost
Gross Profit / Revised Contract
Expenses to Date / Budgeted Cost
Revenue to Date - Expenses to Date
Gross Profit to Date / Revenue to Date
AR Amount (Project Curr.) - AR Paid Amount (Project Curr.) - AR Cash Discount (Project Curr.) - Write-Off Amount (Project Curr.) - Realized Gain/Loss (Project Curr.)
AR Retained Amount (Project Curr.) + AR Retained Taxes (Project Curr.)
AR Cash Discount (Project Curr.) + Write-Of Amount (Project Curr.) + Realized Gain/Loss (Project Curr.)
Inclusive Taxes on AR (Project Curr.) + Exclusive Taxes on AR (Project Curr.) - Paid Inclusive Tax (Project Curr.) - Exclusive Taxes on Paid AR (Project Curr.)
AP Amount (Project Curr.) - AP Paid Amount (Project Curr.) - AP Cash Discount (Project Curr.) - Withheld Tax Amount (Project Curr.) - Realized Gain/Loss (Project Curr.)
AP Retained Amount (Project Curr.) + AP Retained Taxes
AP Cash Discount (Project Curr.) + Withheld Tax Amount(Project Curr.) + Realized Gain/Loss (Project Curr.)
Billed Inclusive Tax (Project Curr.) + Billed Tax (Project Curr.) - Paid Inclusive Tax (Project Curr.) - Exclusive Taxes on Paid AP (Project Curr.)
Revenue to Date + Taxes on Open AR Amount - Open AR Amount - AR Retainage - AR Difference
Expenses to Date - Open AP Amount + Taxes on Open AP Amount - AP Retainage - AP Difference
Cash Inflow to Date - Cash Outflow to Date
Revenue Budget - Cash Inflow to Date
Budgeted Cost - Cash Outflow to Date
Backlog Cash Inflow - Backlog Cash Outflow
Cash Flow to Date / Currency Rate - Cash Flow to Date (Base Curr.)