Colton ERP SW Sel - RFP Appendix A1 Finance Mgt 2025-07-22a (CF).xlsx

XLSX spreadsheet 204 KB Posted Aug 6, 2025

Attached to: RFP - ERP Software Selection
Solicitation number: Not on record
Issued by: San Bernardino County, California

About this file

Written by GovTribe AI · Aug 7, 2025

This is a Requirements Appendix file for the City of Colton, California's Enterprise Resource Planning (ERP) software selection RFP. The file contains detailed feature/function requirements for the Finance Management module, specifically covering General Ledger, Budgeting, Project and Grant Accounting, Contract Management, Purchasing and Requisitions, Accounts Payable, Expense Reimbursement, Accounts Receivable, Cashiering, Fixed Assets, Inventory, and Financial Reporting modules. The requirements are structured as numbered line items with columns for vendors to indicate whether features are available as "Standard - Current," "Standard - Next Release," through "Report Writer," via "3rd-Party Application," require "Custom Modification," or are "Not Available." Each module contains dozens to over one hundred specific functional requirements, ranging from basic account setup capabilities to complex integrations with third-party systems like Laserfiche document management.

The file serves as a comprehensive evaluation matrix for ERP vendors responding to the City's RFP, allowing for standardized comparison of software capabilities across multiple vendors. Key requirements include GAAP and GASB compliance, fund accounting capabilities, multi-year budgeting, project tracking, contract management, procurement processes, and extensive reporting features. The City requires integration capabilities between modules and with external systems, workflow approval processes, audit trails, and support for governmental accounting standards. Vendors must provide cost estimates for third-party applications and custom modifications in the comments section, with detailed pricing information to be included in a separate Project Costs worksheet (Appendix G).

View the file

Other files

File	Type	Posted
Colton ERP SW Sel - RFP Appendix A3 Other 2025-07-22a (CF).xlsx	XLSX spreadsheet	Aug 6, 2025
RFP ERP Software Selection 8-6-25.pdf	PDF	Aug 6, 2025
Colton ERP SW Sel - RFP Appendix A2 People Mgt 2025-07-22a (CF).xlsx	XLSX spreadsheet	Aug 6, 2025
Colton ERP SW Sel - RFP Appendices B-J 2025-07-30a (CF).xlsx	XLSX spreadsheet	Aug 6, 2025

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

1. General Ledger

Colton CA - Enterprise Resource Planning Solution Feature Function Requirements
Please input a "1" in the appropriate column to the right of the feature/function/capability statement. Further explanations, or information regarding 3rd party software and/or modification costs should also be provided in the comments column and Project Costs worksheet (Appendix G), if applicable. Each "non-title" row (?.000) should have only one "1". Blank rows will be scored as Not Available.
Legend:
Standard - Current	Available in current software release
Standard - Next Release	Guaranteed available in next release of software
Report Writer	Report Writer function through Standard Reports or Ad Hoc Report Writer
3rd-Party Application	Please estimate general cost estimates in comments not a quote, unless available due to your resell arrangement.
Custom Modification	Custom programming by vendor (not meant to be a set-up configuration that is standard process through implementation. Please estimate general costs in comments (not a quote).
Not Available	Not available in current or next release; interfaced/integrated third-party application or through custom modification.
Application	Feature Number	Feature / Function / Capability	Standard - Current	Standard - Next	Report Writer	3rd-Party Application	Custom Modification	Not Available	Comments
		General Ledger
	1.000	ACCOUNT SETUP
GENERAL LEDGER	1.001	CHART OF ACCOUNTS STRUCTURE - Ability to provide an agency defined chart of accounts structure (numeric) with a minimum of 30 characters for account description, other account number component descriptions, and also supports Federal Energy Regulation Commission (FERC) reporting requirements. VENDOR NOTE - please use the comments section to describe any limitations.
GENERAL LEDGER	1.002	ACCOUNT CATEGORIES - Ability to categorize Object codes (e.g., Salaries & Wages, Contract Services, etc.) based on agency-defined values, preferably using numerical ranges.
GENERAL LEDGER	1.003	COPY CHART OF ACCOUNTS - Ability to copy chart of accounts when creating new funds, departments, divisions, etc.
GENERAL LEDGER	1.004	MOVE DIVISIONS AND RETAIN HISTORY - Ability to move a division segment to a different department segment while retaining all associated history and maintaining historical, current, and future reporting for the division.
GENERAL LEDGER	1.005	CHART OF ACCOUNTS - Ability to handle the accounting of multiple legal entities, each with a separate chart of accounts and financial statements.
GENERAL LEDGER	1.006	SUPPORT GAAFR BLUE BOOK CHART OF ACCOUNTS - The chart of account structure should be fully compliant with the GAAFR "Blue Book" illustrative account structure. Provide for a minimum of eight levels of organizational hierarchy in organization coding (e.g., fund, department/division, element, object, activity, sub-activity, and project).
GENERAL LEDGER	1.007	FUND ACCOUNTING - Ability to provide all procedural functions of a governmental fund accounting system, including governmental, proprietary (enterprise and internal service), and fiduciary fund types and account groups (general long-term debt and fixed assets).
GENERAL LEDGER	1.008	FUND ACCOUNTING - Ability to maintain user-defined control accounts linked to subsidiary ledgers (i.e., accounts receivable, accounts payable, fixed assets and encumbrances).
GENERAL LEDGER	1.009	INACTIVE ACCOUNTS - Ability to deactivate an account without losing historical reporting.
GENERAL LEDGER	1.010	ACTIVATE/INACTIVATE ACCOUNTS BY DATES - Ability to activate/inactivate accounts based on a date or date range (e.g., start date and end date for when account should be active).
GENERAL LEDGER	1.011	OLD GENERAL LEDGER ACCOUNTS - Ability to provide a field that contains the old account number.
GENERAL LEDGER	1.012	GENERAL LEDGER DESCRIPTION CHARACTERS - Ability to allow up to 50 characters for an account description field. VENDOR NOTE - please state how many, if less than 50 characters.
GENERAL LEDGER	1.013	REFERENCE FIELDS - Ability to limit the number of fields (e.g., document numbers, reference numbers, posting numbers, etc.) required to search for a journal entry.
GENERAL LEDGER	1.014	POSTING NUMBERS - Ability to assign a permanent posting number (i.e., not a temporary number) to journal entries.
GENERAL LEDGER	1.015	FULL ACCRUAL METHOD OPTIONS - Ability to account on a full accrual and on a modified accrual basis (e.g., proprietary, special revenue funds, etc.).
GENERAL LEDGER	1.016	ACCOUNT RESTRICTIONS - Ability to restrict which general ledger accounts a user is able to select.
GENERAL LEDGER	1.017	USER RESTRICTIONS - Ability to make corrections or changes during the reconciliation process with appropriate user authorization.
GENERAL LEDGER	1.018	JOURNAL ENTRIES
GENERAL LEDGER	1.019	ROUTE ENTRIES FOR APPROVAL - Ability to route journal entries for multiple approvals prior to posting.
GENERAL LEDGER	1.020	REASON FOR REJECTED ENTRY- Ability to enter an agency-defined reason for rejecting a journal entry (e.g., wrong department code).
GENERAL LEDGER	1.021	ENTRY NOTES - Allow unlimited notes per journal entries. VENDOR NOTE - please use the comments section to explain any limitations.
GENERAL LEDGER	1.022	BACK-DATED ENTRIES - Ability to warn the user when recording a journal entry against a prior year, reminding them that end of year/beginning of year balances will not automatically update without the completion of a roll-forward process (if applicable).
GENERAL LEDGER	1.023	BUDGET VERIFICATION - Ability to verify fund availability as defined by the entity's level of budget control (e.g., single line-item or group of accounts).
GENERAL LEDGER	1.024	JOURNAL ENTRY ATTACHMENTS - Ability to attach files to journal entries and journal entry batches. VENDOR NOTE - please comment on the acceptable file formats.
GENERAL LEDGER	1.025	JOURNAL BALANCING VALIDATION - Ability to ensure that each journal entry is in balance.
GENERAL LEDGER	1.026	DUE TO/DUE FROM ENTRIES - Ability to automate interfund clearing entries based on defined rules, and ensure journal entries stay in balance.
GENERAL LEDGER	1.027	RECURRING ENTRIES - Ability to generate recurring journal entries, including:
GENERAL LEDGER	1.028	▪ Fixed accounts/fixed amounts
GENERAL LEDGER	1.029	▪ Fixed accounts/percentage amount splits
GENERAL LEDGER	1.030	▪ Fixed accounts/variable amount splits, and monthly, quarterly, and yearly entries
GENERAL LEDGER	1.031	RECURRING ENTRIES - START/STOP DATES - Ability to enter start and stop dates for each recurring entry.
GENERAL LEDGER	1.032	COPY JOURNAL ENTRY – Ability to create a copy of a pending or posted journal entry.
GENERAL LEDGER	1.033	REVERSING JOURNAL ENTRY – Ability to create a reversing copy of a pending or posted journal entry.
GENERAL LEDGER	1.034	REVERSING JOURNAL ENTRY – Ability to define the effective date of the reversing copy of a pending or posted journal entry.
GENERAL LEDGER	1.035	ACCRUALS - Ability to automatically offset accrual transactions by creating and posting the appropriate offsetting entries.
GENERAL LEDGER	1.036	POOLED CASH INTEREST ALLOCATION - Ability to track and allocate interest income to fund level for pooled cash, based on average ending cash balance.
GENERAL LEDGER	1.037	POOLED CASH INTEREST ALLOCATION - FUND INCLUSIONS - Ability to define the funds included in the interest calculation.
GENERAL LEDGER	1.038	ALLOCATIONS - Ability to allocate transactions by percent (%) or dollar amount ($) to multiple general ledger accounts.
GENERAL LEDGER	1.039	GENERAL LEDGER PROCESSING
GENERAL LEDGER	1.040	ACCOUNT NUMBER VALIDATION - Ability to validate account number selections at time of data entry.
GENERAL LEDGER	1.041	ACCOUNT ENTRY SUGGESTIONS - Ability to suggest account number codes based on partial text or account numbers being entered by the user.
GENERAL LEDGER	1.042	FUNDS AND PROJECTS - Ability to post fund and project activity to full-accrual accounts and to automatically calculate fund balance/retained earnings, as well as post the activity to the appropriate accounts.
GENERAL LEDGER	1.043	BATCH REVIEW AND EDIT - Ability to review and edit batches online before posting.
GENERAL LEDGER	1.044	YEAR END PROCESSING
GENERAL LEDGER	1.045	MULTIPLE OPEN PERIODS - Ability to allow the system to have every monthly period in a fiscal year open simultaneously.
GENERAL LEDGER	1.046	MULTIPLE OPEN FISCAL YEARS - Ability to have past and current fiscal years open simultaneously.
GENERAL LEDGER	1.047	13TH PERIOD FOR FISCAL YEAR-END ADJUSTMENTS - Ability to provide a 13th period to allow for the fiscal year-end adjustments.
GENERAL LEDGER	1.048	INFORMATION TO ROLL FORWARD - Ability for users to select what information to roll forward and what to restrict from rolling forward at fiscal year-end.
GENERAL LEDGER	1.049	HARD/SOFT PERIOD CLOSES - Ability to allow hard and soft closes for period/year end closing.
GENERAL LEDGER	1.050	YEAR-END CLOSING - Ability to perform rollovers multiple times.
GENERAL LEDGER	1.051	CLOSED YEAR-END PERIOD - Ability to allow for the option to re-open a closed period (with the appropriate security permissions).
GENERAL LEDGER	1.052	PREVENT POSTINGS TO CLOSED PERIOD - Ability to prevent postings to a closed fiscal year.
GENERAL LEDGER	1.053	GENERAL LEDGER INQUIRIES & REPORTING
GENERAL LEDGER	1.054	GENERAL LEDGER ACCOUNT LOOKUP - Ability for users to look up a chart of account name, number, and description in all modules while performing any transaction.
GENERAL LEDGER	1.055	JOURNAL ENTRY SEARCH - Ability to search journal entries by the following information, including but not limited to:
GENERAL LEDGER	1.056	▪ Dollar amounts
GENERAL LEDGER	1.057	▪ Receipt number
GENERAL LEDGER	1.058	▪ Description
GENERAL LEDGER	1.059	▪ Journal number
GENERAL LEDGER	1.060	▪ General ledger account number
GENERAL LEDGER	1.061	▪ Posted date
GENERAL LEDGER	1.062	▪ Type
GENERAL LEDGER	1.063	SEARCHING USING WILDCARDS - Ability to perform wild card search capabilities based on any segment or account description in the agency's chart of accounts.
GENERAL LEDGER	1.064	EXPORT TO EXCEL - Ability to export detailed transactions to Microsoft Excel.
GENERAL LEDGER	1.065	REPORTING REQUIREMENTS - Ability to comply with current Generally Accepted Accounting Principles (GAAP), pronouncements of the Governmental Accounting Standards Board (GASB), state, and federal reporting requirements.
GENERAL LEDGER	1.066	ACFR REPORTING COMPLIANCE - Ability to produce Annual Comprehensive Financial Reports (ACFR) per Governmental Accounting Standards Board (GASB) guidelines.
GENERAL LEDGER	1.067	REPORTING BY ACCOUNTING METHOD - Ability to generate reports using cash, modified accrual, or full accrual basis.
GENERAL LEDGER	1.068	GENERAL LEDGER DRILLDOWN AND ACROSS - Ability to drill down and across to see all account activities, and access all related detail transactions through "drill-down capability," whether stored in the General Ledger or another module.
GENERAL LEDGER	1.069	GENERAL LEDGER SEGMENT REPORTING - Ability to generate a report across any segment or group of segments in the chart of accounts.
GENERAL LEDGER	1.070	GENERAL LEDGER COMBINED REPORTING - Ability to generate a report across ranges that are not in sequence (e.g., combine funds that are not in sequence - 600 and 900 accounts).
GENERAL LEDGER	1.071	SELECTIVELY CHOOSE AND SORT DATA - Ability to selectively choose and sort data, as well as provide totals by any account segment (not necessarily sequential).
GENERAL LEDGER	1.072	INQUIRY - ENCUMBRANCE - Ability to support encumbrance inquiry to determine information on original encumbrance, amount liquidated to-date, and balance.
GENERAL LEDGER	1.073	TRANSACTION INQUIRY - Ability to display both pending (not permanently posted) and encumbrance transaction amounts and descriptions for inquiry or reporting.
GENERAL LEDGER	1.074	ATTACHMENT INQUIRY - Ability to display attachments from within account inquiry.
GENERAL LEDGER	1.075	PROOF AND POSTING REPORTS - Ability to provide proof and posting reports of cash, payables, payroll, receivables, inventory, and any other sub-ledgers, and produce automatic journal vouchers and adjusting journal entries prior to posting.
GENERAL LEDGER	1.076	SUBSIDIARY RECONCILIATION REPORT - Ability to generate a subsidiary reconciliation report (e.g., accounts payable, accounts receivable).
GENERAL LEDGER	1.077	FISCAL / CALENDAR YEAR REPORTING - Ability to run reports on a fiscal- and calendar-year basis.
GENERAL LEDGER	1.078	HISTORICAL REPORTING - Ability to retain and report on unlimited number of historical fiscal years.
GENERAL LEDGER	1.079	HISTORICAL MONTHLY REPORTING - Ability to run all financial reports by month across multiple fiscal years.
GENERAL LEDGER	1.080	BALANCE SHEET REPORT - Ability to generate a summary balance sheet report, as well as sort by account structure element.
GENERAL LEDGER	1.081	INCOME STATEMENT REPORT - Ability to generate an income statement report containing budget versus actual comparisons, as well as sort by account structure element.
GENERAL LEDGER	1.082	SUMMARY REVENUE REPORT - Ability to generate a summary revenue report, as well as sort by account structure element.
GENERAL LEDGER	1.083	DETAIL TRANSACTION REVENUE REPORT - Ability to generate a detail transaction revenue report with selected subtotals.
GENERAL LEDGER	1.084	SUMMARY EXPENDITURE REPORT - Ability to generate a summary expenditure report, as well as sort by account structure element.
GENERAL LEDGER	1.085	DETAIL TRANSACTION EXPENDITURE REPORT - Ability to generate a detail transaction expenditure report with selected subtotals.
GENERAL LEDGER	1.086	TRIAL BALANCE REPORT - Ability to provide on-demand working trial balance, detail trial balance, and summary trial balance reports by selected funds.
GENERAL LEDGER	1.087	CASH FLOW ANALYSIS - Ability to generate a cash flow analysis report by account, identifying amount, and date.
GENERAL LEDGER	1.088	FUND REPORTING - Ability to group selected funds for consolidated reporting.
GENERAL LEDGER	1.089	BANK RECONCILIATION INQUIRIES & REPORTING
GENERAL LEDGER	1.090	CHECK RECONCILIATION TRACKING - Ability to track check activity dates, such as issue date, void date, reversal date, cleared date, and stop-payment dates.
GENERAL LEDGER	1.091	AUTOMATED BANK RECONCILIATION - Ability to support standard electronic bank reconciliation functionality (i.e., accounts payable, credit card statements, and payroll checks).
GENERAL LEDGER	1.092	MANUAL ENTRY RECONCILIATIONS - Ability to recognize postings made through the general ledger for items such as bank charges, interest income, etc.
GENERAL LEDGER	1.093	MATCHING CRITERIA - Ability to configure rules to allow for automatically matching bank transactions with general ledger transactions.
GENERAL LEDGER	1.094	MATCHING EXCEPTION OVERRIDE - Ability to manually override automatically reconciled transactions (with the appropriate security permissions).
GENERAL LEDGER	1.095	TRANSACTION COMMENTS - Ability to enter comments for unreconciled transactions.
GENERAL LEDGER	1.096	TRANSACTION TYPE - Ability to classify reconciliation items by type.
GENERAL LEDGER	1.097	REVERSALS - Ability for posted or voided items to be reversed to a cleared or outstanding status (with the appropriate security permissions).
GENERAL LEDGER	1.098	RECONCILIATION STATUS - Ability to modify the status of bank reconciliations.
GENERAL LEDGER	1.099	OUTSTANDING CHECKS REPORT - Ability to generate daily, monthly, annual, or specified date-range reports that show the total amount and number of outstanding checks by bank account and by fund.
GENERAL LEDGER	1.100	MONTHLY TRANSACTION REPORT - Ability to provide a monthly detailed transaction listing by bank account.
GENERAL LEDGER	1.101	SUMMARY RECONCILIATION REPORTS - Ability to generate a daily, monthly, annual, or specified date range report of all cleared checks by bank account, fund, check amount, check number, and payee.
GENERAL LEDGER	1.102	MISMATCH EXCEPTION REPORT - Ability to provide an exception report showing mismatched amounts.
GENERAL LEDGER	1.103	SKIPPED CHECKS - Ability to generate a report of check numbers there were skipped for an agency-defined date range.
GENERAL LEDGER	1.104	INTERFACES & INTEGRATIONS
GENERAL LEDGER	1.105	IMPORT JOURNAL ENTRY - Ability to import a journal entries file (e.g., .csv, .xlsx, .txt, etc.) with audit trail capabilities. VENDOR NOTE - please comment on the acceptable file formats.
GENERAL LEDGER	1.106	IMPORT BANK STATEMENT - Ability to import a downloaded bank statement file in Bank Administration Institute (BAI) file format.
GENERAL LEDGER	1.107	INTEGRATION - PROJECT & GRANT ACCOUNTING - Ability to integrate a project number with the Project & Grant Accounting module at the transaction level so that accounts in both systems remain in balance at all times. Transaction entered into the General Ledger modules must also update the Project & Grant Accounting module.
GENERAL LEDGER	1.108	INTEGRATION - PAYROLL - Ability to integrate with the General Ledger module to allow drill-down to related Payroll module data.
GENERAL LEDGER	1.109	INTEGRATION - ELECTRONIC CONTENT MANAGEMENT SYSTEM - Ability to integrate with a third-party document management system (Laserfiche) to attach and store files or supporting documents to a record (e.g., spreadsheets showing correcting calculations, bank statements, etc.).

&F &P of &N

2. Budgeting

Colton CA - Enterprise Resource Planning Solution Feature Function Requirements
Please input a "1" in the appropriate column to the right of the feature/function/capability statement. Further explanations, or information regarding 3rd party software and/or modification costs should also be provided in the comments column and Project Costs worksheet (Appendix G), if applicable. Each "non-title" row (?.000) should have only one "1". Blank rows will be scored as Not Available.
Legend:
Standard - Current	Available in current software release
Standard - Next Release	Guaranteed available in next release of software
Report Writer	Report Writer function through Standard Reports or Ad Hoc Report Writer
3rd-Party Application	Please estimate general cost estimates in comments not a quote, unless available due to your resell arrangement.
Custom Modification	Custom programming by vendor (not meant to be a set-up configuration that is standard process through implementation. Please estimate general costs in comments (not a quote).
Not Available	Not available in current or next release; interfaced/integrated third-party application or through custom modification.
Application	Feature Number	Feature / Function / Capability	Standard - Current	Standard - Next	Report Writer	3rd-Party Application	Custom Modification	Not Available	Comments
		Budgeting
	2.000	GENERAL FEATURES
BUDGET	2.001	VERSION CONTROL - Ability to maintain a minimum of ten budget versions.
BUDGET	2.002	VERSION NAMING - Ability to name budget versions (e.g., department submitted, submitted to Council, Council adopted).
BUDGET	2.003	VERSION SECURITY LEVELS - Ability to define separate security levels per budget version (e.g., only Finance can review and edit one version, while departments can only access another).
BUDGET	2.004	ACCOUNT SECURITY LEVELS - Ability to define separate budget security levels for Finance-defined expenditures and revenue accounts (e.g., Finance can review and edit all accounts, while departments can only edit accounts designated by Finance).
BUDGET	2.005	HISTORICAL BUDGET RETENTION - Ability to maintain detailed budgets until decision to purge is made (minimum ten years).
BUDGET	2.006	BUDGETING CREATION
BUDGET	2.007	MULTI-YEAR BUDGET ENTRY - Ability to generate a multi-year budget forecast (minimum five years).
BUDGET	2.008	INITIAL BUDGET CREATION - Ability to generate an initial budget version based on agency-defined criteria (i.e., blank, prior-year approved budget, prior-year amended budget, prior-year actuals, etc.):
BUDGET	2.009	▪ Last Two Year's Actuals
BUDGET	2.010	▪ Current Year Amended Budget
BUDGET	2.011	▪ Current Year Actuals
BUDGET	2.012	▪ Current Year Encumbered Amounts
BUDGET	2.013	▪ Year-End Forecast (Blank) (i.e., department to input)
BUDGET	2.014	BUDGET WORKSHEET COLUMN DEFINITION - Ability to utilize report writer capability and to configure columns by title and content, including calculated columns.
BUDGET	2.015	SUPPLEMENTAL BUDGET REQUESTS - Ability to generate supplemental budget requests that are in addition to, and separate from, the agency's base budget request.
BUDGET	2.016	CONCURRENT BUDGET PROCESSING - Ability to perform budget projection processing and analysis without regard to or impacting the current budget.
BUDGET	2.017	MONTHLY BUDGET ESTIMATES - Ability to input monthly estimated fiscal-year-end actuals into the final budget.
BUDGET	2.018	FREEZE DEPARTMENTAL BUDGETS ONCE ACCEPTED BY FINANCE - Ability to prevent departments from altering budget requests once the Finance Department has frozen a department's budget version.
BUDGET	2.019	ADOPTED AND AMENDED BUDGETS - Ability to track adopted (original) budget and amended (final) budget.
BUDGET	2.020	PAYROLL BUDGET VERSION - Ability to create separate payroll budget versions that roll into an overall budget version.
BUDGET	2.021	CAPITAL IMPROVEMENT BUDGET VERSION - Ability for (CIP) budget versions to roll into an overall budget version.
BUDGET	2.022	EQUIPMENT REPLACEMENT BUDGETING - Ability to create a separate equipment replacement budget that will roll up with the main operating budget.
BUDGET	2.023	INTERNAL SERVICE COST ALLOCATION - Ability to create budgetary cost allocations for internal service activities, splitting the amount budgeted for a individual line item between multiple cost centers.
BUDGET	2.024	COMMENTS - Ability to maintain comment justifications for each of the following:
BUDGET	2.025	▪ Budget Version
BUDGET	2.026	▪ Budget Line Item
BUDGET	2.027	▪ Budget Amendment
BUDGET	2.028	ATTACHMENTS - Ability to attach files and documents to the following budget items:
BUDGET	2.029	▪ Budget Version
BUDGET	2.030	▪ Budget Line Item
BUDGET	2.031	▪ Budget Amendment
BUDGET	2.032	BUDGET NOTES VERSION - Ability for the system to support notes by departmental request for justifications, and for notes by the budget office to provide guidelines and recommendations.
BUDGET	2.033	REVISIONS - Ability to search, update, and add budget line items as needed.
BUDGET	2.034	COPYING REVISIONS - Ability to copy and edit budget revisions.
BUDGET	2.035	YEAR-END – PURCHASE ORDERS ROLLOVER- Ability to automatically increase the new fiscal year's budget for purchase orders that are cancelled and reissued as part of the year-end closing process.
BUDGET	2.036	POSITION AND PAYROLL BUDGETING
BUDGET	2.037	POSITION CONTROL BUDGETING - Ability to budget by position using position control (e.g., estimated salary increases, projected increases due to step and grade plans, required benefits by bargaining unit, etc.).
BUDGET	2.038	MULTIPLE GENERAL LEDGER ACCOUNTS BY EMPLOYEE - Ability to allocate an employee's budget to multiple general ledger account codes.
BUDGET	2.039	APPROVALS AND WORKFLOW
BUDGET	2.040	ONLINE WORKFLOW APPROVAL - Ability to route budget requests and/or amendments to appropriate user(s)/groups with notifications of their approval or disapproval.
BUDGET	2.041	ONLINE WORKFLOW APPROVAL NOTES - Ability to enter approval/disapproval notes and restart the approval process if required.
BUDGET	2.042	ONLINE WORKFLOW BACKUP APPROVERS - Ability to route budget requests and/or amendments to appropriate backup approvers (e.g., primary approver is on leave).
BUDGET	2.043	BUDGET ANALYSIS
BUDGET	2.044	FORECASTING - CALCULATIONS - Ability to generate agency-defined forecasts based on models and calculations.
BUDGET	2.045	SAVE PROJECTIONS - Ability to save projections and versions of projections.
BUDGET	2.046	MASS FORECAST CHANGES - Ability to perform mass changes when forecasting.
BUDGET	2.047	BUDGET TRENDS - Ability to perform budget trend analysis.
BUDGET	2.048	ASSET REPLACEMENT FORECASTS - Ability to generate forecasts on asset replacement and maintenance costs.
BUDGET	2.049	FORECASTING - ADDING ACCOUNT NUMBERS - Ability to add account numbers to the forecasted budget, which will be integrated with the General Ledger module based on an effective date, without impact to the current budget period.
BUDGET	2.050	WHAT-IF SCENARIOS - Ability to generate "what-if" scenario capability for budget projections spanning a minimum of five (5) years. VENDOR NOTE - Please comment on any limitations.
BUDGET	2.051	WHAT-IF SCENARIOS - Ability to generate "what-if" scenario capability for budget projections at different organization levels (fund, department, and division). VENDOR NOTE - please provide update capability for selected scenarios.
BUDGET	2.052	BUDGET AMENDMENTS
BUDGET	2.053	AMENDMENTS - TRACEABILITY - Allow for users to track budget amendments by dates, changes, account transfers, and user.
BUDGET	2.054	AMENDMENTS - SINGLE TRANSACTION - Ability to make budget adjustments or transfers to multiple accounts and multiple funds in a single transaction.
BUDGET	2.055	INQUIRY AND REPORTS
BUDGET	2.056	MULTI-FISCAL YEAR BUDGET REPORT - Ability to generate a multi-fiscal year budget report that contains the previous two year's actuals, current year actuals, current year's adopted budget, current year's adjusted budget, year-end estimate, next year's requested budget, and a forecast of five future fiscal years by line item.
BUDGET	2.057	BUDGET VERSION COMPARISONS - Ability to view and/or print a budget version comparison report with each version in a separate column.
BUDGET	2.058	PERFORMANCE BASED BUDGETING MEASURES - Ability to statistically compile and report on dollar amounts related to performance results (e.g., efficiency, quality of service, transparency, etc.).
BUDGET	2.059	YEAR TO DATE BUDGET - Ability to query or generate a report that includes the following columns - Original Budget, Budget Amendments, Revised Budget, YTD Expenditures, Encumbrances (at Purchase Order), Pre-encumbrance (at requisition), or Available Budget.
BUDGET	2.060	BUDGETED VS ACTUAL - VARIANCE/COMPARISON REPORT - Ability to generate a budget vs. actual variance report by year, general ledger account, percentage variance, and amount variance.
BUDGET	2.061	BUDGET WORKSHEET COLUMN DEFINITION - Ability to utilize report writer capability and to configure columns by title and content, including calculated columns.
BUDGET	2.062	BUDGET - INQUIRY OF HISTORICAL POSTINGS - Ability to inquire into current month or year-to-date account detail actuals and budgets.
BUDGET	2.063	BUDGET VS. ACTUALS COMPARATIVE REPORT - Ability to produce budget vs. actual comparative reports, including Over Budget, Zero Budget, and % Expended to Date reports by overall budget, fund, or department.
BUDGET	2.064	BUDGET TO ACTUAL HISTORY BY ACCOUNT - Ability to generate a report listing ten years of budget-to-actuals for an account with the ability to sort by account structure element.
BUDGET	2.065	AVAILABLE BUDGET BY ACCOUNTS - Ability to display percentage of available budget for an account or a group of accounts with the ability to sort by account structure element.
BUDGET	2.066	MULTI-YEAR BUDGET INQUIRY AND REPORTING - Ability to generate a multi-year comparison by month and year with the ability to sort by account structure element.
BUDGET	2.067	AMENDMENTS/TRANSFERS REPORT - Ability to print individual budget transfers with account number, account name, current budget, amendment amount, and revised budget, in columnar format.
BUDGET	2.068	AMENDMENTS/TRANSFERS - AUDIT TRAIL - Ability to run an audit trail report for all budget amendments/transfers showing who made and approved changes.
BUDGET	2.069	BUDGET VERSION LOCKING - AUDIT TRAIL - Ability to run an audit trail report for all updates made to budget versions.
BUDGET	2.070	EDIT REPORT GENERATION - Ability to print batch balancing and edit reports upon completion of either initial entry or adjusting of budgets.
BUDGET	2.071	PRODUCE STANDARD REPORTS - Ability to export report data to Microsoft Word, Microsoft Excel, and PDF formats.
BUDGET	2.072	MONTHLY BUDGET TO ACTUALS REPORT ON DASHBOARD - Ability to display monthly budget to actual reports by department/division on user dashboards.
BUDGET	2.073	PRIOR YEAR BUDGET NOTES - Ability to drill into prior year budget version notes.
BUDGET	2.074	INTERFACES AND INTEGRATIONS
BUDGET	2.075	BUDGET IMPORT - EXCEL - Ability to import select budget line items into the Budget module from Microsoft Excel.
BUDGET	2.076	PROJECT BUDGET IMPORT - EXCEL - Ability to import detailed project budgets (e.g., engineering, maintenance, facilities, projects, etc.) into the Budget module from Microsoft Excel.
BUDGET	2.077	INTEGRATION - PAYROLL - Ability to integrate with position control and include vacant and requested positions.
BUDGET	2.078	INTEGRATION - PAYROLL - Ability to extract year-to-date actual amount data from the Payroll module by employee position or group.
BUDGET	2.079	INTEGRATION - PAYROLL - Ability to access data from the Payroll module to create "what-If" analyses for labor negotiation and budget projection purposes (e.g., impact of a 5% pay increase).
BUDGET	2.080	INTEGRATION - PROJECT & GRANT ACCOUNTING - Ability to establish a budget for projects in the Project & Grant Accounting module that will roll up to the main operating budget subtotals.
BUDGET	2.081	INTEGRATION - FIXED ASSETS - Ability to pull vehicle/asset replacement budgets based on end-of-life date and replacement cost, as well as depreciation expenses from the Fixed Assets module.
BUDGET	2.082	INTEGRATION - GENERAL LEDGER - Ability to automatically post approved budget amendments to the General Ledger module.
BUDGET	2.083	INTEGRATION - BUDGET BOOK CREATION - Ability to export budget data to a third-party digital reporting tool.
BUDGET	2.084	INTEGRATION - ELECTRONIC CONTENT MANAGEMENT SYSTEM - Ability to integrate with a third-party document management system (Laserfiche) to attach and store files or supporting documents to a record (e.g., spreadsheets showing calculations, narratives, etc.).

&F &P of &N

3. Proj-Grant Acct

Colton CA - Enterprise Resource Planning Solution Feature Function Requirements
Please input a "1" in the appropriate column to the right of the feature/function/capability statement. Further explanations, or information regarding 3rd party software and/or modification costs should also be provided in the comments column and Project Costs worksheet (Appendix G), if applicable. Each "non-title" row (?.000) should have only one "1". Blank rows will be scored as Not Available.
Legend:
Standard - Current	Available in current software release
Standard - Next Release	Guaranteed available in next release of software
Report Writer	Report Writer function through Standard Reports or Ad Hoc Report Writer
3rd-Party Application	Please estimate general cost estimates in comments not a quote, unless available due to your resell arrangement.
Custom Modification	Custom programming by vendor (not meant to be a set-up configuration that is standard process through implementation. Please estimate general costs in comments (not a quote).
Not Available	Not available in current or next release; interfaced/integrated third-party application or through custom modification.
Application	Feature Number	Feature / Function / Capability	Standard - Current	Standard - Next	Report Writer	3rd-Party Application	Custom Modification	Not Available	Comments
		Project and Grant Accounting
	3.000	GENERAL FEATURES
PROJECTS-GRANTS	3.001	PROJECT TYPES - Ability to setup various project types, including Transportation, Drainage, Parks and Facilities, Water, Wastewater, Special Events, and Land Development.
PROJECTS-GRANTS	3.002	PROJECT ACCOUNT ID - Ability to generate a project ID number with duplicate prevention capability.
PROJECTS-GRANTS	3.003	AGENCY-DEFINED PROJECT FIELDS - Ability to have the following agency-defined fields for projects:
PROJECTS-GRANTS	3.004	▪ Project No.
PROJECTS-GRANTS	3.005	▪ Project Name
PROJECTS-GRANTS	3.006	▪ Project Type
PROJECTS-GRANTS	3.007	▪ Project Description
PROJECTS-GRANTS	3.008	▪ Project Justification
PROJECTS-GRANTS	3.009	▪ Budget
PROJECTS-GRANTS	3.010	▪ Entitlement Period (Start Date, End Date)
PROJECTS-GRANTS	3.011	▪ Resolution No.
PROJECTS-GRANTS	3.012	▪ Resolution Date
PROJECTS-GRANTS	3.013	▪ Ordinance No.
PROJECTS-GRANTS	3.014	▪ Ordinance Date
PROJECTS-GRANTS	3.015	▪ Overhead Allocation Rate
PROJECTS-GRANTS	3.016	▪ Contact Person Name
PROJECTS-GRANTS	3.017	▪ Contact Person Phone Number
PROJECTS-GRANTS	3.018	MULTI-YEAR PROJECT/GRANT REPORTING - Ability to inquire/report and drill down into project life-to-date history or specified timeline at both transaction detail and summary levels.
PROJECTS-GRANTS	3.019	MULTI-YEAR PROJECT - CONSTRUCTION IN PROGRESS - Ability to transfer current year project costs to a balance sheet account at year-end without closing the project (e.g., construction in progress to fixed asset).
PROJECTS-GRANTS	3.020	MULTI-FUND PROJECTS AND GRANTS - Ability to track projects and grants across multiple funds and departments.
PROJECTS-GRANTS	3.021	GROUP PROJECTS - Ability to setup categorization groups of projects for reporting purposes.
PROJECTS-GRANTS	3.022	HIERARCHICAL STRUCTURE - Ability to use a hierarchical structure to facilitate the costing and management of project activities (i.e., project, phase, task, activity) that roll up to the parent project and general ledger account levels.
PROJECTS-GRANTS	3.023	SUB-PROJECTS - Ability to track and report revenues and expenditures at the project and sub-project levels using different account codes (if required).
PROJECTS-GRANTS	3.024	ONLINE WORKFLOW APPROVAL - Ability to route projects to appropriate users with notifications of their approval or disapproval. Allow entry of disapproval notes and ability to restart the approval process if required.
PROJECTS-GRANTS	3.025	ATTACHMENTS - Ability to attach documents and files at the project and sub-project (category) level. VENDOR NOTE - please comment on the acceptable file formats.
PROJECTS-GRANTS	3.026	PROJECT TEMPLATES
PROJECTS-GRANTS	3.027	PROJECT TEMPLATES - Ability to create project templates (i.e., "simple" templates or "complex" templates for specific project types).
PROJECTS-GRANTS	3.028	UNLIMITED PROJECT TEMPLATES - Ability to maintain an unlimited number of project templates.
PROJECTS-GRANTS	3.029	COPY (EXISTING) RECURRING PROJECTS - Ability to copy a previous project when creating a new project.
PROJECTS-GRANTS	3.030	COST TRACKING AND BILLING
PROJECTS-GRANTS	3.031	COST CATEGORIES - Ability to create, track, and report on unlimited project cost categories (e.g., labor, materials, services, overhead).
PROJECTS-GRANTS	3.032	PROJECT AND GRANT LABOR ALLOCATIONS - Ability to setup project and grant labor allocations at the employee record level.
PROJECTS-GRANTS	3.033	OVERHEAD METHODS - PERCENTAGES - Ability to assign overhead percentages to specified projects and grants with contractual parameters and limitations for overhead.
PROJECTS-GRANTS	3.034	OVERHEAD METHODS - FULLY BURDENED RATE - Ability to for an overhead rate to be a fully burdened rate by employee that includes payroll, benefits, insurance, retirement, pension obligation and taxes.
PROJECTS-GRANTS	3.035	STATISTICAL FIELDS - Ability for projects to store statistical information (e.g., hours, lane miles, number of customers, number of accounts, number of employees, etc.) used for cost studies.
PROJECTS-GRANTS	3.036	BUDGET TRACKING - Ability to adjust project and grant budget (within security constraints) and to track changes, including committed and actual against budget.
PROJECTS-GRANTS	3.037	PROJECT EXPENDITURE WARNING - Ability for the system to generate a warning when project and phase expenditures exceed the original project estimates.
PROJECTS-GRANTS	3.038	ASSET CREATION APPROVAL PROCESS - Ability for capital improvement projects to go through a multi-level approval process before being capitalized (e.g., Approvals by AP and Finance Director).
PROJECTS-GRANTS	3.039	FUNDING SOURCES
PROJECTS-GRANTS	3.040	FUNDING SOURCES - Ability to track multiple funding sources (e.g., fund transfer, bonds, grants, etc.).
PROJECTS-GRANTS	3.041	TRANSFER FUNDS WITHIN PROJECT - Ability for authorized users to transfer funds within a project (e.g. from one phase to another).
PROJECTS-GRANTS	3.042	TRANSFER FUNDS ACROSS PROJECTS - Ability for authorized users to transfer funds from one project to another.
PROJECTS-GRANTS	3.043	CHANGE ORDERS
PROJECTS-GRANTS	3.044	CHANGE ORDERS - Ability to track change orders.
PROJECTS-GRANTS	3.045	CHANGE ORDERS - WORKFLOW - Ability to provide a change order workflow approval process.
PROJECTS-GRANTS	3.046	CLOSING PROJECTS
PROJECTS-GRANTS	3.047	PARTIALLY CLOSED PROJECTS - Ability to close a sub-project, but leave the main project active.
PROJECTS-GRANTS	3.048	ACTIVITY BY ACTIVE PROJECT ONLY - Ability to create, activate, suspend, and close projects allowing activity to be applied only to active projects or sub-projects.
PROJECTS-GRANTS	3.049	RE-OPEN CLOSED PROJECT - Ability for an authorized user to re-open a closed project.
PROJECTS-GRANTS	3.050	GRANT TRACKING FIELDS
PROJECTS-GRANTS	3.051	GRANT TRACKING FIELDS - Ability to track the following fields (along with the fields on regulatory reports):
PROJECTS-GRANTS	3.052	▪ Grant Number
PROJECTS-GRANTS	3.053	▪ Grant Name
PROJECTS-GRANTS	3.054	▪ Grant Status (Active, etc.)
PROJECTS-GRANTS	3.055	▪ Administering Department
PROJECTS-GRANTS	3.056	▪ Grant Funding Source
PROJECTS-GRANTS	3.057	▪ Grant Pass Through Funding Source
PROJECTS-GRANTS	3.058	▪ Grant Assistance Listing Number
PROJECTS-GRANTS	3.059	▪ Grant Period (From and To Dates)
PROJECTS-GRANTS	3.060	▪ Grant Award Notification Date
PROJECTS-GRANTS	3.061	▪ Grant Award Date
PROJECTS-GRANTS	3.062	▪ Grant Award Amount
PROJECTS-GRANTS	3.063	▪ Grant Amended Date
PROJECTS-GRANTS	3.064	▪ Grant Amended Amount
PROJECTS-GRANTS	3.065	▪ Grant Filing Date
PROJECTS-GRANTS	3.066	▪ Grant Match Required (Y/N)
PROJECTS-GRANTS	3.067	▪ Grant Match Source (multiple)
PROJECTS-GRANTS	3.068	▪ Grant Match Amount per Source
PROJECTS-GRANTS	3.069	▪ Grant Account Coordinator
PROJECTS-GRANTS	3.070	▪ Grant Contact Name
PROJECTS-GRANTS	3.071	▪ Grant Contact Phone Number
PROJECTS-GRANTS	3.072	▪ Grant Contact Email Address
PROJECTS-GRANTS	3.073	▪ Grant Purpose
PROJECTS-GRANTS	3.074	▪ Grant Comments
PROJECTS-GRANTS	3.075	AGENCY DEFINED GRANT FIELDS - Ability to use agency-defined grant fields.
PROJECTS-GRANTS	3.076	ONLINE WORKFLOW APPROVAL - Ability to route grants to appropriate users with notifications of their approval or disapproval. Allow entry of disapproval notes and ability to restart the approval process if required.
PROJECTS-GRANTS	3.077	GRANTS GENERAL FEATURES
PROJECTS-GRANTS	3.078	MULTI-DEPARTMENT GRANTS - Ability to track grants that span multiple departments.
PROJECTS-GRANTS	3.079	GRANT TASKS - Ability to track non-transaction tasks and due dates.
PROJECTS-GRANTS	3.080	GRANT STATUS - Ability to generate a report of all grants by status (e.g., applied, awarded, denied, closed, etc.).
PROJECTS-GRANTS	3.081	FISCAL YEAR EXPENDITURES- Ability to track grant expenditures by fiscal year.
PROJECTS-GRANTS	3.082	GRANT FISCAL YEAR - Ability to setup grant fiscal years that are different to that of the agency's (e.g. federal fiscal year).
PROJECTS-GRANTS	3.083	MULTI-YEAR GRANTS - Ability to track grants over multiple years.
PROJECTS-GRANTS	3.084	MULTI-YEAR GRANTS - ROLLOVER - Ability to rollover funds allocated to a specific grant for multiple years.
PROJECTS-GRANTS	3.085	UNSPENT GRANT REVENUES - Ability to reserve fund balance at year end for any unspent grant revenues.
PROJECTS-GRANTS	3.086	TRANSFER/DRAWDOWN - Ability to track and transfer funds within categories of a fund (e.g., CDBG, Transit FTA funds, etc.).
PROJECTS-GRANTS	3.087	GRANT DRAWDOWN PRIORITIZATION - Ability to establish prioritization of grant draw downs (e.g., spend grant A before grant B).
PROJECTS-GRANTS	3.088	GRANT BUDGETING - Ability to budget both revenue and expenditures for grants.
PROJECTS-GRANTS	3.089	ALLOWABLE EXPENSE TYPES BY GRANT - Ability to define allowable expense types for grant (e.g. wages, hourly rate limits, dollar amount limits, etc.).
PROJECTS-GRANTS	3.090	EXCEED/NOT TO EXCEED AMOUNTS BY GRANT AND DATES - Ability to define not to exceed amounts by grant and date range (e.g., fiscal year, grant year, calendar year, etc.).
PROJECTS-GRANTS	3.091	INQUIRIES & REPORTS
PROJECTS-GRANTS	3.092	SUMMARY OF PROJECT/GRANT STATUS REPORT - REVENUE AND EXPENDITURE - Ability to generate a summary of project/grant status report with project life-to-date budgets and actuals. Detail transactions must be accessible from previous years.
PROJECTS-GRANTS	3.093	PROJECT/GRANT TASK REPORTING - Ability to create ad hoc report on non-transaction tasks and due dates.
PROJECTS-GRANTS	3.094	MULTI-YEAR PROJECTS - Ability to inquire/report and drill down into project life-to-date history or specified timeline at both transaction detail and summary levels.
PROJECTS-GRANTS	3.095	BUDGETING AND FORECASTING - Ability to create "what-if" budgets and forecasts for a fiscal year, future fiscal years, and project as a whole.
PROJECTS-GRANTS	3.096	PROJECT/GRANT COST ANALYSIS - Ability to generate cost category productivity analysis (estimated vs. actual amounts).
PROJECTS-GRANTS	3.097	ACTIVE PROJECTS/GRANTS BY FISCAL YEAR - Ability to create an ad hoc report of active projects/grants from year-to-year.
PROJECTS-GRANTS	3.098	ACTIVE PROJECTS/GRANTS BY FUND - Ability to create an ad hoc report of active projects/grants by fund.
PROJECTS-GRANTS	3.099	RECONCILIATION REPORTS - Ability to create a reconciliation report of project/grant expenditures to cash account balances and draw downs.
PROJECTS-GRANTS	3.100	REIMBURSABLE INVOICES - PAYMENT STATUS - Ability to track unpaid and paid reimbursable invoices.
PROJECTS-GRANTS	3.101	REGULATORY REPORTS - Ability to generate required regulatory reports by filing and due date.
PROJECTS-GRANTS	3.102	AD HOC REPORTING - Ability to create an ad hoc Schedule of Federal and State Financial Assistance report containing the following fields:
PROJECTS-GRANTS	3.103	▪ Grant funding source
PROJECTS-GRANTS	3.104	▪ Grant pass through funding source
PROJECTS-GRANTS	3.105	▪ Grant assistance listing number
PROJECTS-GRANTS	3.106	▪ Grant number
PROJECTS-GRANTS	3.107	▪ Grant period starting date
PROJECTS-GRANTS	3.108	▪ Grant period ending date
PROJECTS-GRANTS	3.109	▪ Grant amount
PROJECTS-GRANTS	3.110	▪ Grant expenditures prior year
PROJECTS-GRANTS	3.111	▪ Grant expenditures current year
PROJECTS-GRANTS	3.112	▪ Unexpended grant amount
PROJECTS-GRANTS	3.113	AD HOC REPORTING - Ability to create an ad hoc report of application form log and funding request, including the following fields:
PROJECTS-GRANTS	3.114	▪ Project/grant log number
PROJECTS-GRANTS	3.115	▪ Funding request number
PROJECTS-GRANTS	3.116	▪ Project/grant name
PROJECTS-GRANTS	3.117	▪ Grant amount
PROJECTS-GRANTS	3.118	▪ Match amount
PROJECTS-GRANTS	3.119	▪ Total project budget
PROJECTS-GRANTS	3.120	▪ Total Project Budget
PROJECTS-GRANTS	3.121	EMPLOYEE TIME - Ability to generate a report of employee time across projects/grant and phases.
PROJECTS-GRANTS	3.122	INTERFACES & INTEGRATIONS
PROJECTS-GRANTS	3.123	INTEGRATION - BUDGETING - Ability to integrate with the Budgeting module to budget at the project/grant level and roll up to the overall budget. Transactions entered into the Budgeting module must also update the Project/Grant Accounting module.
PROJECTS-GRANTS	3.124	INTEGRATION - GENERAL LEDGER - Ability to integrate a project/grant number with the General Ledger module at the transaction level so that accounts in both systems remain in balance at all times. Transactions entered into the General Ledger modules must also update the Project/Grant Accounting module.
PROJECTS-GRANTS	3.125	INTEGRATION - CONTRACT MANAGEMENT - Ability to integrate with the Contracts Management module, providing an alert when project/grant costs exceed the contract amount (plus net change orders). Transactions entered in the Contract Management application must also update the Project/Grant Accounting module.
PROJECTS-GRANTS	3.126	INTEGRATION - PURCHASING - Ability to integrate a project/grant number with the Requisition/Purchasing module at a transaction level so that both systems remain in balance at all times. Transactions entered in the Requisition/Purchasing module must also update the Project/Grant Accounting module, including budget verification.
PROJECTS-GRANTS	3.127	INTEGRATION - ACCOUNTS PAYABLE - Ability to integrate with the Accounts Payable module to associate a project/grant number at a transaction level. Transactions entered into the Accounts Payable module must also update the Project/Grant Accounting module.
PROJECTS-GRANTS	3.128	INTEGRATION - FIXED ASSETS - Ability to integrate with the Fixed Assets module to automatically create a new fixed asset record upon the completion of a project/grant, regardless of whether the asset will be capitalized.
PROJECTS-GRANTS	3.129	INTEGRATION - FIXED ASSETS CONSTRUCTION IN PROGRESS - Ability to integrate projects/grants with the Fixed Assets module to book the construction in-progress value at each fiscal year-end for multiple-year construction projects.
PROJECTS-GRANTS	3.130	INTEGRATION - TIME AND ATTENDANCE - Ability to integrate Project Accounting with the Time and Attendance module. Transactions entered in the Time and Attendance module must also update Project Accounting.
PROJECTS-GRANTS	3.131	INTEGRATION - PAYROLL - Ability to integrate a project/grant number with the Payroll module to automatically calculate fully burdened rates for staff (e.g., payroll, benefits, insurance, taxes, PERS contributions, etc.).
PROJECTS-GRANTS	3.132	INTEGRATION - ACCOUNTS RECEIVABLE - Ability to integrate a project/grant number with the Accounts Receivable module in order to generate invoices for reimbursable projects/grants. Transactions entered in the Accounts Receivable module must also update the Project/Grant Accounting module.
PROJECTS-GRANTS	3.133	INTEGRATION - ELECTRONIC CONTENT MANAGEMENT SYSTEM - Ability to integrate with a third-party document management system (Laserfiche) to attach and store files or supporting documents to a record (e.g., spreadsheets showing calculations, grants, contracts, etc.).

&F &P of &N

4. Contract Mgmt

Colton CA - Enterprise Resource Planning Solution Feature Function Requirements
Please input a "1" in the appropriate column to the right of the feature/function/capability statement. Further explanations, or information regarding 3rd party software and/or modification costs should also be provided in the comments column and Project Costs worksheet (Appendix G), if applicable. Each "non-title" row (?.000) should have only one "1". Blank rows will be scored as Not Available.
Legend:
Standard - Current	Available in current software release
Standard - Next Release	Guaranteed available in next release of software
Report Writer	Report Writer function through Standard Reports or Ad Hoc Report Writer
3rd-Party Application	Please estimate general cost estimates in comments not a quote, unless available due to your resell arrangement.
Custom Modification	Custom programming by vendor (not meant to be a set-up configuration that is standard process through implementation. Please estimate general costs in comments (not a quote).
Not Available	Not available in current or next release; interfaced/integrated third-party application or through custom modification.

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Aug 7, 2025.