SQL Error when completing AP Check Process

Owned by Claire Aleman
07 11, 2018

User received attached SQL error when completing AP Check process:

An error has been detected in a SQL Statement. 

APP007 -2112 SQL - 02112: SELECT...INTO returns too many rows
move_document_to_chk_hist_base - select base sa_key_num

Press any key to continue.

Applies To

Penta for Windows

  • Accounts Payable
  • Automated Check Processing
  • Complete AP Check Processing

Resolution/Fix/Answer

Penta is aware of this issue and is working towards a resolution. Please log a Service Desk Ticket and reference this article to be notified of the resolution when available.

Cause

In previous Penta versions, ap_chk_sa_num (Accounts Payable system assigned check numbers) number assignments, Penta used the document number, it now uses a sequential number. Because of this, the numbers are starting to duplicate when processing AP checks. A Penta developer will need to set the sequence number to one greater than the highest ap_chk_sa_num in your database. Once this error is fixed, you should not run into this error again.Â