Resolving Out-of-Balance Conditions

When the system detects that an A/R receipt batch is not in balance, it prints the batch amounts that need to be researched on the report. These conditions might be reported:

  • A/R amount (F03B14) does not equal G/L amount (F0911)

    This condition occurs only when the post program does not finish processing.

    To correct this problem, run the post program again to remove all system-generated entries. When the system detects that the batch is not in balance, it deletes all entries made to the F0911 table. After the entries are removed, run the post program again (a third time) to create entries correctly.

  • A/R amount (F03B14) does not equal the automatic offset amount (F0911).

    This condition occurs only when the post program does not finish processing.

    To correct this problem, run the post program again to remove all system generated entries. When the system detects that the batch is not in balance, it deletes all entries made to the F0911 table. After the entries are removed, run the post program again (a third time) to create entries correctly.

Either condition listed on the report can also occur if data records are damaged. Data records can be damaged for a variety of reasons, including hardware failure. To identify damaged data records, run queries over key fields (company, G/L date, document number, fiscal year, century, and so forth) for the F03B14 and F0911 tables to identify any null, blank, or special characters that should not be part of the value.

To correct this problem, repair the key field or remove the record from the table. Contact the database administrator for assistance in identifying and repairing damaged records.

See