This chapter contains these topics:
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DEFAULT PROCESSING: | |
| 1. Enter the default Business Unit Type.
Leave blank (default) to display " " (blank) Business Unit Type. |
|
| 2. Enter a '1' to default a posting edit code of 'N' to the Job G/L account when adding a new Job. Leave blank to default a blank (' ') posting edit code (this account is used for Job Percent Complete). | This processing option is for an account that has a job number, but no cost code or cost type (EG: 501.blank.blank).
Once this account is created, the posting edit code can't be changed. |
| DW VERSION SELECTIONS: | |
| 3. Enter the Budget Setup (P510121) DREAM Writer version for the related function key exit. The default is version 'ZJDE0001'. | |
| 4. Enter the Job Status Inquiry (P512000) DREAM Writer version for the related function key exit.
The default is version 'ZJDE0001'. |
|
| 5. Enter the Job Master Revisions (P5108) DREAM Writer version for the related function key exit.
The default is 'ZJDE0001'. |
|
| PAYROLL FIELD DISPLAY SELECTION: | |
| 6. Enter a '1' to suppress all payroll fields from appearing on the screen.
Default of blank will display these fields. |
|
| EDIT OPTION: | |
| 7. Enter a '1' to issue a WARNING when a Job's Company is changed if the Job has accounts attached to it.
Enter a '2' to issue an ERROR. Leave blank (default) for no edit. |
|
| REQUIRED FIELD OPTIONS: | |
| 8. Enter a '1' to require the entry of Job Category Code Information when adding a Job Master. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DEFAULT OPTIONS: | |
| 1. Enter a default Business Unit ("B.U.") Type, or enter an asterisk ("*") to display all B.U. Types.
Leave blank (default) to display B.U. Type ' ' (blank). |
|
| 2. Enter a '1' to default a posting edit code of 'N' to the Job G/L account when adding a new Job. Leave blank to default a ' ' (blank) posting edit code (this account is used for Job Percent Complete). | This processing option is for an account that has a job number, but no cost code or cost type (EG: 501.blank.blank). Once this account is created, the posting edit code cannot be changed. |
| DW VERSION SELECTION: | |
| 3. Enter the Budget Setup (P510121) DREAM Writer version for the related option selection exit. The default is version 'ZJDE0001'. | |
| 4. Enter the Job Master Revisions (P5108) DREAM Writer version for the related selection option exit.
The default is 'XJDE0001'. |
|
| EDIT OPTION: | |
| 5. Enter a '1' to issue a WARNING when a Job's Company is changed if the Job has accounts attached to it.
Enter a '2' to issue an ERROR. Leave blank (default) for no edit. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| FORMAT CONTROL: | |
| 1. Enter sequence numbers (1-3) to indicate which formats will appear in the second description and in what order.
If all are left blank, all formats will appear in the order shown below. Note: These are used with your format function key F5. Addr Line One City Phone Number Address Book No. Credit Message |
|
| DEFAULT SEARCH TYPE: | |
| 2. Enter the default Search Type that should appear upon entry into Name Search. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| ADDITIONAL MAINTENANCE: | |
| 1. Enter a '1' to automatically display the Controls Revisions screen on an add. | |
| 2. Enter a '1' to automatically display the category codes screen on an add. | |
| 3. Enter a '1' to automatically display bank information on an add. | |
| 4. Enter a '1' to automatically display the purchasing instructions screen on an add. | |
| 5. Enter a '1' to display the Company/ Business Unit Default screen on an add. This feature is optional and if the file F04015 is not found, the screen will not be displayed. | |
| AUDIT LOG FILE: | |
| 6. Enter a '1' to utilize the Audit Log file (F0101A). | |
| SEARCH TYPE: | |
| 7. Enter the search type value for suppliers. Default is 'V'. | |
| CURRENCY PROCESSING: | |
| 8. Enter the currency code that should default into the amount currency code field when adding a Supplier.
If left blank, the amount currency code will default from the Company associated with Security Business Unit from the Address Book. |
|
| DREAM WRITER VERSIONS:
Enter the version for each program. If left blank, ZJDE0001 will be used. |
|
| 9. Control Revisions (P010513) |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DISPLAY OPTIONS: | |
| 1. Select one of the following:
'1' = Allow multiple jobs with no project number. '2' = Allow one job per contract. Blank = Allow multiple jobs with a project number. |
|
| 2. Enter '1' to display the AIA Document field. | |
| 3. Enter '1' to suppress the display of the Sales/Use Tax fields. | |
| 4. Enter '1' to protect the Contract Hold Code field. | |
| 5. Enter '1' to suppress the display of Contract Summary/Recap information. | |
| FORMAT SELECTION: | |
| 6. Select the screen format to display:
'1' = Homebuilder format. Blank = Contract Management format. |
|
| PROCESSING MODE SELECTION: | |
| 7. Select the processing mode:
'1' = Mode 1 (Line Item method) '3' = Mode 3 (Account method- Incremental) |
|
| DW VERSION SELECTION: | |
| 8. Enter the Commitment Revisions (P4402) DREAM Writer version for the related function key exit.
The default is version 'ZJDE0001'. |
|
| DEFAULT OPTIONS: | |
| 9. Enter the default Contract Type.
Leave blank to default Type "OS". |
|
| 10. Enter '1' to bypass defaulting the tax information from the supplier and project or job. | |
| PROCESSING SEQUENCE SELECTION: | |
| 11. Select one of the following:
'1' = Automatically exit to the Contract Log screen after adding a contract. '2' = Automatically exit to the Commitment Revisions screen. Blank = Remain on the Contract Entry screen. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DISPLAY OPTIONS: | |
| 1. Select one of the following:
'1' = Allow multiple jobs with no project number. '2' = Allow one job per contract. Blank = Allow multiple jobs with a project number. |
|
| 2. Enter '1' to suppress the display of the Sales/Use Tax fields. | |
| 3. Enter '1' to suppress the display of Contract Summary/Recap information. | |
| FORMAT SELECTION: | |
| 4. Select the screen format to display:
'1' = Homebuilder Bid Contracts. '2' = Homebuilder Takeoff. Blank = Contract Management. |
|
| DEFAULT OPTIONS: | |
| 5. Enter the default Contract Type.
Leave blank to default Type "OS". |
|
| EDIT OPTIONS: | |
| 6. Enter '1' to prevent changes to the Base Contract. | |
| 7. Enter '1' to edit the Commitment Distribution against the Job Master Job Status (posting edit). | |
| 8. Enter '1' to edit for duplicate distribution items. | |
| 9. Enter '1' to prevent changes to commitment line item amounts if the change would cause the commitment amount to be less than the vouchered amount.
Leave blank to allow the change but issue a warning. |
|
| 10. Enter '1' to prevent changes to the total contract amount if the change would cause the total contract amount to be less than the total vouchered amount.
Leave blank to allow the change but issue a warning. |
|
| 11. Enter '1' to compare the total committed amount to the budget amount and display a warning if the account's committed amount exceeds its budget.
Leave blank for no edit. |
|
| 12. Enter the Budget Ledger Type to use for the budget edit above.
Leave blank to use the Revised Budget Ledger Types defined in User Defined Codes (System 51, Codes RB/RU). |
|
| COMMITMENT DESCRIPTION OPTION: | |
| 13. Enter '1' to retrieve the Commitment Distribution line description from the account.
Leave blank to retrieve it from the cost code header account. |
|
| DW VERSION SELECTION: | |
| 14. Enter the Contract Entry (P44001) DREAM Writer version for the related function key exit.
The default is version 'ZJDE0001'. |
|
| 15. Enter the Pay Point Percentage Allocation (P44642) DREAM Writer version for the function key exit.
The default is 'ZJDE0001'. NOTE: This is for the Home Builders product only. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DEFAULT OPTION: | |
| 1. Enter the default Contract Type.
Leave blank to default Type 'OS'. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DISPLAY OPTIONS: | |
| 1. Select one of the following:
'1' = Allow multiple jobs with no project number. '2' = Allow one job per contract. Blank = Allow multiple jobs with a project number. |
|
| 2. Enter '1' to suppress the display of the Sales/Use Tax fields. | |
| 3. Enter '1' to suppress the display of Contract Summary/Recap information. | |
| FORMAT SELECTION: | |
| 4. Select the screen format to display:
'1' = Homebuilder Bid Contracts. '2' = Homebuilder Takeoff. Blank = Contract Management. |
|
| DEFAULT OPTIONS: | |
| 5. Enter the default Contract Type.
Leave blank to default Type "OS". |
|
| EDIT OPTIONS: | |
| 6. Enter '1' to prevent changes to the Base Contract. | |
| 7. Enter '1' to edit the Commitment Distribution against the Job Master Job Status (posting edit). | |
| 8. Enter '1' to edit for duplicate distribution items. | |
| 9. Enter '1' to prevent changes to commitment line item amounts if the change would cause the commitment amount to be less than the vouchered amount.
Leave blank to allow the change but issue a warning. |
|
| 10. Enter '1' to prevent changes to the total contract amount if the change would cause the total contract amount to be less than the total vouchered amount.
Leave blank to allow the change but issue a warning. |
|
| 11. Enter '1' to compare the total committed amount to the budget amount and display a warning if the account's committed amount exceeds its budget.
Leave blank for no edit. |
|
| 12. Enter the Budget Ledger Type to use for the budget edit above.
Leave blank to use the Revised Budget Ledger Types defined in User Defined Codes (System 51, Codes RB/RU). |
|
| COMMITMENT DESCRIPTION OPTION: | |
| 13. Enter '1' to retrieve the Commitment Distribution line description from the account.
Leave blank to retrieve it from the cost code header account. |
|
| DW VERSION SELECTION: | |
| 14. Enter the Contract Entry (P44001) DREAM Writer version for the related function key exit.
The default is version 'ZJDE0001'. |
|
| 15. Enter the Pay Point Percentage Allocation (P44642) DREAM Writer version for the function key exit.
The default is 'ZJDE0001'. NOTE: This is for the Home Builders product only. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DEFAULT OPTION: | |
| 1. Enter the default Contract Type.
Leave blank to default Type "OS". |
|
| VOUCHER NUMBERING: | |
| 2. Enter a two digit next number index for voucher numbering.
Leave blank to default index "01". Note: Index "01" will cause voucher numbers to be assigned from the A/P list of standard voucher numbers. |
|
| RETAINAGE OPTIONS: | |
| 3. Enter '1' to default retainage from the contract. | |
| 4. Enter a Pay Status to default for Retainage records.
Leave blank to default Pay Status "H" (Held). |
|
| DW VERSION SELECTION: | |
| 5. Enter the Commitment Revision (P4402) DREAM Writer version for the related function key exit.
The default is version "ZJDE0001". |
|
| G/L OFFSET SELECTION: | |
| 6. Enter the G/L Offset to default on the contract's payable portion of progress payment vouchers.
Leave blank to default the Supplier's G/L Offset from Address Book. Note: Retention records are always created with the G/L Offset "RETN". |
|
| EDITING OPTION: | |
| 7. Enter '1' to edit the Progress Payments against the Job Master Job Status (posting edit). | |
| DISPLAY OPTIONS: | |
| 8. Enter '1' to display Progress Payments in account number sequence.
Leave blank to sequence them by change order number. |
|
| 9. Enter '1' to suppress the display of contract lines with no commitments or payments.
Leave blank to display all lines of the contract. |
|
| DISPLAY OPTIONS (Cont'd): | |
| 10. Choose when to display the outstanding log detail warning message:
'1' = Display it upon verification of status, pay effect and expiration date (double cycle). '2' = Display it upon verification of status, pay effect, required date and expiration date (double cycle). Blank = Display it upon verification of status, pay effect and expiration date (single cycle) (default). |
|
| 11. Enter '1' to display a flashing log detail warning message. Leave blank for a non-flashing message. | |
| 12. Enter '1' to display the quantity field on the main detail line.
Leave blank to display the amount field on the main detail line. |
|
| 13. Enter '1' to suppress the display of the Sales/Use Tax fields. | |
| 14. Enter '1' to display the Homebuilder Format. | |
| OVERPAYMENT EDIT SELECTIONS: | |
| 15. Enter '1' to prevent overpayment of line items.
Leave blank to issue a warning when an overpayment occurs. |
|
| 16. Enter '1' to prevent overpayment of the contract.
Leave blank to issue a warning when an overpayment occurs. |
|
| UNIT PRICE VARIANCE SELECTIONS: | |
| 17. Enter the maximum allowed percent variance for Unit Priced contract lines (for example, enter 2 1/2% as '2.5'). | |
| 18. Enter the maximum allowed amount variance for Unit Priced contract lines.
Note: If Options 16 and 17 are both blank, the default is zero variance. |
|
| PAY STATUS DEFAULT PROCESSING: | |
| 19. Enter the Pay Status to default when outstanding log details exist.
Leave blank to default to the data dictionary. |
|
| 20. Enter the Pay Status to default when no outstanding log details exist.
Leave blank to default to the data dictionary. |
|
| PAYMENT OPTIONS: | |
| 21. Enter a '1' to create the Accounts Payable entries using the Project/ Job from the contract header.
Leave blank to use the contract line account when creating the A/P entries. Note: If you enter a '1' and the contract header does not have a Project/Job, all A/P entries will use the contract line account. |
|
| VAT ON RETENTION: | |
| 22. Enter a '1' to apply VAT to retention when it is released.
Default of blank will apply VAT to retention as it is vouchered. Note: Applies to tax explanation codes V and C. Retention must be released using Progress Payments to use this option. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| BATCH SELECTION: | |
| 1. Enter Batch Number or Batch Date or Batch User ID | |
| PRINT SELECTION: | |
| 2. Identify how to print amount fields on Post Journal:
'1' = to Millions (w/ commas) '2' = to Billions (w/o commas) Blank (Default) = No Journal Printed. |
|
| 3. Identify which account number to print on report:
'1' = Account Number '2' = Short Account ID '3' = Unstructured Account '4' = (Default) Number Entered During Input |
|
| FIXED ASSETS: | |
| 4. Enter a '1' to post F/A entries to Fixed Assets.
Note: DREAM Writer version ZJDE0001 of Post G/L Entries to Assets (P12800) is executed when this option is selected. All transactions selected from that DREAM Writer will be posted rather than just the current entries being posted to G/L. |
|
| 5. Enter a 'Y' if you wish to explode parent item time down to the assembly component level. Component billing rates will be used. (This applies to batch type 'T' only.) | |
| CASH BASIS ACCOUNTING: | |
| 6. Enter a '1' to create and post Cash Basis accounting entries. (Applies to batch type G, K, M, W, & R only.) | |
| 7. Enter units ledger type for Cash Basis Accounting entries.
(Default of blank will use "ZU" ledger type.) |
|
| ACCOUNTING FOR 52 PERIODS: | |
| 8. Enter a '1' for 52 Period Post.
Note: DREAM Writer data selection is used for 52 period posting ONLY. It is NOT used for the standard post to the F0902. Additionally, 52 period date patterns must be set up. |
|
| TAX FILE UPDATE: | |
| 9. Identify when to update the Tax Work file (F0018):
'1' = V.A.T. or Use Tax only '2' = for All Tax Amounts '3' = for All Tax Explanation Codes Blank (Default) = No Update to File Note: When using Vertex Taxes the Vertex Tax Register file will be updated instead of the Tax Work file for methods '1', '2', and '3'. |
|
| 10. Adjust VAT Account for Cash Receipt Adjustments and Write Offs. Tax explanation must be a 'V'.
'1' = update VAT amount only '2' = update VAT amount, extended price and taxable amount |
|
| 11. Adjust VAT Account for Discount Taken. The Tax Rules file must be set to Calculate Tax on Gross Amount, including Discount and Calculate Discount on Gross Amount, including Tax. Tax explanation must be a 'V'.
'1' = update VAT amount only '2' = update VAT amount, extended price and taxable amount |
|
| PROPERTY MANAGEMENT: | |
| 12. Enter DREAM Writer version of Property Management G/L Transaction Creation to be executed.
Default is version ZJDE0001. (This applies to batch types '2' and '/'.) |
|
| UPDATE OPTION: | |
| 13. Enter '1' to update short ID number, company, fiscal year/period number, century, and fiscal quarter in unposted transaction records selected for posting. (May be required for custom input programs.) | |
| REPORT FORMAT: | |
| 14. Enter a '1' to print the Posting Journal in a 198 character format.
The default of blank will print the format with 132 characters. |
|
| DETAILED CURRENCY RESTATEMENT: | |
| 15. Enter a '1' to create currency restatement entries. This creates records in the XA, YA, and/or ZA ledgers depending on the version you are running. | |
| 16. Enter the version of the Detailed Currency Restatement (P11411) to execute.
Default of blank will execute ZJDE0001. |
|
| RECONCILIATION FILE PROCESSING: | |
| 17. Enter a '1' to update the Cross-Environment Reconciliation file. Blank will not update the reconciliation file.
Note: The Cross-Environment Reconciliation file can also be updated through the stand-alone Cross-Environment File Creation program. |
|
| REVERSING JOURNAL ENTRIES: | |
| 18. When normal number of periods = 12 or 13 and posting a reversing entry into period 12 or 13, enter a '1' to create reversing journal entries to the first period of the following year. This is to avoid posting reversing entries to an adjusting period.
Example: Normal number of periods = 12. Period 12 ends 12/30/xx and period 13 ends 12/31/xx. Journal Entry date of 12/30/xx will post reversing entry to period 01 of next year if processing option is set to '1'. |
|
| BATCH TYPE SELECTION:
Note: This option should NOT be changed by User. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| TOTAL DISPLAYS: | |
| 1. Enter a '1' to display the Pay Status 'A' Total and the Grand Total in the header portion of the screen.
Note: This may require additional processing time. These totals will still appear at the end of the screen detail. |
|
| FORMAT CONTROL: | |
| 2. Enter format numbers (1-4) to indicate which formats will appear and in what order.
If all are left blank, all formats will appear in the order shown below. Discount Amount Approver Number Supplier Invoice Number Net Due Date Note: These are used with the format selection function key. |
|
| PRE-LOADED DATA SELECTIONS: | |
| 3. Any values that are entered for the following fields will be loaded on screen.
Pay Status Document Type G/L Offset (*=All) Currency Code (*=All) Payment Instrument (*=All) Approver Number (*=All) |
|
| PRE-LOADED ADDITIONAL SELECTIONS: | |
| 4. Any values that are entered for the following fields will be loaded into the Additional Selections.
Total Inquiry Amount Supplier Invoice Number Consolidation Code Bank Record Type |
|
| DREAM WRITER VERSION: | |
| 5. Enter the Version of Vendor Ledger Inquiry to be called.
If left blank, the default of ZJDE0001 will be used. |
|
| EDIT ON BANK ACCOUNT: | |
| 6. If using alternate currency payments, enter a '1' if you do not want to edit the G/L Bank Account's Currency. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PAYMENT SELECTION: | |
| 1. Enter in either a Pay Thru date or the number of displacement days from today.
Pay Thru Date Displacement Days |
|
| 2. Enter a '1' to include all Credit Memos in this payment run regardless of Due Date. | |
| DISCOUNT DATE: | |
| 3. Enter the cutoff date for allowing discounts. Pay items with a due date prior to this date will not take a discount.
If left blank, all discounts will be taken. |
|
| 4. Enter a '1' to bypass the voucher if the discount cut off is missed and the Net Due Date is later than the Pay Thru date.
If left blank, the Net Due Date will not be considered. |
|
| AMOUNT RANGE: | |
| 5. Enter the payment amount range to be included in this pre-payment run.
Also enter the pay instrument to be assigned to payments outside of the amount range. If currency conversion is turned on, enter the currency code for the amount range. Enter your amount range in whole numbers. Minimum Amount Min Pay Instrument Maximum Amount Max Pay Instrument Currency Code |
|
| COMPANY PROCESSING: | |
| 6. Enter a '1' to create a different payment by company. Leave blank to process multiple companies on each payment. | |
| DUE DATE PROCESSING: | |
| 7. Enter a '1' to print a separate payment by due date.
If left blank a separate payment by due date will not be printed. Note: If choosing this option, the DREAM Writer sequence should be set to include Due Date after Alternate Payee Address Number. |
|
| PAYEE PROCESSING: | |
| 8. Enter a '1' to create one payment per payee regardless of supplier. | |
| PRINT CONTROL: | |
| 9. Enter a '1' to print a special attachment when payment detail information will not print on the stub. | |
| 10. Enter the sequence ID which will order the payments when printed. | |
| 11. Enter a '1' to print the full address for each payee on the Edit report.
Leave blank to only print the payee alpha name. |
|
| 12. Enter a '1' to print contract information on the report. | |
| 13. Enter a '1' to print job information on the report.
Note: If choosing either option 10 or 11, payments should be sequenced by contract number. |
|
| PAY ITEM SUMMARIZATION: | |
| 14. Enter one of the following values to summarize the document on the pay stub and/or attachment.
If left blank, no summarization will occur. '1' - By Document and Due Date '2' - By Document |
|
| 15. Enter a '1' to have the summary description on the pay stub default from the first pay item's remark.
If left blank, the description will be retrieved from the vocabulary overrides for this program. |
|
| BANK ACCOUNT: | |
| 16. Enter an override bank account to be used for payment.
If left blank the bank account in the Accounts Payable detail record will be used. Note: This must be a Short Acct ID. |
|
| CURRENCY PROCESSING: | |
| 17. Enter one of the following values to indicate which currency should be used for payment.
' ' - Bank Account Monetary Unit '1' - Voucher Domestic Currency '2' - Voucher Foreign Currency '3' - Current Domestic Amount '4' - Alternate Currency Payment If Alternate Currency payment, enter the currency code of the payment. If Current Domestic payment, enter Effective Date to retrieve exchange rate. If blank, the system date will be used. |
|
| BUSINESS UNIT PROCESSING: | |
| 18. Enter a '1' to use the business unit as a selection criterion in the creation of a Payment Control Group.
If left blank, business unit will not be considered and one PCG may include vouchers with different business units. |
|
| ELECTRONIC FUNDS TRANSFER/EDI ONLY: | |
| 19. Enter a '1' if you will be using tape output and would like to see tape information on the edit report.
If left blank, no tape information will appear on the report. |
|
| 20. Enter a '1' if using tape output and you would like to be notified if Supplier is set to Pre-Note status.
Note: PRE will print under Supplier Name. |
|
| 21. Enter a '1' to issue an error on the edit report if the Payee's EFT/EDI bank information does not exist. | |
| 22. Enter a '1' to issue an error on the edit report if a G/L Bank Account's X12 information does not exist. | |
| 23. Enter an override Effective Date and Bank Type to use to retrieve Bank Account/Transit data.
If left blank, the System Date and the Bank Type on the voucher will be used. Effective Date Bank Type |
|
| CALCULATE WITHHOLDING: | |
| 24. Enter a '1' submit the Calculate Withholding program (P04580) prior to running Pre-Payments.
If left blank, Calculate Withholding will not be run. Note: The voucher withholding pay items created will not be posted. |
|
| 25. Enter the DREAM Writer version number of the Calculate Withholding program to be run.
If left blank, version ZJDE0001 will be used. |
|
| USER EXIT OPTION: | |
| 26. Enter the User Exit program name.
If left blank the name 'X04570E' will be used. |