Understanding Accounts Receivable Integrity Reports and Programs (Release 9.2 Update)

Integrity reports and programs help identify any problems and inconsistencies with JD Edwards EnterpriseOne data so that you can resolve them and ensure that the systems remain in balance. Use these reports and programs to verify that the accounts receivable data matches the general ledger data and that the accounts receivable transactions have the correct pay status.

Integrity reports do not have "as of" capability. That is, you cannot run the reports as of a certain date, such as the last day of the month, to ensure that the data was in balance at that time. You can run the report only as of the current date.

Follow these guidelines when running the Accounts Receivable integrity reports:

  • Run the reports when other users are not accessing the system.

  • Run the reports frequently, so that you do not risk compromising accounting data.

  • Run the reports needed during the conversion process at a new software installation site or during an initial learning period so that you can correct any errors promptly. Any integrity issues that exist prior to conversion will exist after conversion.

To reduce and resolve integrity issues:

  • Ensure that the network is stable and that communication failures are not causing problems.

  • Review software custom modifications because these can cause integrity problems.

  • When researching integrity problems, collect as much supporting documentation as possible. Such documentation is valuable if you need additional assistance from technical support to resolve an issue.

  • Use JD Edwards EnterpriseOne software to resolve integrity problems. In some cases, using other database utilities can worsen the problem.

Schedule integrity reports to run during off-peak hours, because no changes can be made to the data when integrity tests are running.