Understanding External Cost Analyzer Balances Uploads

After you review and revise the balance records in the External Cost Analyzer Balances - Interoperability Table (F1602Z1), run the External Cost Analyzer Balances Processor program (R1602Z1) to upload the records to the Cost Analyzer Balances table (F1602).

Before the External Cost Analyzer Balances Processor program uploads the records to the F1602 table, it edits the records to ensure that the information is in the correct format. After the program edits the records, it generates a report that lists the number of records selected from the F1602Z1 table, the number of records added to and updated in the F1602 table, and the number of records that failed.

If a record fails, the system creates a workflow message that indicates that an error occurred. Use the External Cost Analyzer Balances program (P1602Z1) to correct the error, and then run the External Cost Analyzer Balances Processor program again.

The External Cost Analyzer Balances Processor program selects only records that have not been posted to the F1602 table. After the program uploads the balances, it marks them as posted in the F1602Z1 and the F1602 tables.

Depending on how you set the Action Code Override processing option, the External Cost Analyzer Balances Processor program either adds the balances to existing balances or creates new balances. If you set the processing option to 1, the F1602Z1 overrides the value in the Action Code field in the F1602Z table if appropriate. If the action code is C and a value exists in the F1602 table, the R1602Z1 amount is added to or subtracted from the existing balances in the F1602 table. If the action code is A and an F1602 record does not exist, a new record is added to the F1602 table. If an F1602 record already exists, the existing F1602 record is replaced.