This chapter contains these topics:
Section 43.1, "Contract Entry (P5201) (Release A9.4 Update),"
Section 43.2, "Owner Pay Item Details (P5202) (Release A9.4 Update),"
Section 43.3, "Service Billing Invoice Generation (P48121),"
Section 43.7, "Contract Billing Invoice Generation (P52800),"
Section 43.8, "Owner Pay Item Status (P52200) (Release A9.4 Update),"
Section 43.13, "Contract Billing History Inquiry (P52250) (Release A9.4 Update),"
Section 43.14, "Contract Revenue Workfile Generation (P52801),"
Section 43.15, "Revenue Journal Generation - Contract (P48132),"
Section 43.19, "Service Billing Invoice Generation (P481201)"
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| FORMAT CONTROL: | |
| 1. Enter a '1' to suppress the Sales/Use Tax information fields. | |
| DEFAULT PROCESSING: | |
| 2. Enter the default G/L offset for retainage. | |
| CURRENCY OPTIONAL EDIT: | |
| 3. Enter a '1' to issue a warning message when currency is on and an amount is entered or changed.
Leave blank (default) to prevent the warning message from being issued. |
|
| VERSION LIST SELECTION:
Enter the DREAM Writer version for each program. If left blank, ZJDE0001 will be used. |
|
| 4. Owner Pay Item Details (P5202) | |
| 5. Copy Contracts (P52COPY) | |
| 6. Owner Pay Item Status (P52200) |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| OPTIONAL EDITS: | |
| 1. Enter '1' to prevent changes to the base contract (all changes must then be entered as change orders). Leave blank (default) to allow changes to the base contract. | |
| 2. Select one of the following:
'1' = Issue a WARNING if Schedule of Values does not equal Budget. '2' = Issue an ERROR if Schedule of Values does not equal Budget. ' ' = No edit (default). |
|
| 3. Enter the budget ledger type to use for the budget edits. Leave blank (default) to use the Revised Budget Ledger Types (User Defined Codes, System 51, Code RB). | |
| FORMAT CONTROL: | |
| 4. Enter '1' to display the Unit Price on the main line and the Schedule of Values amount in the fold. Leave blank (default) to display the Unit Price in the fold. | |
| 5. Enter '1' to use the "Skip to" field to enter line numbers. Leave blank (default) to enter billing lines. | |
| 6. Enter '1' to suppress the Sales/Use tax information fields. | |
| 7. Enter '1' to not issue a warning message when no billing line cross reference information exists in the "Add" mode. Leave blank (default) to issue a warning. | |
| 8. Select the account search window:
'1' = Change Management (business unit, cost code, cost type). This window will allow multiple accounts to be selected at one time. '2' = Contract Management (business unit, cost code, cost type). ' ' = General Ledger (business unit, cost type, cost code) (default) NOTE: This account search window will also be used by the Cross Reference Table (P5212) |
|
| ACCOUNT NUMBER DEFAULT: | |
| 9. When inquiring on an existing change order to add a change order, or when using Copy Contracts functionality,
enter '1' to derive the account(s) in the fold based on the appropriate AAI's. Leave blank (default) to retain the original contract's billing line account number. |
|
| CROSS REFERENCE AND TEXT CONTROLS: | |
| 10. When adding a new Owner Pay Item, you may choose to automatically access the Cross Reference and/or the Text screen for the Owner
Pay Item. Blank - Do not automatically access the Cross Reference or Text screens. 1 - Automatically access the Cross Reference screen. 2 - Automatically access the Text screen. 3 - Automatically access the Cross Reference and Text screens. |
|
| VERSION LIST SELECTION: | |
| 11. Revenue Recognition Workbench | |
| 12. Owner Pay Item Status (P52200) |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| INVOICE DOCUMENT TYPE OVERRIDE: | |
| 1. Enter the Invoice Document Type.
Leave blank (default) to use the Document Type specified in the Service Billing Constants. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| UPDATE OPTIONS: | |
| 1. Enter a '1' to allow updating all work file record information (except G/L Date, Cost, and Units).
Leave blank (default) to secure certain fields from being updated except when adding improvised transactions. |
|
| DISPLAY OPTIONS: | |
| 2. Enter a '1' to load all records that meet the search criteria.
Leave blank (default) to load two pages at a time (this improves performance). |
|
| 3. Enter the amount to initially display on the screen. All amounts can be accessed using the toggle function.
'1' = Base Revenue (default) '2' = Base Invoice '3' = Total Revenue '4' = Total Invoice '5' = Base Cost '6' = Total Cost |
|
| 4. Enter a '1' to display records that are included in a revenue batch.
Leave blank to display only records which have not been included in a revenue batch. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PRINT OPTION: | |
| 1. Choose one of the following to print:
'0' = All detail (default). '1' = Only one line of detail. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DISPLAY OPTIONS: | |
| 1. Enter a '1' to display all history records (default).
Enter a '2' to display only the records that are eligible for re-activation. |
|
| 2. Enter a '1' to load all records that meet the search criteria.
Leave blank (default) to load two pages at a time (this improves performance). |
|
| 3. Enter the amount to initially display on the screen. All amounts can be accessed using the toggle function.
'1' = Base Revenue (default) '2' = Base Invoice '3' = Total Revenue '4' = Total Invoice '5' = Base Cost '6' = Total Cost |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DATE SELECTION DEFAULT PROCESSING: | |
| 1. Enter the Bill From date to select the work file records for invoicing.
Leave blank (default) to retrieve all workfile records for invoicing with a basis date less than the Bill Thru date entered below. (T/M only) |
|
| 2. Enter the Bill Thru date to select the work file records for invoicing.
Leave blank (default) to use the system date. (All pricing types) |
|
| DATE ASSIGNMENT DEFAULT PROCESSING: | |
| 3. Enter the G/L date to assign to the summary billing work file records.
Leave blank (default) to use the system date. |
|
| 4. Enter the Invoice date to assign to the summary billing work file records. Leave blank (default) to use the system date. | |
| RECURRING BILLING OPTIONS: | |
| 5a. Enter up to five recurring billing frequency codes for lump sum pay item lines. | |
| 5b. Enter '1' to use the Schedule of Values (SCOF) on Recurring Lump Sum billing lines as the total maximum amount to bill. The system will calculate a $0 billing amount once the total billed to date has reached the Schedule of Values amount. | |
| ZERO INVOICE SUPPRESSION: | |
| 6. Enter a '1' to suppress the creation of invoices with zero billing amounts. | |
| FIXED PRICE CALCULATION METHOD: | |
| 7. Select the method for calculating lumpsum billing amounts:
'1' = Percent Complete method. '2' = Markup Percent of Cost method. blank = Use the greater of the two methods (default). |
|
| INVOICE OVERRIDE OPTIONS: | |
| 8. Enter the Invoice Document Type.
Leave blank (default) to use the Invoice Document Type specified in the Service Billing Constants. |
|
| 9. Enter values in the following to override the Contract/Billing Line defaults:
a. Tax Rate/Area b. Tax Explanation Code c. Payment Terms Code NOTE: If any of the above are invalid or left blank, the values will default from the Contract Master for the Payment Terms Code, and the Contract Billing Line for the Tax Rate/Area and Explanation codes. |
|
| CURRENCY PROCESSING: | |
| 10. Select the date to use to retrieve the currency exchange rate:
'1' = Invoice date (default). '2' = G/L date. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DEFAULT PROCESSING: | |
| 1. Enter the Contract Type to use. Leave blank to use default type 'R2'. | |
| DISPLAY: | |
| 2. Enter '1' to display PLA amounts on the screen. Leave blank to suppress the display of PLA amounts. | |
| VERSION LIST SELECTION: | |
| 3. Enter the version of Revenue Recognition (P03116) to use. If left blank, version ZJDE0001 will be used. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PRINT SELECTION: | |
| 1. Enter the Layout Type to print. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| JOURNAL DESCRIPTION SELECTION: | |
| 1. Choose one of the following for the journal entry description:
'1' = Use the description from the Vocabulary Overrides based on the Table Type. '2' = Use the description associated with the subledger value. ' ' = Use the description from the Account Master for the Account being used (default). |
|
| PRINT REPORT SELECTION: | |
| 2. Enter a '1' to print the Billing Edit/Register (P48300). | |
| REVENUE JOURNAL VERSION SELECTION: | |
| 3. Enter the version number of the Revenue Journal Generation program (P48132) for processing any adjustments.
Leave blank (default) to use version 'XJDE0001'. |
|
| SUPPRESS WARNING MESSAGES: | |
| 4. Choose one of the following to control the printing of the exception report:
' ' = Print all records (default). '1' = Print warnings and errors. '2' = Print errors only. '3' = Do not print the report. |
|
| DATE SELECTION: | |
| 5. Enter the G/L date to assign to the revenue journal entries created by Revenue Journal Generation program (P48132).Leave blank (default) to use the G/L date given in the processing option of P48132. | If you run the P48132 program from the P48131 program, review how the system selects a G/L date:
If you do not run the P48132 program from the P48131 program, review how the system selects a G/L date:
|
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PRINT SELECTION: | |
| 1. Enter the Layout Type to print. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PRINT SELECTION: | |
| 1. Enter the Layout Type to print. | |
| 2. Select the order for printing the invoices. This will add sequencing prior to the major sequencing on the invoice format definitions.
blank = original sequence of the batch (default) '1' = invoice number '2' = contract number, invoice number '3' = parent contract number, contract number, invoice number |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| VERSION LIST SELECTION: | |
| 1. Enter the version of the Sub Ledger Inquiry Program (P032002) to use. Leave blank to use "ZJDE0001". | |
| 2. Enter the version of the Contract Billing Line Status (P52200) to use. Leave blank to use "ZJDE0001". |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| REVENUE ON RECURRING BILLING PAY ITEMS: | |
| 1. Enter up to five recurring billing frequency codes for lump sum pay items. Workfile revenue records (F4812s) will be created for the lump sum pay item amount(s). |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DATE SELECTIONS: | |
| 1. Enter the cut-off date for retrieving work file records. Records with a G/L date after this date will not be processed.
Leave blank (default) to use the system date as the cut-off date. |
|
| 2. Enter the G/L date to assign to the revenue journal entries created.
Leave blank (default) to use the G/L date of the source transaction. |
Leave the G/L date blank when you run only P48132 and you are not running P48132 from P48131.
If you run the P48132 program from the P48131 program, review how the system selects a G/L date:
If you do not run the P48132 program from the P48131 program, review how the system selects a G/L date:
|
| PRINT OPTIONS: | |
| 3. Choose one of the following to control the printing of the exception report:
blank = Print all records (default). '3' = Do not print the report. |
|
| 4. Enter a '1' to print the Billing Edit/Register report (P48300). | |
| JOURNAL DESCRIPTION SELECTION: | |
| 5. Choose one of the following for the journal entry description:
'1' = Use the description from the Vocabulary Overrides based on Table Type. '2' = Use the description associated with the subledger value. blank = Use the description from the Account Master (default). |
|
| ERROR BATCH SEGREGATION: | |
| 6. Enter '1' to perform the Error Batch Segregation function. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| FORMAT CONTROL OPTIONS: | |
| 1. Select the account search window to use:
'1' = Contract Management (business unit, cost code, cost type). ' ' = General Ledger (business unit, cost type, cost code) |
|
| 2. Enter a '1' to display the employee number and name on the main line.
Leave blank (default) to display the markup amount and percent on the main line. |
|
| SECURITY OPTIONS: | |
| 3. To prevent access to certain table key types, enter '1's below. Leave blank (default) to allow access to the table key types.
Key Type 1 (Work Order No.): Key Type 2 (Work Order Class): Key Type 3 (Contract No.): Key Type 4 (Parent Contract No.): Key Type 5 (Customer No.): Key Type 6 (Job/Business Unit): Key Type 7 (Job Class): Key Type 8 (Company): Key Type 9 (Default for Account Derivation and Markup Tables): |
|
| 4. To prevent access to certain table generation types, enter '1's below.
Leave blank (default) to allow access to the table generation types. Generation Type 1 (invoice, revenue and component markups). Generation Type 2 (revenue markup override). Generation Type 3 (component markup override). |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| SECURITY OPTION: | |
| 1. To prevent access to certain table key types, enter '1's below. Leave blank (default) to allow access. a. Key Type 1 (Work Order No.): b. Key Type 2 (Work Order Class):
c. Key Type 3 (Contract No.): d. Key Type 4 (Parent Contract No.): e. Key Type 5 (Customer No.): f. Key Type 6 (Job/Business Unit): g. Key Type 7 (Job Class): h. Key Type 8 (Company): i. Key Type 9 (Default for Account Derivation and Markup Tables): (More....) |
|
| EDIT OPTION: | |
| 2. Specify how to edit for blank values in the Resulting Account Business Unit or Object Account. blank = error, blanks not allowed
0 = warning only, blanks allowed 1 = blanks allowed (no warnings) Note: If the Resulting Account business unit or object is blank, then the default revenue account in the customer master will be used. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| COPY OPTIONS: | |
| 1. Enter a '1' to retain the same
company number on the new contract. Note: When using multi-currency and allowing a change to the company number, the currency code of the copied contract must match that of the contract being copied |
|
| 2. Enter a '1' to copy the Project/Job
(MCUS) from the original contract. If you do not copy the project/job, you will be prompted to enter it for the new contract. |
|
| 3. Enter a '1' to copy amounts to the
new contract. This includes schedule of values, quantity, unit price, recurring billing code and amount, NTE, and minimum amounts (where applicable). |
|
| 4. Enter a '1' to copy all owner pay
item (billing line) text. |
|
| 5. Enter a '1' to copy the contract
logs. |
|
| 6. Enter a '1' to copy tax rate/area
and tax explanation code values from the billing lines of the original contract to the billing lines of the new contract. Leave blank to use the tax rate/area and tax explanation code from the new contract master |
|
| DISPLAY OPTIONS: | |
| 7. Enter a '1' to bypass the Contract
Master Additional Detail (P52011) video. |
|
| 8. Enter a '1' to bypass the Contract
Master Category Codes (P52012) video. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| CONTRACT REVENUE GENERATION OPTIONS: | |
| 1. To generate revenue for Contract non-T&M lines, enter the Contract Revenue Workfile Generation (P52801) DREAM Writer version to run. | |
| 2. If you entered a version number above, you must also enter the following dates:
a. Enter the beginning date for revenue generation: b. Enter the ending date for revenue generation: |
|
| HOME BUSINESS UNIT SELECTION: | |
| 3. Enter a '1' (default) to use the Item Master file as the source of the Home Business Unit for payroll equipment records. Enter a '2' to use the Payroll Master file as the source. | |
| Date Selection: | |
| 4. Enter a '1' to use the voucher invoice date to populate the supplier invoice date or leave blank (default) to use the voucher G/L Date. |