What would you like to know more about?

No Distribution for Invoice

When trying to Print/Post Checks in Accounts Payable, this error displays.

Invoices do not post. No distribution for invoice (invoice #).

  • Products affected: Accounts Payable

  • Versions affected: Any

Power surges, network issues, and hardware failure can contribute to data corruption. To fix this, you can repair your DBISam tables.

Since this could result in data loss, make a backup of either the People or Financial Suite (depending on where the error displays) before repairing tables. In addition, everyone in your organization must exit ACS.

DBISam tables have 3 files, .acsdat (data), .acsidx (index) and .acsblb (memo).

When a DBISam table is rebuilt in table maintenance, the original table is backed up. The backup of the original table has the extensions .acsibk, .acsbk and .acsdbk.

To resolve this issue, repair the corrupt tables.

  1. Log in using your ACS user name and password.
  2. Under Data Options, select People Data Backup.
  3. Optional: Under Additional Options, select Verify Backup.
  4. Under Configuration, note the Backup Destination Directory. To change the location, click Lookup .
  5. Click Backup.
  6. In the Select Datasets window, clear any datasets you do not want to back up. We recommend backing up all datasets in each backup in case your data needs to be repaired, but if you include pictures, the backup may be very large.
  7. Click OK.