web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Long integer out of range
Microsoft Dynamics GP (Archived)

Long integer out of range

(0) ShareShare
ReportReport
Posted on by Kitty Geiger 50

I have 4 Sales invoices that are stuck in Batch Recovery with the posting error message "long integer out of range results invalid". I am unable to process them in Batch recovery so I can not open them to or view.  I ran all check links and reconciled but nothing releases the batch from Recovery. It looks like the error is in posting to the Sales module as they errored before posting to GL.

We plan on deleting the batch from the tables but what would cause this error message so I know what to keep an eye out for?  There is nothing unusual about the invoices.

Thanks

Kitty Geiger 

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Long integer out of range

    Hi Kitty,

    When I have run into error messages like this it has usually meant that one of the choices on the Sales document or batch had a blank value. For instance, the document type field was blank. I would take a look at the SOP work table and see if there are any irregularities.

    Kind regards,

    Leslie

  • Susan Charpentier Profile Picture
    Susan Charpentier 25 on at
    Re: Long integer out of range

    How do you look at the SOP work table? I am having the same problem when running A/P checks.

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    Re: Long integer out of range

    Do you have the client tools for SQL?

    The application I would run to look into the database tables is SQL Server Management Studio.

    You could also use Excel to make a connection to the database and then return data using MS Query. The SOP Work table is SOP10100, the document type field is SOPTYPE. The valid values for SOPTYPE are :

    1 – Quote

    2 – Order

    3 – Invoice

    4 – Return

    5 – Back Order

    6 – Fulfillment Order

    The unposted payables checks are in the PM10300 table. Any of the integer fields can be causing the problem, but it my experience the 'out of range' meant it was blank.

  • djr03 Profile Picture
    djr03 45 on at
    Re: Long integer out of range

    I also came across this this morning while posting AP checks and found an invoice that one of the checks was applied to had a document date outside of a setup fiscal period.  I updated the document date in the PM20000 to a valid date and the batch posted fine.

    Article KB855322  provides more information regarding this.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans