1. Homebuilder Management Implementation Guide
  2. Item Pricing Pre-Conversion Review

Item Pricing Pre-Conversion Review

Before you run the F44H603 Base House Cost by Plan program (R44H96003), review all JD Edwards World data to eliminate any records that do not satisfy the unique key requirement.

Run the Item Pricing Pre-Conversion Review (R44H4459) to search for key violations between the Material Item Pricing tables in JD Edwards World (F4459) and JD Edwards EnterpriseOne (F44H603). This table lists the keys for the F4459 and F44H603 tables:

JD Edwards World Keys in the F4459 File

JD Edwards EnterpriseOne Keys in the F44H603 Table

  • CTYC: City

  • LITM: 2ndItem Number

  • AN8: Supplier Number

  • MCU: Subdivision

  • PRN: Price Revision Number

  • HBAREA: Area

  • ITM: Short ID Number

  • AN8: Supplier Number

  • HBMCUS: Community

  • CPHASE: Phase

  • EFFF: Effective Date

The Item Pricing Pre-Conversion Review program reads the records in the F4459 file in this order:

  1. CTYC

  2. ITM

  3. AN8

  4. MCU

  5. EFFF

The program prints a report of the key values in the current F4459 table, as well as the short ID number and effective date. To avoid duplicate key errors, you should either delete all but the current records or change the effective dates to create a unique record before you run the Base House Cost by Plan program (R44H96003).