Long Integer Out of Range. Results invalid.

A client on GP 2010 recently had an issue where they could not post an AP check batch nor could they access the batch after using Batch Recovery.  They repeatedly received the message “Long Integer Out of Range. Results invalid”.  I found a couple KB articles referencing this same message, but they were outdated and didn’t apply to this issue.

After I created a SQL query to see all of the invoices applied to the payments (below), I noticed that one of the payments was applied to an invoice that had a document date of 1812-01-11.  It’s not every day that you see a 200 year-old invoice getting paid, so I updated the document date for the invoice to the correct year and the batch then posted without issue.

Here are the two tables and fields that needed to be updated:

PM10200 - APTODCDT

PM20000 - DOCDATE

SELECT DOCDATE,*

FROM PM10201

WHERE PMNTNMBR IN

    (SELECT PMNTNMBR

     FROM PM10300

     WHERE BACHNUMB='xxx')

ORDER BY DOCDATE