trap in how Powerhouse initialises record complexes

[Brett Greiner]

Hi all

We have just experienced a trap in how Powerhouse initialises record
complexes with QTP. This applies to all Powerhouse(?)

access SALE &
  link to SALE_UNIT_SOLD &
  link SALE_LOCATION_ID of SALE, &
       PRODUCT_ID of SALE_UNIT_SOLD &
    to SALE_LOCATION_ID, &
       PRODUCT_ID of FACILITY_FEE_SCHEDULE optional

Since there was no FACILITY_FEE_SCHEDULE record in the record complex
(being optional), the record was setup with initial values. The initial
value for FACILITY_FEE_TO_VENDOR was then set to a "Y". On the
calculation, the customer was charged a Facility Fee due to the
FACILITY_FEE_TO_VENDOR of FACILITY_FEE_SCHEDULE = "Y". Ouch!

Lesson learnt; We must do an additional check that the record exists for
fields with initial values, before doing a calculation.

Cheers
Brett.