Technical Considerations

When you run the Statistics History Update program, the system creates a minimum of four records in the F03B16S table for each customer. For example, if you enter one invoice for customer 1234 for company 00001, the system creates these records in the table:

  • One record for the child information (RSPART = C) for the company that the invoice was entered against (RTCO = 00001).

  • One record for the child information (RSPART = C) for company 00000.

    The system uses the record for company 00000 to total the information for all company records.

  • One record for the parent information (RSPART = P) for the company that the invoice was entered against (RSCO = 00001).

    Even if you do not use parent/child relationships, the system still generates a parent record.

  • One record for the parent information (RSPART = P) for company 00000 (RSCO = 00000).

    The system uses the record for company 00000 to total the information for all company records.

If you had invoices entered for multiple companies, the system would generate additional records, one record for each company for both the child and the parent.