186 Processing Options

This chapter contains these topics:

186.1 Tenant/Lease Master (P1501)

Processing Option Processing Options Requiring Further Description
OVERRIDE OPTION:  
1. Lease Master square footage defaults from Unit Master information. Enter Log Classes and Amenity IDs below if you want to OVERRIDE the REM Constants which identify square footage:

a. RENTABLE square footage Log Class:

b. RENTABLE sq. footage Amenity ID:

c. USEABLE square footage Log Class:

d. USEABLE square footage Amenity ID:

  
EDIT AND DEFAULT PROCESSING:  
2. Enter a '1' to require a Lease Manager number.  
3. Enter a '1' to protect the Required Standards field.  
4. Choose how to edit the Unit number:

'1' = Unit number optional (blanks allowed).

'2' = Invalid Unit number allowed.

Blank = Valid Unit number required (default).

  
EDIT AND DEFAULT PROCESSING Cont'd:  
5. Enter a '1' to suppress warning messages if the Unit number is blank or invalid. All error messages will still be issued.  
6. Enter a '1' to bypass automatically copying in Log Standards to new Leases.  
7. Enter a '1' to bypass defaulting the Lease Begin Date into the Lease Move- In Date field. Leave blank to default the Move-In Date.  
EDIT AND DEFAULT PROCESSING Cont'd:  
8. Enter a '1' to bypass defaulting the Lease End Date into the Lease Plan-Out Date field. Leave blank to default the Plan-Out Date.  
9. Enter a '1' to display the DBA fields in the fold area of the screen.  
10. Enter a '1' to fill no more than one screen upon the initial inquiry and subsequent screen rolls. Leave blank (default) to fill all screens upon initial inquiry.  
EDIT AND DEFAULT PROCESSING Cont'd:  
11. Enter a '1' to allow the display and entry of non-speculative leases only. Enter '2' to allow the display and entry of speculative leases only. Leave blank (default) to allow the display and entry of both speculative and non-speculative leases.  
12. Enter a '1' to activate the FASB 13 warning window if FASB related data is changed, and FASB has already been generated for the Lease.  
EDIT AND DEFAULT PROCESSING Cont'd:  
13. Enter a '1' to require a collection manager number.  

186.2 Update Holdover Lease Dates (P15090)

Processing Option Processing Options Requiring Further Description
PROOF/FINAL:  
1. Enter a '1' to update files.

Default of blank will run this job in "proof" mode with no file updates.

  
FROM DATE:  
2. Enter a FROM date to be used for selecting leases.  
TO DATE:  
3. Enter a TO date to be used for selecting leases. If left blank this will be the same as the FROM date.  
DATE SELECTION CRITERIA:  
4. Enter criteria for using above dates:

"1" = Modify end date of leases to date specified in option 6. (DEFAULT)

"2" = Extend leases by number of DAYS specified in option 5.

"3" = Extend leases by number of MONTHS specified in option 5.

"4" = Same as "3" except the DAY will be the last day of the month.

  
INCREMENT DAYS/MONTHS:  
5. Enter the number of days or months (based on option 4) to increment the lease end date.  
INCREMENT DATE:  
6. If using selection "1" in option 4,

enter the new end date for the selected leases.

  
LAST DAY OF MONTH:  
7. If using selection "3" in option 4

enter a "1" to set the new end date to the last day of the month ONLY if the current end date is the last day of the month.

  
NEW BILL CODE:  
8. Enter the new bill code for recurring billing records created by holdover, leave blank to use bill code of existing record.  
AUDIT TRAIL:  
9. Enter a "1" to create an audit trail of recurring billing records by suspending current records and creating new billing records. Leave blank to update existing records.

Default is a "1". (NOTE: An audit trail will be created if a bill code was entered in option 8.)

  
FILE UPDATE SELECTION:

Enter '1' to select the file(s) to update. The F1501 - Lease master file will always be updated.

  
10. F15012 - Expense Participation  
11. F15014 - Product Scale Master (Must be updated manually)  
12. F15015 - Minimum Rent/Recoveries  
13. F15016 - Escalation Master  
14. F1502 - Recurring Billing Master  
15. F1505 - Management Fee Master  
16. F1525 - A/R Fee Interest  
0.  
0.  
0.  
BILL CODE SELECTION:  
17. Enter 'S' to select specific Bill Codes or 'O' to omit them. Leave blank to include all Bill Codes.

List Bill Codes to select/omit: >

>

>

>

>

>

  
FASB 13 UPDATE:  
18. Enter a '1' to allow regeneration of FASB records updated by holdover.

Leave blank for no FASB file update.

  

186.3 Holdover Tenants Report (P15490)

Processing Option Processing Options Requiring Further Description
BILL CODE SELECTION:  
1. Enter the bill codes to be used for identifying base rent amounts.  
DOCUMENT TYPE SELECTION:  
2. Enter the document types to be excluded from receivables balance. >

(Key in document types for pre- > payment and credit receivable > transactions).

  
DETAIL/SUMMARY:  
3. Enter a "1" to print a summary report Leave blank to print a detail report  

186.4 Billing Modifications / Manual Entry (P1511)

Processing Option Processing Options Requiring Further Description
DISPLAY OPTIONS:  
1. Enter '0' to display the tax fields.

Enter '1' to suppress the tax fields.

Leave blank to default to the REM Constants to control tax processing.

  
2. If the tax fields are suppressed,

enter '1' to suppress the display of the Service/Tax Date field.

  
OPTIONAL EDITS:  
3. Enter '1' to bypass editing the business unit as a valid building for the lease.  
OPTIONAL EDITS (Cont'd):  
4. To restrict changes and entries to a specific Generation Type, enter that Generation Type.  

186.5 Billing Edit/Register - A/R Fee & Intrst (P15300)

Processing Option Processing Options Requiring Further Description
BATCH SELECTION:  
1. Enter the batch number. If left blank, batches included are based on DREAM Writer selections and the batch headers are not updated.  
PRINT OPTIONS:  
2. Select one of the following:

'1' = Print no transaction listing.

'2' = Print an error list only.

Blank = Print ALL transactions.

  
3. Enter a '1' to print associated invoice text.

(...More..)

  
PRINT OPTIONS (Cont'd):  
4. Enter '1' to suppress the printing of warning messages. Error messages will still be printed.  
G/L SUBLEDGER OPTION:  
5. Specify the value P15199 will use to populate the F0911 subledger when the transactions are posted:

' ' = Use the current F1511 value

1 = Tenant (Subledger Type = A)

2 = Lease (Subledger Type = L)

3 = Unit (Subledger Type = U) These values are compared with account Posting Edit Codes.

  

186.6 General Ledger Post (P09800)

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.

  

186.7 Prop. Mgt. G/L Trans. Gen. - Summarized (P15199)

Processing Option Processing Options Requiring Further Description
CREDIT PROCESSING:  
1. Enter a '1' to apply credit amounts to new invoices as they are posted.  
2. Choose the type of credits which should be applied: blank = only unapplied cash (default)

1 = all open credits

  
3. Enter the version number of the Cash Receipts & Adjustments Journal (P03311) which will display the credit application.  
4. Choose the type of date which should be used to match credits to invoices: blank = Invoice Date (default)

1 = Due Date

2 = Service/Tax Date

3 = G/L Date

4 = do not require matching date

  
CREDIT MATCHING:  
5. Choose whether or not to match credit to invoices using building and unit. blank = match credit by building and unit

1 = do not require matching building and unit

  
FASB 13 SUMMARIZATION OPTION:  
6. Enter a '1' to summarize the FASB 13 amounts by revenue account and by document number into the G/L Account Ledger.  
G/L SUBLEDGER OPTION:  
7. Specify a value to populate the F0911 subledger if the F1511 subledger is blank:

1 = Tenant (sbl type = A)

2 = Lease (sbl type = L)

3 = Unit (sbl type = U) If you leave this blank, the F0911 subledger will be blank if it is blank in the REM transaction (F1511).

  

186.8 Journal Review - PM Invoices (P152011)

Processing Option Processing Options Requiring Further Description
BATCH TYPE SELECTION:  
1. Enter the batch type to be reviewed.  

186.9 Property Management Invoices (P15500)

Processing Option Processing Options Requiring Further Description
DATE RANGE SELECTION:  
1. Enter the From Date for selecting invoices. Leave blank (default) to use the System Date.  
2. Enter the Through Date for selecting invoices. Leave blank (default) to use the System Date.  
AGING OPTION:  
3. Specify one of the following dates to age accounts from:

'D' = Due Date (default) 'I' = Invoice Date 'G' = General Ledger Date 'S' = Statement Date

  
PRINT OPTIONS:  
4. Enter '1' to print aging on invoices.  
0.  
5. Enter '1' to omit printing invoices with zero or credit balances.  
6. Enter '1' to print the first invoice Reference Number on the return portion. Leave blank to omit it.  
7. Enter '1' to omit invoice text.  
0.  
8. Enter '1' to add a "Tax Amount" column and print tax amounts, if any, separately on the invoices.  
AGING SPECIFICATIONS:  
9. Enter a '1' to retrieve the aging specifications from A/R Constants.

Leave blank (default) to use the processing options for aging.

NOTE: Report MUST be sequenced and set to page break by company if company defaults are selected.

  
AGING METHOD:  
10. Specify one of the following methods for aging calculations:

'1' = Aging Days (default)

'2' = Fiscal Periods

'3' = Calendar

  
CATEGORY INFORMATION:  
11. Enter the following aging category information: (method "1" only)

Beginning thru thru thru thru thru

  
FROM ADDRESS:  
12. Specify which address to print for the From address.

(Default of blank will print Company)

'1' = Facility address

'2' = Remit to address

  

186.10 Property Management Statements (P15501)

Processing Option Processing Options Requiring Further Description
AGE AS OF DATE:  
1. Enter the invoice cut off date (age as of date). A blank (default) will use today's date.  
PRINT AGING:  
2. Enter a '1' to print aging on the statements.  
PAID INVOICE INCLUSION:  
3. Enter a '1' to include paid invoices on the statements.  
PRINT OPTIONS:  
4. To omit printing statements with zero balances and/or credit balances, select one of the following:

'1' = Omit both zero and credit balance statements

'2' = Omit zero balance statements

'3' = Omit credit balance statements

  
5. Enter a '1' to print the balance forward statements.  
CURRENT PERIOD BEGINNING DATE:  
6. If printing balance forward state- ments (option 5 above), enter the beginning date of the current period.  
AGING SPECIFICATIONS:  
7. Enter a '1' to retrieve the aging specifications from the A/R Constants. Leave blank to use the processing options for aging.

NOTE: DREAM Writer sequence must be set to sequence by company if the company defaults are selected.

  
AGING METHOD:  
8. Specify one of the following methods for aging calculations:

'1' = Aging Days

'2' = Fiscal Periods

'3' = Calendar

  
AGING OPTION:  
9. Specify one of the following dates to age accounts from:

'D' = Due Date 'I' = Invoice Date 'G' = General Ledger Date 'S' = Statement Date

  
CATEGORY INFORMATION:  
10. Enter the following aging category information: (method "1" only)

Beginning thru thru thru thru thru

  
FROM ADDRESS:  
11. Specify which of the following, to print, for From address.

'1' = Facility address

'2' = Remit to address (Default of BLANK will print the company address)

  

186.11 Print Statements - Credit/Cash Build (P155001)

Processing Option Processing Options Requiring Further Description
AGING SELECTIONS:  
1. Enter '1' to print aging on the statements.  
2. Enter a '1' to retrieve the aging specifications and statement date from the A/R Company Constants.

Leave blank to use the following processing options for statement date and aging.

  
3. Enter the statement date to age open balances. If left blank, the current date will be used.  
4. Specify the date from which to age open balances:

D = Due Date (default)

I = Invoice Date

G = General Ledger Date

S = Statement Date

  
5. Specify the method for defining aging categories:

1 = Aging Days

2 = Fiscal Periods

3 = Calendar Months Blank will default to '1'.

  
6. If using the Aging Days method,

enter the aging day ranges:

Beginning thru thru thru thru thru

  
7. Enter a '1' to apply credits to the current aging balance. Leave blank to age credits.  
FORMAT CONTROL:  
8. Enter a '1' to print the "Remit To" address at the top of each statement. Default of blank will suppress the "Remit To" address from printing.  
9. Enter a '1' to suppress printing the Account Summary Information.

Blank (default) will print the Account Summary Information.

  
DATA SELECTIONS:  
10. Enter a '1' to bypass future dollars. A default of blank will include future dollars.

10a. Enter the future date to exclude future dollars.

  
11. Enter a '1' to exclude paid invoices. A default of blank will print paid invoices with current activity.  
12. Enter a '1' to process with multi- currency. Leave blank to process statements in domestic currency only.  
AS OF DATE:  
13. Specify the date to be used to select detail records. This date will be compared to the Statement Date:

D = Due Date

I = Invoice Date

G = General Ledger Date

S = Statement Date Leave blank to use aging date.

  
DREAM WRITER VERSION FOR P03500X:  
14. Enter the version number for the

F0311 Selection/Sort DREAM Writer Form ID P03500X. Blank will default to version ZJDE0005.

  
CREDIT/CASH MANAGEMENT BUILD:  
15. Enter a '1' to rebuild the temporary A/R Credit/Cash Mgmt.

work file (F0315WJA) prior to printing statements. If left blank, the existing file (F0315JA) will be used.

  
MESSAGE OPTIONS:  
16. Enter a message identifier to print at the top of the statement.

If blank, no special message will be printed.

  
17. Enter the message identifier for aging bucket 1.  
18. Enter the message identifier for aging bucket 2.  
19. Enter the message identifier for aging bucket 3.  
20. Enter the message identifier for aging bucket 4.  
21. Enter the message identifier for aging bucket 5.  
22. Enter the message identifier for aging bucket 6.  

186.12 Tenant A/R Cash Receipts-Head Down (P15103)

Processing Option Processing Options Requiring Further Description
FORMAT CONTROL:  
1. Select the entry method:

Blank = "Heads up".

'1' = "Heads down".

  
OPTIONAL EDITS:  
2. To prevent certain TI codes from being used, enter them here : >

>

>

>

>

>

>

>

  
OPTIONAL EDITS (Cont'd):  
3. Enter '1' to allow the discount taken to be greater than the discount allowed.  
4. Enter '1' to exclude credit balances from automatic application.  
5. Enter '1' to suppress automatic application of check amounts.  
OPTIONAL EDITS (Cont'd):  
6. Enter '1' to accept without review any check amounts that exactly match the total of all open amounts or which exactly match the total of all open amounts which originated from the Recurring Billing system. Enter

'2' to only accept those check amounts which exactly match all open amounts.

  
7. Enter '1' to limit batch entry by company number.  
OPTIONAL EDITS (Cont'd):  
8. Enter '1' to allow the amount applied to be greater than the amount open.  
DISPLAY OPTION:  
9. Enter '1' to suppress the display of security deposits.  
DUPLICATE CHECK OPTION:  
10. Enter '1' to create a hard error when a duplicate check/item number is entered within a batch.  
DEFAULT VALUES:  
11. Enter a '1' to default today's date into the Receipt Date. If left blank, no date will default.  

186.13 General Ledger Post (P09800)

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.

  

186.14 Tenant Billing Detail - All Properties (P15420)

Processing Option Processing Options Requiring Further Description
DATE SELECTION:  
1. Enter the as-of-date for processing the Tenant Billing Detail.  
PRINT OPTION:  
2. Enter '1' to print a detailed report.

Leave blank (default) for a summary.

  
TENANT INFORMATION SELECTION:  
3. Enter '1' to omit tenant information if the tenant has moved out prior to the as-of-date. Leave blank to include the tenant with a message that the tenant has moved out.  

186.15 Tenant Rent Roll - All Buildings/Annual (P15421)

Processing Option Processing Options Requiring Further Description
DATE SELECTION:  
1. Enter the as of date to determine the reporting period over which the Rent Roll will cover. Leave blank (default) to use the system date.  
BILLING AMOUNT SELECTION:  
2. Enter '1' to base billing figures on monthly amounts. Leave blank (default) to use annual amounts.  
3. Enter '1' to base billing amounts on gross figures. Leave blank (default) to calculate billing amounts per square foot.  
SECOND DETAIL LINE OPTION:  
4. Specify the display format of line 2 by selecting a. and b. Line 2 will not be displayed if BOTH a. and b. are left blank:

a. '1' = Annual rent amounts

'2' = Monthly rent amounts b. '1' = Amount per square foot

'2' = Gross amounts

  
LOG LINE SELECTION:  
5. Specify the log line to retrieve the description for the 2nd detail line: a. Log Class: b. Amenity ID:  
BILL CODE SELECTION:  
6. Enter the Bill Code(s) to be used for identifying base rent amounts: >

>

>

>

>

>

>

>

>

>

>

>

  
BILL CODE SELECTION (Cont'd):  
7. Enter the Bill Code(s) to be used for identifying Expense Participation billing amounts: >

>

>

  
8. Enter the Bill Code(s) to be used for identifying Escalation billing amounts: >

>

>

  
SQUARE FOOTAGE SELECTION:  
9. Choose the square footage to use:

'*RENTABLE'= Use the log class and amenity ID in the REM Constants to retrieve Rentable square feet.

'*USEABLE' = Use the log class and amenity ID in the REM Constants to retrieve Useable square feet.

Log Class = Use the log class entered here, along with the amenity ID entered below.

  
SQUARE FOOTAGE SELECTION (Cont'd):  
10. If you enter a log class in option  
9., enter an amenity ID here.  
0.  
RENT SELECTION:  
11. Select one of the following to print from the Unit Master:

'1' = Market Rent (default)

'2' = Renewal Rent

'3' = Potential Rent

  
VACANCY/FUTURES CONTROL SELECTION:  
12. Enter '1' to print vacancies. Enter

'2' to print vacancies and future leases. Leave blank (default) to print only occupied units.

  
PRINT OPTIONS:  
13. Enter '1' to print rent steps. Leave blank to print Sales Overage data.  
PRINT OPTIONS (Cont'd):  
14. Select the following to print:

a. Blank = Annual rent amounts

'1' = Monthly rent amounts

b. Blank = Rent per square foot

'1' = Gross rent c. Blank = Rent steps beginning with As-of Date

'1' = All rent steps

  
PRINT OPTIONS (Cont'd):  
15. Enter '1' to print the leased/ vacant totals. A default of blank will not display separate totals.

NOTE: Select this option only when vacancies are to be printed (See Option 12).

  
16. Enter '1' to print the building address on the report.  
17. Enter '1' to include speculative Leases.  
18. Enter '1' to include pre-Leases.  
PRINT OPTIONS (Cont'd):  
19. Enter '1' to include subleases.

Enter '2' to include subleases and corresponding rent amounts in totals. Leave blank (default) to omit subleases.

  

186.16 Tenant A/R Daily Balance (P15733)

Processing Option Processing Options Requiring Further Description
DATE SELECTION:  
1. Enter the start date for the report.

Transactions dated prior to this date will be summarized into the beginning balance. Transactions dated after this date will be printed on the report.

 This option will allow you to select the report start date. Any A/R transactions which have a G/L date prior to the report start date will not be printed on the report, but will affect the initial cumulative balances. Any A/R transactions which have a G/L date after the report start date will be printed on the report.
PRINT OPTIONS:  
2. Enter '1' to print all transactions associated with an invoice under that invoice. You can utilize this option to cause the report to print invoice detail information. If this option contains a '1', then every time an invoice record is printed, the program will display all transactions related to that invoice before continuing with the cumulative balance listing.
PRINT OPTIONS (Cont'd):  
3. Enter '1' to print cumulative balances by lease. Leave blank to print balances by tenant.

NOTE: The DREAM Writer must be sequenced accordingly.

 The report will calculate a cumulative balance for an individual tenant or for each individual lease.

186.17 Lease Summary Analysis (P15690)

Processing Option Processing Options Requiring Further Description
PRINT OPTIONS:  
1. Enter a '1' to print the Lease Dates.

Leave blank to omit them.

  
2. Enter the Business Unit Report Code number to use as the title line of the heading. Leave blank (default) to use the company name. PRINT OPTIONS (Cont'd)  
3. Enter up to ten Log Classes to use for summary analysis: >  

186.18 Lease Expiration Report - All Tenants (P15403)

Processing Option Processing Options Requiring Further Description
MONTH SELECTION:  
1. Enter the number of months this report should print into the future from the DREAM Writer selected Expiration Date. This option will allow you to define the number of months from the ending effective date to be used for reporting. You specify the ending effective date in the Data Selection portion of DREAM Writer.

Note: It is important for the integrity of this report that you include the ending effective date in the Data Selection. Otherwise, an error message will appear on the report.
OPTION LOG CLASS OVERRIDE:  
2. Enter an override option log class.

Leave blank to default to the User Defined Codes for Log Class to determine which log classes are options.

 If this is left blank, the system reviews the second description of the User Defined Codes for Log Type to determine which log types are lease options.

This option will allow you to specify a log type to be used to indicate that options exist. The report will display a date of the log type in the Option Date column of the report.
BILL CODE SELECTION:  
3. Enter the Bill Code(s) to be used for identifying Base Rent amounts: >

(Note: Maximum of 12)

 You have the ability to select the bill codes used to determine the base rent amount for the report.
PRINT OPTIONS:  
4. Enter '1' to print Lease Expiration in a condensed format (without rent amounts). Leave blank (default) for a detailed report. This option allows you to specify the format of the report you want to print. If you enter a '1', the report excludes the rent related columns.
5. Enter '1' to page break on change in building. This option allows you to start a new page when the program encounters a new Building.
6. Enter '1' to print the building address on the report.

NOTE: If options 5. and/or 6. are selected, the first sequence must be Building.

 You have the ability to print the Building address the report.

Note: Page breaks and addresses by Building require the Building as the first sequence.

186.19 Lease Abstract Follow-Up Worksheet (P15430)

Processing Option Processing Options Requiring Further Description
DATE SELECTION:  
1. Enter the as of date to use for this report.  
FORMAT SELECTION:  
2. Enter the Business Unit Report Code number to use as the title line of the heading. Leave blank (default) to use the company name.  

186.20 Vacancy Listing - All Buildings (P15600)

Processing Option Processing Options Requiring Further Description
UNIT SQUARE FOOTAGE SELECTION:  
1. Select the unit square feet to use:

*RENTABLE = Rentable square feet (default) *USEABLE = Useable square feet.

Log Class = Enter a log class to use, along with the amenity ID entered below.

  
2. Enter the amenity ID if you entered a log class above.  
BUILDING SQUARE FOOTAGE SELECTION:  
3. Select the building square feet to use:

*RENTABLE = Rentable square feet (default).

*USEABLE = Useable square feet.

Log Class = Enter a log class to use, along with the amenity ID entered below.

  
4. Enter the amenity ID if you entered a log class above.  
FLOOR SQUARE FOOTAGE SELECTION:  
5. Select the floor square feet to use:

*RENTABLE = Rentable square feet (default).

*USEABLE = Useable square feet.

Log Class = Enter a log class to use, along with the amenity ID entered below.

  
6. Enter the amenity ID if you entered a log class above.  
DATE SELECTION:  
7. Enter the as of date to use for this report.  
PRINT OPTIONS:  
8. Enter the Business Unit Report Code number to print as the title line of the report heading. Leave blank (default) to print the company name.  
9. To print specific log lines, enter the following: a. Log Class b. Amenity ID  
PRINT OPTIONS (Con'td):  
10. Select one of the following to print:

'1' = Market Rent (default)

'2' = Renewal Rent

'3' = Potential Rent

  

186.21 Critical Date Report - Satisfied (P15611)

Processing Option Processing Options Requiring Further Description
LOG RECORD TEXT OPTION:  
1. Enter '1' to omit log records which do not have associated log text. 1 - Only log lines with associated text will be included on the report.
PRINT OPTIONS:  
2. Enter '1' to print the building's address on the report heading. Leave blank (default) to print only the first line of description. 1 - The first line of description from the Property/Building Information record (F00062) and the address from the "Facility Address" field's address book record will print on the report.

Blank - Only the first line of description will be printed.
3. Enter a '1' to print the rentable square footage from the Lease unit details. Leave blank to print the quantity from the log lines. 1 - For Leases, the rentable square footage from the Lease will be printed on the report and the column heading will be displayed as "Rentable".

Blank - For Leases, the quantity from the log records will be printed on the report and the column heading will be displayed as Quantity.

186.22 Outstanding Chargeback Invoices (P15464)

Processing Option Processing Options Requiring Further Description
Enter an "As Of" date to include items which have not been worked. If left blank todays date will be used.  

186.23 Recurring Billing (P1502)

Processing Option Processing Options Requiring Further Description
DISPLAY OPTION:  
1. Enter '0' to display the tax fields.

Enter '1' to suppress the tax fields.

Leave blank to default to the REM Constants to control tax processing.

  
FORMAT CONTROL:  
2. Select the default screen format:

' ' = Standard Entry

'1' = Annual Rent PSF Format

'2' = Calculate Taxable Amount Format

  
3. Select the default date sequence:

'A' = ascending (within bldg/unit) 'D' = descending (within bldg/unit)

  
EDIT OPTION:  
4. Enter a '1' to perform date edits against the Lease Master. Leave blank (default) to bypass the edits.  
SQUARE FOOT BASIS SELECTION:  
5. Enter a '1' to indicate that the rate per square foot is based on the taxable billing amount. Leave blank (default) to indicate that the rate per square foot is based on the gross billing amount.  
FASB 13 OPTIONS:  
6. Enter a '1' to activate the FASB 13 warning window if any FASB 13 related data is changed and FASB has already been generated for the Lease.  
7. Enter a '1' to suppress the display of accrued and deferred FASB entries.

Leave blank to display both accrual and deferred entries.

  
DEFAULT OPTION:  
8. Enter a '1' to retrieve descriptions from the Bill Code Extension file.  
9. Enter a '1' to automatically copy the gross amount into the taxable field.

Default is 'Blank'.

  

186.24 R.B. Comparison - April - Exceptions (P15305)

Processing Option Processing Options Requiring Further Description
BILLING DATE SELECTION:  
1. Enter the billing period number.  
2. Enter the billing year.  
0.  
EXCEPTIONS ONLY:  
3. Enter a '1' to print lines without differences between Current and Prior Period Amounts.  
PRORATION SELECTION:  
4. Enter a '1' to prorate amounts which are in effect for partial periods.  
5. Enter a '1' to base proration on a

30 day month (if monthly).

  
CURRENT PERIOD OVERRIDE:  
6. Enter the beginning date of the current period.  
7. Enter the ending date of the current period. If either of the above are blank, the current period will be the calendar month implied by the billing period number.  
PRIOR PERIOD OVERRIDE:  
8. Enter the beginning date of the prior period.  
9. Enter the ending date of the prior period. If either of the above are blank, the prior period will be based on the month prior to the current period if monthly frequency.  
RECEIVABLES OR PAYABLES:  
10. If this option is left blank, only leases with a blank Lessee Flag will be processed. Otherwise, only leases with a non-blank Lessee Flag will be processed.  

186.25 Rent Change Report - All Increases (P15550)

Processing Option Processing Options Requiring Further Description
DATE SELECTION:  
1. Enter the beginning date of the analysis period.  
2. Enter the ending date of the analysis period. If either date is left blank, these dates will default from the lease.  
3. Enter the number of years to go back from the end date or to go forward from the beginning date, if not working with explicit dates.  
AMOUNT SELECTION:  
4. Enter a '1' to base all figures on monthly amounts. Leave blank to base figures on annual amounts.  
BILL CODE SELECTION:  
5. Enter 'S' to select specific Bill Codes or 'O' to omit them. Leave blank to include all Bill Codes.

List Bill Codes to select/omit: >

  
PRINT OPTIONS:  
6. Enter '1' to omit printing rent increases caused by lease commencements.  
7. Enter '1' to omit printing rent decreases caused by lease expirations.  
8. Enter '1' to print the building address on the report.  
9. Enter '1' to print a blank line before every new lease or unit.  
PRINT OPTIONS (Cont'd):  
10. Enter '1' to print all active, non-escalated rent amounts.  

186.26 Recurring Billing Facsimile - Period 01 (P15100P)

Processing Option Processing Options Requiring Further Description
IMPORTANT: Carefully examine the DREAM- WRITER selections for this version to ensure that only the Billing Period to be processed contains a selection value equal to "X". BILLING DATE SELECTION:  
1. Enter the billing date for selecting Recurring Billing records.  
2. Enter the billing period number.  
3. Enter the fiscal year.  
0.  
G/L DATE SELECTION:  
4. Enter the G/L date to be used for booking Accounts Receivables.  
MESSAGE SUPPRESSION SELECTION:  
5. Enter a '1' to suppress messages and include suspended rent records.

This option is used for non-current periods.

  
PRORATIONS AND CATCH-UP SELECTION:  
6. Choose one of the following:

'1' = Prorate and bill current period

'2' = Prorate and do catch-up billing

'3' = Do catch-up billing with no proration

' ' = Bill the current period with no proration (default)

  
METHOD OF PRORATION SELECTION:  
7. Select the method for calculating the prorations:

'1' = Base proration on a 30 day month (Note: Effective only for calendar year monthly billing frequency)

'2' = Use the "Quarter Day" method

' ' = Use the actual number of days in the billing period (default)

  
OVERRIDE INVOICE DUE DATE:  
8. Enter an override due date for invoices. Leave blank to calculate the due date using the payment terms.  
OVERRIDE CURRENT PERIOD DEFINITION:  
9. Period Begin date:  
10. Period End date:

If either date is blank, the period number (Options 2 & 3) will be used to derive period dates.

  
RECEIVABLES OR PAYABLES:  
11. Enter a '1' to process only leases with a non-blank Lessee Flag. Leave blank to process only leases with a blank Lessee Flag.  
SUPPRESS WARNING MESSAGES:  
12. Enter a '1' to suppress the printing of warning messages (Error messages will still be printed). Leave blank to print both warning and error messages.  

186.27 Recurring Billing Generation - Period 01 (P15100)

Processing Option Processing Options Requiring Further Description
IMPORTANT: Carefully examine the DREAM WRITER selections for this version to ensure that only the Billing Period to be processed contains a selection value equal to "X". RECURRING BILLING DATE SELECTION:  
1. Enter the billing date for selecting Recurring Billing records.  
2. Enter the billing period number.  
3. Enter the fiscal year.  
G/L DATE SELECTION:  
4. Enter the G/L date to be used for booking Accounts Receivables.  
5. Enter the Service/Tax date. If blank (default) the period end date will be used.  
PRINT OPTION:  
6. Enter the version for printing the Billing Edit/Register (P15300).  
PRORATIONS AND CATCH-UP SELECTION:  
7. Select one of the following:

'1' = Prorate and bill current period

'2' = Prorate and do catch-up billing

'3' = Do catch-up billing with no proration

' ' = Bill the current period with no proration (default).

  
METHOD OF PRORATION SELECTION:  
8. Select the method for calculating the prorations:

'1' = Base proration on a 30 day month (Note: Effective only for calendar year monthly billing frequency)

'2' = Use the "Quarter Day" method

' ' = Use the actual number of days in the billing period (default)

  
OVERRIDE DUE DATE:  
9. Enter an override due date for invoices. Leave blank to calculate the due date using the payment terms.  
OVERRIDE CURRENT PERIOD DEFINITION:  
10. Period Begin date:  
11. Period End date:

If either date is blank, the period number (Options 2 & 3) will be used to derive period dates.

  
RECEIVABLES OR PAYABLES:  
12. If this option is left blank, only leases which have a blank Lessee Flag will be processed. Otherwise, only leases with a non-blank Lessee Flag will be processed.  

186.28 Heads Down Sales Report Entry (P1540)

Processing Option Processing Options Requiring Further Description
BATCH CONTROL OPTION:  
1. Enter a '1' to implement Batch Control. Enter a '0' for no Batch Control. Leave blank to default to the A/R Constants setting to determine Batch Control.  
UNEXPECTED SALES REPORT OPTION:  
2. Enter a '1' to allow the entry of unexpected sales reports. Leave blank (default) to prohibit their entry.  
ADJUSTMENT SALES REPORT OPTION:  
3. Enter a '1' to allow the entry of adjustment (duplicate) sales reports.

Leave blank (default) to prohibit their entry.

  
HISTORY ADJUSTMENT OPTION:  
4. Enter a '1' to operate in history adjustment mode. Leave blank (default) to not operate in history adjustment mode.  

186.29 Heads Down Sales Report Entry (P1540)

Processing Option Processing Options Requiring Further Description
BATCH CONTROL OPTION:  
1. Enter a '1' to implement Batch Control. Enter a '0' for no Batch Control. Leave blank to default to the A/R Constants setting to determine Batch Control.  
UNEXPECTED SALES REPORT OPTION:  
2. Enter a '1' to allow the entry of unexpected sales reports. Leave blank (default) to prohibit their entry.  
ADJUSTMENT SALES REPORT OPTION:  
3. Enter a '1' to allow the entry of adjustment (duplicate) sales reports.

Leave blank (default) to prohibit their entry.

  
HISTORY ADJUSTMENT OPTION:  
4. Enter a '1' to operate in history adjustment mode. Leave blank (default) to not operate in history adjustment mode.  

186.30 Heads Down Sales Report Entry (P1540)

Processing Option Processing Options Requiring Further Description
BATCH CONTROL OPTION:  
1. Enter a '1' to implement Batch Control. Enter a '0' for no Batch Control. Leave blank to default to the A/R Constants setting to determine Batch Control.  
UNEXPECTED SALES REPORT OPTION:  
2. Enter a '1' to allow the entry of unexpected sales reports. Leave blank (default) to prohibit their entry.  
ADJUSTMENT SALES REPORT OPTION:  
3. Enter a '1' to allow the entry of adjustment (duplicate) sales reports.

Leave blank (default) to prohibit their entry.

  
HISTORY ADJUSTMENT OPTION:  
4. Enter a '1' to operate in history adjustment mode. Leave blank (default) to not operate in history adjustment mode.  

186.31 Sales Overage Billing - December (P15120)

Processing Option Processing Options Requiring Further Description
IMPORTANT: Carefully examine the DREAM WRITER selections for this version to ensure that only the Billing Period to be processed contains the correct selection value. SALES DATE SELECTION:  
1. Process tenant sales through month: in year:  
DATE SELECTIONS:  
2. Enter the G/L date to be used for booking Accounts/Receivable.  
3. Enter the Invoice date.

DATE SELECTIONS (Cont'd)

  
4. Enter the Service date. Leave blank (default) to use the first date of last period of sales reviewed.  
DW VERSION SELECTION:  
5. Enter the DREAM Writer version of the Billing Edit/Register (P15300) to print. Leave blank (default) to print version 'XJDE0001'.  
PRINT OPTION:  
6. Enter "1" to print a summarized billing report; enter "2" for a detailed report. Leave blank for no report.  
MIN/MAX RENT & RECOVERY A/R OPTIONS:  
7. Choose an amount to retrieve from Accounts Receivable when processing Min/Max Rents & Recoveries:

Blank = Billed Amounts (default).

"1" = Billed LESS Adjustments.

"2" = Payment Amounts.

  
8. Choose a date for selecting Accounts Receivable information when processing Min/Max Rents & Recoveries:

Blank = Invoice Date (default).

"1" = Due Date

"2" = Service/Tax Date

"3" = G/L Date

  
RECEIVABLES OR PAYABLES:  
9. Leave blank (default) to process only those leases with a blank Lessee Flag. Enter '1' to process only leases with a non-blank Lessee Flag.  

186.32 Gen Sales Analysis - All Summary Codes (P15143)

Processing Option Processing Options Requiring Further Description
DATE SELECTION:  
1. Enter the Generation Date Month (i.e.

May entered as '05').

  
2. Enter the Generation Date Century and Year (i.e. '1992').  
SUMMARY CODE SELECTION:  
3. Enter a '1' to change selected summary codes from batch generation to dynamic update through the post program.  
PRINT SELECTION:  
4. Enter a '1' to print report showing sales analysis generated. No report will print if left blank (default).  
PURGE CRITERIA SELECTION:  
5. Enter the following purge criteria: a. Number of months to keep, AND/OR b. Purge through period i) Month (i.e. May entered '05') ii) Year (i.e. '1992') (Both blank = no purge; both entered = cutoff date is earlier of the two)  
PERFORMANCE OPPORTUNITY:  
6. Enter a '1' if you only keep current month analysis data and are selecting all summary codes. (A total purge will be performed prior to the regeneration which is significantly faster then a selective purge.)  

186.33 Month Change - By Building/Tenant (P15243)

Processing Option Processing Options Requiring Further Description
DEFAULT OPTIONS:  
1. Enter the Sales Analysis Summary Code to default.  
2. Enter "Skip To" values to default:

(These should correspond to the Summary Code entered above.)

Key Field 01 >

Key Field 02 >

Key Field 03 >

Key Field 04 >

  
3. Enter the Compare Period to default.  
0.  
0.  
DEFAULT OPTIONS (Cont'd):  
4. Enter the Amount Selection to default.  
5. Enter the Description Level to default.  
6. Enter the Graph Scale to default.  
0.  
GRAPH CONTROL:  
7. Specify the graph scale range: a. High end of graph scale: b. Low end of graph scale:  
GRAPH CONTROL (Cont'd):  
8. Enter a 1 character symbol to use for graphing sales. Leave blank (default) to display the sales as a solid, highlighted "bar".  

186.34 E. P. Class Listing - Specific Accounts (P1530P)

Processing Option Processing Options Requiring Further Description
TRANSACTION TOTAL SELECTION:  
1. Enter a '1' to print transaction totals for each account listed.

Leave blank (default) to list the accounts included in each class without corresponding total amounts.

  
'GLOBAL' BUSINESS UNIT SUBSTITUTION:  
2. Enter the business unit to substitute for 'global' business units when deriving accounts.

NOTE: The following processing options apply only if you entered a '1' in processing option 1.

 xxxxxxxxxxxx = Enter the Business Unit to use to derive expense accounts. The E.P. Class must have a 'field wildcard' entered in the Business Unit field for this program to recognize this Business Unit substitution.

Note: A field wildcard entered in the Business Unit field during the set up of the E.P. Classes (P1530) causes the Expense Participation Generation program (P15110) to substitute a tenant's Building as the Business Unit for deriving expense accounts.
G/L FILE SELECTION:  
3. Enter '1' (default) to extract amounts from the account balances file (F0902). Enter '2' to extract them from the detailed transactions file (F0911).  
OVERRIDE LEDGER TYPE OPTION:  
4. Enter an override ledger type for extracting account transactions. You can enter an override ledger type for extracting the expense account transactions. This option is helpful if you have posted transactions to a ledger type other than Actual (AA).

For example, if you need to reference next year's budgeted expenses, you can identify that ledger type here.
OFFSET LEDGER TYPE SELECTION:  
5. Enter a ledger type for extracting offset amounts. Leave blank (default) to extract no offsets. You may enter an 'offset' ledger type for extracting the expense account transactions. This option is helpful if you have posted adjusting transactions to a ledger type other than Actual (AA).
DATE SELECTION:  
6. Enter the date to begin accumulating transaction amounts. Leave blank (default) to use the system date.  
7. Enter the date to stop accumulating transaction amounts. Leave blank (default) to use the system date.  
CLASS ADJUSTMENT TOTAL OPTION:  
8. Enter a '1' to include Class Adjustment totals for each class. 1 = If you enter a '1' for this option, the Class Adjustment totals are printed for each Class.

These adjustments can be the result of identifying an Adjustment Factor for a Class or setting up a specific adjustment amount to apply to an expense.

186.35 Generate E.P. Calculations - Period 01 (P151101)

Processing Option Processing Options Requiring Further Description
IMPORTANT: Carefully examine the DREAM WRITER selections for this version to ensure that only the Billing Period to be processed contains a selection value equal to "X". BILLING DATE SELECTION:  
1. Enter the billing period number. XX = This is the period number that the invoices will be generated for.
2. Enter the fiscal year. XX = This is the fiscal year that the invoices will generated for.

Example: If you are generating E.P. for a lease on a regular calendar year (January through December) and you want to generate for June, 2017, you would enter '06' as the period number and '17' as the fiscal year.

If you are generating E.P. for a lease on an irregular fiscal pattern, July through June for example, and you want to generate for June, 2017, you would enter '12 as the period number and '16' as the fiscal year. (Fiscal Year 2016 encompasses July 1, 2016 through June 30, 2017 in this example. The first period's ending date determines the fiscal year).

Caution: Do not process leases with different fiscal patterns within one generation. Setup different DREAM Writer versions per company (or business unit or lease) for each different fiscal pattern.
GENERATION TYPE SELECTION:  
3. Enter a generation type for the calculation records:

'2' = E.P. Billings (default).

'6' = Estimated E.P. Billings.

 2 = A value of 2 will create a batch of billing records with a generation type of 2. The system then recognizes these billings being generated as E.P. Billing records.

6 = A value of 6 creates a batch of billing records with a generation type of 6. The system then recognizes these billings being generated as Estimated E.P./Recurring Billing records.
REPORT PRINTING SELECTION:  
4. Enter the version for printing the E.P. Extraction Register (P1532). You can use this option to control whether you want to print the E.P. Extraction Register.

If you leave this option blank, no report prints.
5. Enter the version for printing the E.P. Billing Register (P1538). You can use this option to control whether you want to print the E.P. Billing Register.

If you leave this option blank, no report prints.
6. Enter the version for printing the Class Adjustment List (P1535). You can use this option to control whether you want to print the Class Adjustments List.

If you leave this option blank, no report prints.
OVERRIDE LEDGER TYPE:  
7. Enter an override ledger type for extracting account transactions. This Ledger Type identifies the account transactions used to accumulate expenses. Depending on the value of the Cash/Accrual Flag in E.P. Class Information (P1530), the default Ledger Types are:

Cash/Accrual Flag Default Ledger Type

blank AA

C AZ

This option allows you to specify a different Ledger Type to extract budgeted expenses for Estimated E.P.
G/L FILE SELECTION:  
8. Enter a '1' (default) to extract transactions from the account balances file (F0902). Enter a '2' to extract them from the detailed transactions file (F09011). 1 = This value instructs the program to use the Account Balances File (F0911) to extract expense amounts.

2 = This value instructs the program to use the detailed Account Ledger File (F0911) to extract expense amounts.
ADJUSTMENT LEDGER TYPE:  
9. Enter the ledger type to use for extracting expense adjustments.

Leave blank (default) to extract no adjustment transactions.

 This Ledger Type identifies the adjustments to the expense accounts that qualify to be processed by this program.
BILLING RECONCILIATION SELECTION:  
10. Choose an amount to reconcile with current billings:

' ' = Estimated billings (default).

'1' = Estimated billings LESS adjustments.

'2' = Payments to est. billings.

 Blank = The amount retrieved is the total of all amounts billed.

1 = The amount retrieved is the total of all billed amounts less any adjustments. This is calculated as the total of all gross amounts, as adjustments which reduce the amount of the invoice are already recorded as negative amounts.

2 = The amount retrieved is the amount of recorded payments. Payments are the difference between the net billings (billings - adjustments) and the amount still open. Also included as payments are open amounts from unapplied cash invoices.
A/R, A/P RETRIEVAL DATE SELECTION:  
11. Choose a date for retrieving Receivable or Payable information:

' ' = Invoice Date (default).

'1' = Due Date.

'2' = Service/Tax Date.

'3' = G/L Date.

 You can use this option to specify a date other than the Invoice Date for retrieving Accounts Receivable Information.
LOG CLASS/AMENITY ID SELECTION:  
12. To limit retrieval of building or property square footage to a single Log Class, enter the Log Class here. This option is helpful to select the proper square footage amount if you have multiple Building/Property Log Lines set up in the Log Standards File (F1503) with the same Expense Participation Code (EPCD). This square footage amount is used in the Share Factor calculation when using the Building or Property as the denominator.
13. To limit retrieval of building or property square footage to a single combination of Log Class and Amenity ID, enter the Amenity ID here. This option is helpful to select the proper square footage amount if you have multiple Building/Property Log Lines set up in the Log Standards File (F1503) with the same Expense Participation Code (EPCD) and the same Log Class. This square footage amount is used in the Share Factor calculation when using the Building or Property as the denominator.
PRORATION OPTION:  
14. Enter a '1' to prorate the base exclusion amount using the occupancy factor. This option instructs the program to prorate the Base Exclusion Amount using the Occupancy Factor.
RECEIVABLES OR PAYABLES:  
15. If this option is left blank, only leases which have a blank Lessee Flag will be processed. Otherwise, only leases with a non-blank Lessee Flag will be processed.  

186.36 Generate E.P. Billings (P151102)

Processing Option Processing Options Requiring Further Description
BATCH SELECTION:  
1. Enter the batch number of billings to be generated. Enter the batch number you want to process.
G/L DATE SELECTION:  
2. Enter the G/L date to be used for booking Receivables or Payables. XX/XX/XX = This is the date used when posting the transactions to the Accounts Receivable File (F0311) and the General Ledger Files (F0911 and F0902).
DW VERSION SELECTION:  
3. Enter the version for printing the Receivables or Payables Edit/Register (P15300). You can use this option to control whether you want to print the Billing Edit/Register.

If you leave this option blank, no report prints.
RECURRING BILLING OPTION:  
4. To create recurring billings based on EP amounts, enter the DREAM Writer version of the Estimated EP Recurring Billings Edit report (P15113) to run.

NOTE: The version will run in edit mode only.

 You can use this option to control whether you want to print the Estimated E.P./Recurring Billing Edit/Update Report. If you leave this option blank, no edit report prints.
5. To apply an inflation factor to the recurring billing amounts, enter a decimal fraction inflation rate (for example, enter 10% as '.10'). This percent is applied to the recurring billing records. This Processing Option is recognized by the E.P. Generation process if a version number was entered for the Estimated E.P. Recurring Billing Edit/Update Report (P15113).

186.37 Generate Estimated E.P. (P151112)

Processing Option Processing Options Requiring Further Description
BATCH SELECTION:  
1. Enter the batch number to process.  
0.  
RECURRING BILLING OPTIONS:  
2. To create recurring billings based on the E.P. amounts, enter the DREAM Writer version of the Estimated E.P.

Recurring Billing Edit report (P15113) to run. NOTE: The version will run in edit mode only.

  
RECURRING BILLING OPTIONS (Cont'd):  
3. To apply an inflation factor to recurring billing amounts, enter a decimal fraction inflation rate (for example, enter 10% as '.10').  

186.38 Est. EP Recurring Billing Edit (P15113)

Processing Option Processing Options Requiring Further Description
BATCH SELECTION:  
1. Enter the batch number to process: Enter the batch number, assigned when you run Estimated E.P. Generation (P15111), which you want to process.
PRINT OPTION:  
2. Enter '1' to suppress the printing of tax fields. Leave blank to default to the REM Constants setting to control the printing of tax fields. ' ' = The program checks P.M. Constants (P1510) to determine whether taxes must or must not be processed.

'1' = Tax information is suppressed, regardless of the tax flag setting in P.M. Constants (P1510).
BILLING FREQUENCY CODE SELECTION:  
3. Enter the default Billing Frequency code to use on the Recurring Billing Records. This value determines the billing frequency of the Recurring Billing records created by this program.

Note: If an existing Recurring Billing record is being suspended and a new one is being created, the existing Recurring Billing's billing frequency is used on the newly created Recurring Billing record.
UPDATE OPTION:  
4. Enter a '1' to write records to the Recurring Billing file. ' ' = If the program is run in 'edit' mode, the Estimated E.P./R.B. Edit/Update report prints, but the Recurring Billing records is not generated.

'1' = The program prints the Estimated E.P./R.B. Edit/Update report and Recurring Billing records is updated.
BEGINNING EFFECTIVE DATE SELECTION:  
5. Enter a '1' (default) to use the start date of the expense span as the beginning effective date of the Recurring Billing records.

Enter a '2' to use the month immediately following the end date of the expense span.

 '1' = The start date of the expense span is used as the beginning effective date of the Recurring Billing records. The expense span, also known as the Control Span, is defined as the time period where the Billing Period and the Occupancy Period overlap. Note: If you leave this option blank, the system defaults to '1'.

'2' = The month after the end of the Billing Period is used as the beginning effective date for the Recurring Billing records.
NUMBER OF MONTHS TO PROCESS:  
6. Enter the number of months to be added to the beginning effective date to define the billing term. The program adds the number of months you specify here to the beginning effective date to define the billing term of the Recurring Billing records.
BEGINNING DATE OVERRIDE SELECTION:  
7. Enter a date to use as the beginning effective date, overriding the previous beginning effective date selection. XX/XX/XX = If you enter a date here, the program ignores any previous Processing Option entries specifying a beginning effective date and uses this date as the beginning effective date of the Recurring Billing records.
CATCH-UP BILLINGS CALCULATION:  
8. Choose a method to calculate catch-up billings:

Blank = Estimated Billings (default).

'1' = Estimated Billings LESS adjustments.

'2' = Payments to Est. Billings.

 1 = The amount retrieved is the total of all billed amounts less any adjustments. This is calculated as the total of all gross amounts, as adjustments which reduce the amount of the invoice are already recorded as negative amounts.

2 = The amount retrieved is the amount of recorded payments. Payments are the difference between the net billings (billings - adjustments) and the amount still open. Also included as payments are open amounts from unapplied cash receipts.
A/R, A/P INFORMATION RETRIEVAL:  
9. Choose a date to retrieve Accounts Receivable or Payables information:

Blank = Invoice Date (Default).

'1' = Due Date.

'2' = Service/Tax Date.

'3' = G/L Date.

 You can use this option to specify a date other than the Invoice Date for retrieving Accounts Receivable Information.
ANNUAL CHANGE THRESHOLDS:  
10. Enter Threshold for Change Amount: Processing Options 10 - 12 allow you to control insignificant billing amounts from updating Recurring Billings by specifying a minimum change amount or change percent which must be exceeded prior to any update occurring.
11. Enter Threshold for Change Percent:

(10% entered as '0.10')

 Processing Options 10 - 12 allow you to control insignificant billing amounts from updating Recurring Billings by specifying a minimum change amount or change percent which must be exceeded prior to any update occurring.
12. Choose one of the following to determine if calculated threshold change should be used to update recurring billings:

Blank = Change must exceed the amount AND the percent threshold (default).

'1' = Change must exceed the amount OR the percent threshold

 Processing Options 10 - 12 allow you to control insignificant billing amounts from updating Recurring Billings by specifying a minimum change amount or change percent which must be exceeded prior to any update occurring.
SUPRRESS CATCH-UP BILLING CREATION:  
13. Enter a '1' to suppress the creation of catch-up billing records. This option allows you to control whether catch-up billing records are created within this billing generation.
SQUARE FOOTAGE OVERRIDE:  
14. Enter a '1' to copy the square footage amount from the work file into Recurring Billings. This option allows you to control whether the square footage amounts used during the billing generation are copied into the newly created Recurring Billing record.
DESCRIPTION FIELD OVERRIDE:  
15. Enter a '1' to use the description from the Bill Code Exstension file as the remark for the entries in the Recurring Billing file.  

186.39 Recurring Billing Per Square Foot Gen. (P15114)

Processing Option Processing Options Requiring Further Description
DATE SELECTIONS:  
1. Enter the generation date.  
2. Enter the month in which the Recurring Billings should begin.  
3. Enter the year in which the Recurring Billings should begin.  
LOG CLASS SELECTION:  
4. Enter the log class to be used to retrieve "per square foot" amounts.  
UPDATE OPTION:  
5. Enter a '1' to update the Recurring Billing work file (F1502W).  

186.40 Tenant Escalation Master (P15016)

Processing Option Processing Options Requiring Further Description
DISPLAY OPTION:  
1. Enter '0' to display the tax fields.

Enter '1' to suppress the tax fields.

Leave blank to default to the REM Constants to control tax processing.

  
EDIT OPTIONS:  
2. Enter '1' to allow update of the Last Period, Last Index and Last Basis fields. Leave blank to protect them.  
3. Enter '1' to perform date edits against the Lease Master. Leave blank to bypass the edits.  

186.41 Escalations Data Base Update - Post (P15152)

Processing Option Processing Options Requiring Further Description
BATCH SELECTION:  
1. Enter the batch number of the escalation billings to be processed.  
COMBINE BASE RENT/ESCALATION OPTION:  
2. Enter '1' to combine the escalation amount and the base rent amount into one new recurring billing line and to suspend the old base rent line.

Any other value will result in the new recurring billing record representing only the new escalation amount and the old base rent will not be suspended.

  
BASE RENT BILL CODE SELECTION:  
3. Enter the existing escalation bill code to be combined with the calculated escalation amount or leave blank to combine the calculated escalation with the rent bill code.  
UPDATE OPTION:  
4. Enter a '1' to write records to the Recurring Billing file (F1502).  

186.42 Generate Sec Dep Refund - DW Sel -Update (P15655)

Processing Option Processing Options Requiring Further Description
UPDATE OPTION:  
1. Enter '1' to create/update batches.

Leave blank (default) to print an edit report with no update.

  
G/L DATE SELECTION:  
2. Enter the G/L date.  
0.  
AS-OF-DATE SELECTION:  
3. Enter the as-of-date to use in conjunction with option 4 and/or option 5. Leave blank (default) to use the system date.  
LEASE ENDING DATE SELECTION:  
4. Lease Ending Date MUST fall within: a) From Date ----> or days prior to as-of-date ----> b) To Date ----> or days after as-of-date ----> c) If above entries are blank, a '1' must be entered here to process records selected by DREAM Writer.  
ACTUAL OUT DATE SELECTION:  
5. Actual Out Date MUST fall within: a) From Date ----> or days prior to As-of-Date ----> b) To Date ----> or days after As-of-Date ----> c) If above entries are blank, a '1' must be entered here to process records selected by DREAM Writer.  
ADJUSTMENT REASON:  
6. Enter the Adjustment Reason.  
0.  
G/L OFFSET:  
7. Enter the G/L Offset for AP.  
REFUND OPTIONS:  
8. Enter '1' to generate refunds only if the tenant has paid off all debts.

Leave blank (default) to disregard any unpaid debts.

  
9. Specify how refund amounts should be determined:

Blank = Full refund (default).

'1' = Deposit less all unpaid debts.

  

186.43 Lease Comm. Generation - Lease Based (P15105)

Processing Option Processing Options Requiring Further Description
FISCAL PERIOD/YEAR SELECTION:  
1. Enter the fiscal period to process: XX = This is the period number for which to generate revenue fees.
2. Enter the fiscal year to process: XX = This is the fiscal year for which to generate the revenue fees. You can enter a two digit year, for example, '17', or you can enter the full four digit year, for example, '2017'.
3. Enter the number of periods to process retroactively in addition to the current period. This option provides you with the flexibility to process fee adjustments for prior periods. You select the number of periods you wish to retroactively process.
DATE SELECTIONS:  
4. Enter the G/L date. XX/XX/XX = This is the date used when posting the transactions to the General Ledger files.
5. Enter the Invoice date if applicable. XX/XX/XX = This is the date used when creating invoice records.
6. Enter the Voucher date if applicable. XX/XX/XX = This is the date used when creating voucher records.
FEE TYPE SELECTION:  
7. Select the fee type to process:

'1' = Lease based fees.

Blank = Business unit based fees.

 You can only process fee types in one run which are the same. Select either Lease based fees or Business Unit based fees.
8. If processing business unit fees, select one of the following to process:

'1' = G/L based fee types.

Blank = A/R based fee types.

 This option determines how to retrieve revenues if cost center based fees were selected in the previous Processing Option.
OVERRIDE OPTION:  
9. Enter '1' to process leases regardless of their Management Fee field settings in the Lease Master. This option allows you to include all leases in the revenue fee calculation, regardless of the Management Fee field in the Lease Master.
PRINT OPTION:  
10. Enter '1' to omit printing detail on the report. Leave blank (default) to print the detail. You can use this option to suppress the revenue retrieval audit trail from printing on the report.
ADJUSTMENT PROCESSING:  
11. Enter '1' to ignore adjustments when retrieving revenues from A/R.

Leave blank to apply adjustments to retrieved billings.

 You can choose which A/R amounts to use to retrieve revenues from. This option is valid only if retrieving revenues from A/R.
12. Enter '1' to ignore "spread" transactions when retrieving revenue from A/R. Leave blank to include spreads as payments. You can use this option to exclude "spread" transactions from the amount of payments retrieved from Accounts Receivable. This option is useful if you bill unapplied cash amounts as payments and do not wish to rebill the payment when it is spread to an invoice.
UPDATE OPTION:  
13. Enter '1' to generate revenue fee batches (G/L, A/R, A/P). Leave blank (default) to print an edit report without updating any files. This option allows you to generate revenue fee batches or print the generation report only. If you elect to print the report only, you can re-run the generation and create the appropriate batches.

186.44 Revenue Fee Batch Deletion - Edit (P15807)

Processing Option Processing Options Requiring Further Description
NOTE: Once deleted, a batch cannot be recovered; please exercise this option with care. BATCH SELECTION:  
1. Enter the batch number to process.  
2. Enter '1' to delete the batch.  
PRINT OPTION:  
3. Enter '1' to print an audit report.  

186.45 Late Fee Generation with Batch Creation (P15160)

Processing Option Processing Options Requiring Further Description
FEE TYPE SELECTION:  
1. Enter the Fee Type for generation.  
DATE SELECTIONS:  
2. Enter the generation date.  
3. Enter the G/L date for creating invoices.  
4. Enter the invoice date.  
FILE UPDATE OPTION:  
5. Enter a '1' to create invoice and/or check records. Any other value will cause the report to be printed with no update to any files.  
VARIABLE FEE/INTEREST RATE SELECTION:  
6. Enter any variable fee or interest rates (5.25% entered as '.0525').

All variable rates are annual. a. Variable Rate 1 b. Variable Rate 2 c. Variable Rate 3 d. Variable Rate 4

  
'SUBJECT TO LATE FEES' BYPASS OPTION:  
7. Enter a '1' to bypass checking the 'Subject to Late Fees' value associated with the Bill Code on an invoice.  

186.46 FASB 13 R. B. Generation - Edit (P15132)

Processing Option Processing Options Requiring Further Description
UPDATE OPTION:  
1. Enter "1" to update the Recurring Billing file and FASB 13 file.

Leave blank to print edit report without updating.

  
2. Enter the Bill Frequency Code to assign to system-generated recurring billing entries.  
BATCH SELECTION:  
3. Enter the batch number to post from the FASB 13 generation program.

Leave blank to post all FASB data selected from DREAM Writer data selection.

  
BILL CODE SELECTION:  
4. Enter the bill codes for the entries generated in the Recurring Billing file:

a. Accrued Entry: b. Deferred Entry: c. Adjusted Entry: d. Catch Up Adjustment:

  
PROCESSING OVERRIDE:  
5. Enter a "1" to process all FASB records selected for R.B. generation.

Leave blank to process only records that have not been included in a Recurring Billing generation.

  
GENERATION DATE RANGE:  
6. Enter the "From Date" from which the FASB 13 effect is calculated and the Recurring Billing entry is generated.  
7. Enter the "Through Date" on which the FASB 13 effect calculation and the Recurring Billing generation are through. If the date range is NOT entered, the FASB 13 Lease Control generation date and the lease term ending date are used as the from and through date range.  

186.47 Property Management Batch Delete (P15806)

Processing Option Processing Options Requiring Further Description
Caution: This program will delete the Real Estate Management batch specified below. The batch may not be recovered, so exercise this option with care. DO NOT use this program to delete Cash Receipts or Security Deposit Refund batches. BATCH SELECTION:  
1. Enter the batch number to delete.  
0. (More...)  
UPDATE/EDIT OPTION:  
2. Enter a '1' to delete the records.

Leave blank to run in edit mode only.

  
PRINT OPTION:  
3. Enter a '1' to print an audit trail report.  
SPECIAL PROCESSING SELECTION:  
4. Enter a '1' to delete Tenant Invoice records (F1511) which have a posted code value of "D" but which would not normally create corresponding A/R (F0311) or G/L (F0911) records.

Examples of such records are a zero amount invoice pay item or a Sales Overage "carry forward pending" or "carry forward taken" record.

  
A/R OR A/P SELECTION:  
5. Enter a '1' to delete information from the Accounts Payable file.

Leave blank (default) to delete it from the Accounts Receivable file.

  

186.48 Rec. Billing Global Select - All Bldgs (P15021)

Processing Option Processing Options Requiring Further Description
DATE SELECTION:  
1. Enter the new billing effective dates below. a. Begin Date:

If left blank, the new billing will begin the day after the original billing is scheduled to end. b. End Date:

If left blank, the new billing will end on the lease expiration date.

  
RECORD SELECTION:  
2. To select leases with specific start date anniversaries, enter a From and/or Through date below.

a. From Anniversary Date: b. Through Anniversary Date:

NOTE: If only one date is entered, it will be used for both dates.

If both dates are blank, ALL records will be eligible for selection. (See the Help Text for a detailed explanation of Lease Anniversaries.)

  
RECORD SELECTION (Cont'd):  
3. To limit selection based on fields in associated Unit Master records,

enter values below:

(Use cursor sensitive help) a. Floor Number: b. Unit Type: c. Unit Useage: d. Report Code 01: e. Report Code 02:

  
4. Enter a '1' to include the billing records of non-billable leases (pre- lease and speculative lease types).  
DW SELECTION:  
5. Enter the DREAM Writer version of the R.B. Global Update program (P15116) to print (the version will only run in EDIT MODE). Leave blank (default) to run version 'XJDE0001'.  
PRINT OPTION:  
6. Enter a '1' to print a report showing the billing records selected by DREAM Writer but bypassed by the program.  

186.49 Recurring Billing Global Edit/Update (P15116)

Processing Option Processing Options Requiring Further Description
UPDATE OPTION:  
1. Select one of the following:

'1' = Update R.B. records.

'2' = Reset R.B. records.

Blank = Print edit report; no update.

NOTE: If running this version as part of the R.B. Record selection process, no update will occur.

  
BATCH SELECTION (Required):  
2. Enter the batch number to process.  
CALCULATION SELECTION:  
3. Choose the method of increase:

'1' = Percent increase

'2' = Amount increase

'3' = Annual Amount Per Square Foot increase

'4' = New Amount

'5' = New Annual Amount Per Square Foot

NOTE: If updating by an amount ('2' or '4' above), it is recommended that DREAM Writer versions be setup by billing frequency. See the Help Instructions for more information.

  
CALCULATION SELECTION (Cont'd):  
4. Enter the amount or percent to use in the calculations. The increase method in option 3. determines whether the number entered here is an amount or a percent. (If entering a percent,

enter 5.25% as '5.25', for example.)

  
5. Enter '*RENTABLE' (default) to base the calculations on rentable square footage. Enter '*USEABLE' to base them on useable square footage.  
ROUNDING CONTROL:  
6. Choose the method of rounding:

'U' = Round up to the nearest increment.

'D' = Round down to the nearest increment.

'H' = Round to the nearest increment (up or down).

  
7. Enter the rounding increment. The result of rounding will be exactly divisible by this number. (For example, '1.00' would round to the nearest 1.00; '.50' would round to the nearest .50 and so forth.  
THRESHOLD SELECTIONS:  
8. Enter the threshold for change percent.  
9. Enter the threshold for change amount.

NOTE: Calculations resulting in changes less than the above percent and/or amount will not be used to update Recurring Billings.

  

186.50 Projected Rent Generation - Report Only (P15660)

Processing Option Processing Options Requiring Further Description
DATE SELECTION:  
1. Enter the Rent Projection begin date:  
2. Enter the Rent Projection end date:  
INFLATION RATE SELECTION:  
3. Enter an annual inflation rate if you want the program to assume that leases will renew at this rate indefinitely (5% entered as '.05').

Leave blank (default) to project rent only during the actual term of the lease.

  
VACANT UNIT PROJECTION OPTION:  
4. Enter a Bill Code to project market rent amounts for vacant units using the "PMxxxx" or "RMxxxx" AAI account associated with this Bill Code. Leave blank to bypass vacant units.  
5. If you entered a Bill Code above,

enter a billing frequency code here.

If you entered a Bill Code above and leave this Option blank (default), a monthly billing frequency will be used to project market rent amounts for vacant units.

  
LEDGER TYPE SELECTION:  
6. Enter Ledger Type codes for:

a. Actual Lease Amounts b. Speculative Lease Amounts c. Unit Square Footage Amounts Caution: All account balances in the above Ledger Types will be cleared and replaced by this program.

  
7. Enter a '1' to enter Actual and Speculative Lease amounts as credit entries. Leave blank (default) to

enter them as debit entries.

  
ACCOUNT BALANCE UPDATE:  
8. Enter a '1' to update account balances with projected rent amounts.

Leave blank to print a report without updating any account balances.

  
SQUARE FOOTAGE SELECTION:  
9. Enter a '1' to use the useable square footage defined in the Lease Master file (F1501). Leave blank (default) to use the rentable square footage.  
SQUARE FOOTAGE SELECTION (Cont'd):  
10. Select one of the following methods to use when retrieving square feet from the Unit Master file (P1507):

*RENTABLE = use the Log Class and Amenity ID defined in the REM Constants file for rentable square feet.

*USEABLE = use the Log Class and Amenity ID defined in the REM Constants file for useable square feet.

Log Class = use the Log Class entered here, along with the Amenity ID entered below.

  
SQUARE FOOTAGE SELECTION (Cont'd):  
11. If you entered a Log Class above,

enter the Amenity ID here.

  
12. Enter a Bill Code for recording unit square footage.  
13. Enter a '1' to use the business unit from the rent account when deriving the square footage account.  
PRINT OPTIONS:  
14. Enter '1' to print the last square footage amount on the unit total line. Leave blank (default) to print the unit's average square footage over the generation period.  
15. Enter '1' to print the Tenant name as the description. Leave blank (default) to print the Lease description.  
16. Enter '1' to print year totals with- in Unit, Building, and grand totals.  
BILL CODE SELECTION/OMISSION:  
17. Enter an 'S' to select or an 'O' to omit specific Bill Codes from the Recurring Billing record lines.

Leave blank (default) to include all Bill Codes.

List Bill Codes to select/omit: >

>

>

>

>

>

>

>

  
PRORATION OPTION:  
18. Enter '1' to prorate amounts from partial month Recurring Billings.

NOTE: Proration is only functional for monthly billing frequencies.

  
NON-BILLABLE LEASE OPTION:  
19. Enter a '1' to include non-billable lease statuses in the projected rent calculation.  

186.51 Reapply Projection Adjustments (P15665)

Processing Option Processing Options Requiring Further Description
UPDATE OPTION:  
1. Enter a '1' to update the Account balances file (F0902). Leave blank (default) to print an edit report without updating any files.  

186.52 Sales Analysis Purge (P1543)

Processing Option Processing Options Requiring Further Description
PURGE CRITERIA SELECTION:  
1. Enter number of months to keep:

AND/OR

  
2. Enter the purge through period. a. Month (calendar): b. Year:

(For example, May, 1998 would be

entered as '05' and '1998')

  
PRINT OPTION:  
3. Enter '1' to print a report of the records purged. Leave blank to purge the records but print no report.  

186.53 Purge Sales Reports (P1541)

Processing Option Processing Options Requiring Further Description
NUMBER OF MONTHS TO RETAIN:  
1. Enter the number of months of sales reports to keep. (Only reports which have posting status codes of "P", "X" or "A" and which are older than the number of months specified here will be eligible for deletion.)  
EDIT/UPDATE OPTION:  
2. Enter '1' to purge sales reports and print a report. Enter '2' to purge sales reports and print no report.

Leave blank (default) to print a report and purge NO sales reports.

  

186.54 Tenant/Lease Billing Detail Purge (P15119)

Processing Option Processing Options Requiring Further Description
UPDATE OPTION:  
1. Enter '1' to purge the Tenant/Lease Billing information. Leave blank to print an edit report only.  
DATE SELECTION:

Enter ONE of the following dates to select as the purge cut-off date.

Records with dates prior to the ONE date entered will be purged.

  
2. G/L Date  
3. Invoice Date  
4. Due Date  
5. Service/Tax Date  

186.55 Lease Purge/Report (P15118)

Processing Option Processing Options Requiring Further Description
UPDATE OPTION:  
1. Enter a '1' to purge the leases and related information. Leave blank to print an edit report only.  
PRINT OPTION:  
2. Enter a '1' to start a new page when a new lease is encountered.  
CRITICAL DATE SELECTION:

Enter at least one of the following dates as the purge cut-off date.

Records will be purged if they are prior to the date(s) entered.

  
3. Ending Effective Date:  
4. Move Out Date:  
5. Last Billing Date:  
6. Date Last Updated:  
0.  
0.  
0.  
0.  
0.  
0.  
BUILDING/UNIT MATCHING:

To delete only records with a specific building and/or unit, enter the following. If entering a unit, a building must also be entered.

  
7. Building Number:  
8. Unit Number:  
0.  
UNIT STATUS CONTROL:  
9. Enter a '1'to protect the Unit Status records from being purged during the next Unit Status Generation.  
PURGED FILE SELECTION:

Enter a '1' next to the file(s) from which you want to purge data:

  
10. F1501 - Lease Master  
11. F15012 - Expense Participation  
12. F15013 - Sales Overage Master  
13. F15014 - Product Scales Master  
14. F15015 - Minimum Rent/Recoveries  
15. F15016 - Escalation Master  
16. F15018 - DBA Master  
17. F1502 - Recurring Billing Master  
18. F1503 - Lease Log Master (List cont'd on next screen)  
PURGED FILE SELECTION (CONT'D):  
19. F1504 - Lease Log Extension Master  
20. F1505 - Management Fee Master  
21. F1511 - Tenant/Lease Billing Detail  
22. F1511H- Invoice History  
23. F1520 - Lease Financial Summary  
24. F1533 - E.P. Account Exclusions  
25. F1538 - Calculation History  
26. F1548 - Escl. Calculation History  
27. F15011- Billing Control  

186.56 Building Information Deletion (P15808)

Processing Option Processing Options Requiring Further Description
IMPORTANT: This program deletes the building specified below and all related REM information. Deleted records CANNOT be retrieved; exercise caution when running this program. BUILDING SELECTION:  
1. Enter the building number to delete:  
UPDATE OPTION:  
2. Enter a '1' to print an edit report with no deletion of records. Leave blank to delete the records.  

186.57 Collection Log File Purge (P15263)

Processing Option Processing Options Requiring Further Description
PURGE CRITERIA SELECTION:  
1. Enter the date to select as the purge cut-off date. Records with dates prior to the date entered will be purged.  
PRINT OPTION:  
2. Enter '1' to update the files. Leave blank to print an edit report only.  

186.58 Property/Building Revisions (P00062)

Processing Option Processing Options Requiring Further Description
REQUIRED STANDARDS OPTION:  
1. Enter a '1' to protect the Required Standards field.  
2. Enter a '1' to bypass automatically copying in Standards. Leave blank to automatically copy in Standards from the Log Standards Information program.  
DW VERSION FOR FLOOR MASTER REVISIONS:  
3. Enter the DREAM Writer version number of the Floor Information program (P1506) to call when the function is selected. Leave blank to default to version 'ZJDE0001'.  
SQUARE FOOTAGE EDIT:  
4. Enter a '1' to perform the square footage edit between the building and the floor(s) set up for the building. A blank (default) will bypass the edit.  
DEFAULT FORMAT:  
5. Enter a value for the default video format:

' ' = longer Remark, appears in fold

'1' = shorter Remark, not in fold

Note: Format 1 is similar to the A7.3 format, but with century added to date fields.

  

186.59 Floor Information Revisions (P1506)

Processing Option Processing Options Requiring Further Description
REQUIRED STANDARDS OPTION:  
1. Enter a '1' to protect the Required Standards field.  
2. Enter a '1' to bypass automatically copying in Standards. Leave blank to automatically copy in Standards.  
FLOOR NUMBER EDIT:  
3. Enter a '1' to edit the floor number against User Defined Codes.  
DEFAULT GROUPING CODE:  
4. To limit entry to only one Grouping Code, enter that Grouping Code here.  
DW VERSION FOR BUILDING INFORMATION:  
5. Enter the DW version number of the Property/Building Information program to call when the function is selected. Leave blank (default) to call version 'ZJDE0001'.  
SQUARE FOOTAGE EDITS:  
6. Enter a '1' to perform the square footage edit between the building and the floor(s) set up for the building. Leave blank (default) to bypass the edit.  
7. Enter a '1' to perform the square footage edit between the floor and the unit(s) set up for the floor.

Leave blank (default) to bypass the edit.

  

186.60 Unit Information (P1507)

Processing Option Processing Options Requiring Further Description
REQUIRED STANDARDS OPTION:  
1. Enter a '1' to protect the Required Standards field.  
2. Enter a '1' to bypass automatically copying in Standards. Leave blank to automatically copy in Standards.  
FLOOR NUMBER EDIT:  
3. Enter a '1' to edit the floor number against User Defined Codes. (More....)  
DW VERSION FOR FLOOR MASTER REVISIONS:  
4. Enter the DW version number of the Floor Information program to call when the function is selected.

Leave blank to default to version 'ZJDE0001'.

  
SQUARE FOOTAGE EDIT:  
5. Enter a '1' to perform the square footage edit between the floor and the unit(s) set up for the floor.

Leave blank (default) to bypass the edit. (More...)

  
FORMAT CONTROL:  
6. Select the default screen format:

'1' - Facility Data

'2' - General Information If left blank, the default will be 1.

  

186.61 Subtotals By Floor (P15410)

Processing Option Processing Options Requiring Further Description
COLUMN PARAMETER SELECTION:  
1. Enter the control parameters for up to five columns of statistical information below. If the column heading for any column is left blank, that column will not be printed.

STATISTICAL COLUMN 1

Column Heading (11 Character)

Amenity I.D. Code for statistic STATISTICAL COLUMN 2

Column Heading

Amenity I.D. Code for statistic STATISTICAL COLUMN 3

Column Heading

Amenity I.D. Code for statistic STATISTICAL COLUMN 4

Column Heading

Amenity I.D. Code for statistic STATISTICAL COLUMN 5

Column Heading

Amenity I.D. Code for statistic

  
PRINT SELECTION:  
2. Enter '1' to print actual building statistics, at building change, below the sum of unit totals for the building.  

186.62 Unit Master List - All Units (P1507P)

Processing Option Processing Options Requiring Further Description
AS-OF-DATE SELECTION:  
1. Enter the As-of-Date to be used for this report.  
PRINT SELECTION:  
2. Enter a '1' to page break on change in Building Number. A default of blank will not page break.