This appendix contains the following topics:
Section A.1, "JD Edwards EnterpriseOne Homebuilder Management Reports: A to Z"
Section A.2, "JD Edwards EnterpriseOne Homebuilder Management Reports: Selected Reports"
This table lists the JD Edwards EnterpriseOne Homebuilder Management reports, sorted alphanumerically by report ID:
Report ID and Report Name | Description | Navigation |
---|---|---|
R44H1001
Community Master Report |
Prints a list of community master records and provides an audit of community master setup. | Foundation Management (G44H21), Community Master Report |
R44H2001
Lot Inventory Listing |
Prints a list of the lots that are available in a community or phase. This report includes lot address, plan, elevation, cost code template, lot status, and commit start date information. | Foundation Management (G44H21), Lot Inventory Listing |
R44H2002
Lot Status |
Prints a list of the status of lots, the dates for the start of construction and commitments, and the estimated or actual completion date of a lot in a community or phase. This report shows the availability of a lot and the construction progress of a lot and house.
This report differs from the Lot Inventory Listing report (R44H2001) because it focuses primarily on the construction and sales status of each of the lots. |
Foundation Management (G44H21), Lot Status |
R44H3001
Plan Master Report |
Prints a list of plan setup and availability by area, phase, and community. This report includes descriptions, square footage, and pricing information for plans that are available in a given community or phase. | Foundation Management (G44H21), Plan Master Report |
R44H4002
Option Master Listing |
Prints a list of the options that are available within a community or phase. This report includes the option numbers, descriptions, key category codes, and option package and component information, as well as option pricing with the price effective and expiration dates. | Foundation Management (G44H21), Option Master Listing |
R44H4003
Option Package Listing |
Prints a list of the option packages and the components of the packages within a community or phase. This report includes package pricing and price effective and expiration dates. | Foundation Management (G44H21), Option Package Listing |
R44H5000
Weekly Sales Report |
Prints sales information by lot. This report includes key sales and construction dates and revenue, financing, and contingent sale information.
Specify the versions to use for the Weekly Sales Report (R44H5001) and the Weekly Sales Audit Report (R44H5002) in the processing options. |
Sales and Escrow (G44H22), Weekly Sales Report |
R44H5003
Backlog Report |
Prints a projection of revenue and cash flow for a specified date range. This report shows the construction status, buyer name, base price, lot premium, option revenue, incentives, and total sales price for each lot. | Sales and Escrow (G44H22), Backlog Report |
R44H5004
Projected Closings Report |
Prints a list of the lots that are projected to close escrow, based on a specified date range. | Sales and Escrow (G44H22), Projected Closing Report |
R44H5005
Cancellation/Transfer Report |
Prints a list of sales and transfers for an area or community for a specified date range. The report prints associated text and notes, based on a processing option setting. | Sales and Escrow (G44H22), Cancellations/Transfers Report |
R44H5006
Detail Sales Status (Mylar) |
Prints sales and contingency attachments. | Sales and Escrow (G44H22), Detail Sales Status (Mylar) |
R44H6001
Bid Contract Price Variance |
Prints a list that shows discrepancies between the bid and the contract amounts by cost code. Use the processing options to specify the tolerance amount, tolerance percentage, and the bid document type. | Before Start Bidding and Costing (G44H23), Bid Contract Price Variance |
R44H6002
Bid Form/Contract Confirmation |
Prints a confirmation for bid pricing. You can also request a price format, which allows suppliers to make changes to existing bids. | Before Start Bidding and Costing (G44H23), Bid Form/Contract Confirmation |
R44H6003
Base House Cost by Plan |
Prints a report that shows base plan costs on a cost code level for selected plans and elevations in a specific community or phase. This report compares the cost of the base house for each plan or elevation. | Before Start Bidding and Costing (G44H23), Base House Cost by Plan |
R44H6004
Option Cost Analysis |
Prints a list of option cost and pricing information. This report shows the current, previous, and suggested price for an option, as well as the desired and actual gross profit. | Before Start Bidding and Costing (G44H23), Option Cost Analysis |
R44H6006
Option Cost Analysis by Option |
Prints a report that shows all communities that offer a particular option. | Before Start Bidding and Costing (G44H23), Option Cost Analysis by Option |
R44H6007
Bid Supplier Comparison |
Prints a report that compares bids from multiple suppliers, based on a specified community, plan, elevation, and trade. | Before Start Bidding and Costing (G44H23), Bid Supplier Comparison |
R44H6008
Purchase Order Print |
Prints purchase orders that are specific to the JD Edwards EnterpriseOne Homebuilder Management system. The purchase orders include item number, item description, cost code, option number, and unit price. | Before Start Bidding and Costing (G44H23), Purchase Order Print |
R44H6009
List by Supplier |
Prints a report to use to verify item pricing and update the price status in the Material Item Pricing table (F44H603). You can also request a price format. | Before Start Bidding and Costing (G44H23), List by Supplier |
R44H7003
Configuration List |
Prints a list of all options that the buyer selected for a lot. Print this report at the lot level and use processing options to specify whether pricing information appears on the report. | Sales and Escrow (G44H22), Configuration List |
This section includes processing options for the reports listed in the summary table. The processing options are listed alphanumerically by report ID.
Processing options enable you to specify the default processing for programs and reports.
Specify whether to print all phase records in a community or only the records in phase 000. Values are:
Blank: Print phase 000 only. (default)
1: Print all phases.
The menu selection for Weekly Sales Report accesses R44H5000. In the R44H5000 processing options, you designate which versions of the Weekly Sales Report (R44H5001) and the Weekly Sales Audit Report (R44H5002) to run. The following processing options apply to both the Weekly Sales Report (R44H5001) and the Weekly Sales Audit Report (R44H5002).
Specify whether to print the Weekly Sales Report (R44H5001) and Weekly Sales Audit Report (R44H5002) at the community or phase level. Values are:
C: Community level. The reports include both area and community totals.
P: Phase level.
Specify a user-defined title for the reports.
Specify the format for the report titles. Values are:
A: As of.
P: Period.
S: For the Period Ending.
W: For the Week Ending.
Specify the as of date to use in the report header. This value is not used for data selection.
Specify the starting and ending dates for period 1.
Specify the description for period 1. For example, This Week, This Month, First Quarter, or This Year.
Specify whether to print an audit report. An audit report prints each lot that is included in each total. Values are:
Blank: Do not print.
1: Print.
Specify the starting and ending dates for period 2.
Specify the description for period 2, for example, This Week, This Month, First Quarter, or This Year.
Specify whether to print an audit report for period 2. An audit report prints each lot that is included in each total. Values are:
Blank: Do not print.
1: Print.
Specify the starting and ending dates for period 3.
Specify the description for period 3. For example, This Week, This Month, First Quarter, or This Year.
Specify whether to print an audit report for period 3. An audit report prints each lot that is included in each total. Values are:
Blank: Do not print.
1: Print.
Specify the starting and ending dates for period 4.
Specify the description for period 4. For example, This Week, This Month, First Quarter, or This Year.
Specify whether to print an audit report for period 4. An audit report prints each lot that is included in each total. Values are:
Blank: Do not print.
1: Print.
Enter 1in one of the following processing options to specify that date is used for sales statistics calculations on the reports.
Specify whether to use the value entered in the Sales Date field on the House Revisions form.
Specify whether to use the value entered in the Sales Reported field on the House Revisions form.
Specify whether to use the value entered in the Sales Ratified field on the House Revisions form.
In the following processing options, enter 1 to use this value for sales statistics and revenue calculations on these reports.
Specify whether to use the value entered in the Base House Price field on the House Revisions form.
Specify whether to use the value entered in the Lot Premium field on the House Revisions form.
Specify whether to use the value entered in the Upgrade Amount field on the House Revisions form.
Specify whether to use the values entered in the Incentive 1,Incentive 2,and Incentive 3 fields on the House Revisions form.
Specify whether to use the values in the Option Revenue Category 1 through Option Revenue Category 9fields entered on the House Revisions form. The Option Revenue Categories are controlled by the Homebuilder accounting instructions.
Specify whether to use the value in the Option Incentive field entered on the House Revisions form.
Specify the version to use for each of the reports. If you leave this processing option blank, the system uses default version XJDE0001.
Processing options enable you to specify the default processing for programs and reports.
Specify the starting and ending dates for all sales expected to close with a projected close date.
Processing options enable you to specify the default processing for programs and reports.
Specify the starting and ending dates for all sales expected to close with a projected close date.
Processing options enable you to specify the default processing for programs and reports.
Specify the starting and ending dates for all sales expected to close with a projected close date.
Specify whether to print associated text about the cancellation or transfer event. Values are:
Blank: Do not print.
1: Print.
Specify whether to print attachment notes regarding the cancellation or transfer. Attachment notes can include up to three contingency notes and three transfer notes. Values are:
Blank: Do not print.
1: Print.
Processing options enable you to specify the default processing for programs and reports.
Specify whether to print the sales attachment. If you print the sales attachment, the report prints only two lots per page. Values are:
Blank: Do not print.
1: Print.
Specify whether to print the contingency attachment. If you print the contingency attachment, the report prints only two lots per page. Values are:
Blank: Do not print.
1: Print.
Processing options enable you to specify the default processing for programs and reports.
Specify the tolerance amount.
The system calculates the bid contract price variance between the JD Edwards EnterpriseOne Procurement and JD Edwards EnterpriseOne Homebuilder Management systems. The system compares this variance to the tolerance amount that you enter in this processing option. If the variance is greater than or equal to the tolerance amount, the report includes the bid contract price.
Specify the tolerance percentage. For example, enter 0.15 for 15 percent.
Specify whether to select positive or negative variances or both. Values are:
Blank: Positive and negative variances.
1: Positive variances only.
2: Negative variances only.
Enter a code from UDC 00/DT that specifies the bid document type. Leave this processing option blank to select all document types.
Specify the UDC table to use for the variance reason code. Values are:
1: UDC 41/P1
2: UDC 41/P2
3: UDC 41/P3
4: UDC 41/P4
Processing options enable you to specify the default processing for programs and reports.
Specify the format in which to run the report. Values are:
Blank: Detail format.
1: Request for Price format.
If you enter 1, the Dates, Subcontractor (Supplier), Contract Total, and Signature Line fields on the report will be left blank.
Specify whether the system prints signature lines at the bottom of each contract. Values are:
Blank: Do not print.
1: Print.
To print signature lines, the Request for Price Format processing option must also be set to 1.
Specify which bids to print. Values are:
Blank: Print all bids.
1: Print only the most recent bid.
Specify the type of community information to print at the top of each contract. Values are:
Blank: Print the community number.
1: Print the community description.
When you run the report, you can use processing options to include taxes in the cost amount, suppress accounts that include no cost, and summarize cost amounts by cost code.
Specify whether to print the cost per square foot. Values are:
Blank: Do not print.
1: Print.
Specify how the system prints cost amounts. Values are:
Blank: Print detailed cost amounts for every cost code or cost type that is processed.
1: Print a summarized cost amount for all cost types with the same cost code.
Specify whether the system prints accounts that have no base house costs. Values are:
Blank: Print accounts.
1: Do not print accounts.
Specify the effective date. If you leave this processing option blank, the system uses today's date.
Specify which contract to use when calculating the base cost of a house. Values are:
Blank: Bid contracts and takeoffs.
1: Bid contracts only.
2: Takeoffs only.
Specify whether to include Budget Only bids on the report. Values are:
Blank: Do not include.
1: Include.
Specify which type of discount to use when calculating the cost for takeoffs. Values are:
Blank: Do not use discounts.
1: Model discount.
2: Standard discount.
Note: For a model discount to be calculated, the lot must be marked as a model and the model pricing fields must be set on the record. For a standard discount, the record must be set up. |
Specify a code from UDC 44H2/SW that determines the swing of the house. Values are:
Blank: Standard.
1: Reversed.
Specify whether the system includes the tax commitment in the cost amount. If the tax commitment is included, the system calculates the per square foot amount using the cost and the tax commitment. Values are:
Blank: Do not include.
1: Include.
Processing options enable you to specify the default processing for programs and reports.
Specify a code from UDC 44H2/SW that determines the swing of the house. Values are:
Blank: Standard.
1: Reversed.
Specify the effective date for a bid to use to compare suppliers.
Specify the rounding preference for the calculated suggested sales price. Values are:
Blank: Do not round. For example, use the original value of 1236.56 USD.
1: Round to the nearest whole number. For example, round 1236.56 USD to 1237.00 USD.
2: Round to the nearest tenth. For example, round 1236.56 USD to 1240.00 USD.
Specify whether to run the report in proof or final mode. Values are:
Blank: Proof mode.
1: Final mode. This mode updates the previous price from the current price and the current price to the suggested price.
Specify the updated sales price effective date. This date is used in option selection to determine if the current sales price is used or the previous sales price is used.
Specify whether to print the associated field on the report. Values are:
Blank: Print.
1: Do not print.
Specify whether to print a detail or summary report. Values are:
Blank: Print the summary report (default).
1: Print the detail report.
Specify the contract type to print. Values are:
Blank: Print both bid contracts and takeoffs (default).
1: Print bid contracts only.
2: Print takeoff only.
Specify which type of discount to use when calculating the cost for takeoffs. Values are:
1: Model discount.
2: Standard discount.
3: No discounts (default).
Note: For a model discount to be calculated, the lot must be marked as a model and the model pricing fields must be set on the record. For a standard discount, the record must be set up. |
Processing options enable you to specify the default processing for programs and reports.
Specify a code from UDC 44H2/SW that determines the swing of the house. Values are:
Blank: Standard.
1: Reversed.
Specify the effective date for a bid to use to compare suppliers.
Specify the rounding preference for the calculated suggested sales price. Values are:
Blank: Do not round. For example, use the original value of 1236.56 USD.
1: Round to the nearest whole number. For example, round 1236.56 USD to 1237.00 USD.
2: Round to the nearest tenth. For example, round 1236.56 USD to 1240.00 USD.
Specify whether to print the associated field on the report. Values are:
Blank: Print.
1: Do not print.
Specify the contract type to print. Values are:
Blank: Print both bid contracts and takeoffs (default).
1: Print bid contracts only.
2: Print takeoff only.
Specify the type of discount to be taken on takeoff-related commitments. Values are:
1: Model discount.
2: Standard discount.
3: No discounts (default).
Note: In addition to this processing option, for a model discount to be calculated the lot must be marked as a model and the model pricing fields must be set on the record. Standard discounts require the processing option and the record to be set up. |
Processing options enable you to specify the default processing for programs and reports.
Specify the supplier that you want to include on the report.
Specify the community to use to compare suppliers.
Specify the phase to use to compare suppliers.
Specify the plan to use to compare suppliers.
Specify the elevation to use to compare suppliers.
Specify the as of date to use to compare suppliers.
Specify whether to include a calculation of the cost per square foot on the report. Values are:
Blank: Do not include.
1: Include.
Processing options enable you to specify the default processing for programs and reports.
In the following processing options, you must enter codes that have been set up on the Order Activity Rules form for the order type and line type that you are using.
Specify a code from UDC 40/AT that determines the start of the status code range that you want the system to update
Specify a code from UDC 40/AT that determines the end of the status code range that you want the system to update.
Specify a code from UDC 40/AT that determines the next status code that you want the system to update. The override status is another allowed step in updating status codes.
Specify whether the system updates the status of an order. Values are:
Blank: Do not update.
1:Update.
Processing options enable you to specify the default processing for programs and reports.
Specify the processing format for the report. Values are:
Blank: Detail. Includes only current records and does not update the price status.
1: Request for Proposal. Does not include signature lines.
2: Request for Proposal. Includes signature lines.
3: Detail. Includes only current records and updates the price status.
4: Detail. Includes all records and does not update the price status.
5: Detail. Includes all records and updates the price status.
Specify the effective date to use to update the price status. If you leave this processing option blank, the system uses the current date.
If you enter 3 or 5in the Report Format processing option, the system compares the effective and expiration dates to the date that you enter in this processing option and updates the price status to one of these values:
H: Historical.
C: Current.
F: Future.
This report is also referred to as the garage sticker or window sticker. This report lists all of the options that the buyer chose for a lot. You can include this report in the lot start package that you provide to all subcontractors who are assigned to the lot.
Specify the price of the option.
Specify whether to print text attachments. Values are:
Blank: Do not print (default).
1: Print.
Specify which option description lines to print. Values are:
Blank: Print only the first description line (default).
1: Print all three description lines.