Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Long Integer

Posted on by 770

 I have a client that is receiving an error when he attempts to recover a batch in Dynamics GP 2010. When using the batch recovery tool, the user received the following and is not able to recover. It reads"Batch 'XXX' failed to complete posting. Use the Batch Recovery window to complete the posting process." followed by "Long integer out of range. Results invalid"

If I look into the database, this batch doesn't show in the PM10200 or PM 10300 tables as suggested in other posts.

*This post is locked for comments

  • RHarper5 Profile Picture
    RHarper5 770 on at
    RE: Long Integer

    Thank you Tristan for the response. This helped to solve the issue inconjunction with the response from KevinD to change the payment date...Thank you both for your help. I had the enduser go into GP to modify the payment date and verify that it was accurate after I modified the SQL table. Thank you again!

  • Verified answer
    KevinD Profile Picture
    KevinD 215 on at
    RE: Long Integer

    Check the transactions in in that batch in SQL and look for a date way in the past or way in the future.  I've had that error a few times trying to post a payment batch and it was always dates way out of range of reasonableness, like doc dates with years of 2199.  It was fine on the edit list, everything looked good, but it gets hung up trying to post to the GL.  Hope that works for you.

  • Verified answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    RE: Long Integer

    Hi RHarpers,

    Update the batch status via SQL using the script below:

    UPDATE SY00500 set MKDTOPST = 0, BCHSTTUS = 0 where BACHNUMB = 'XXX'

    **where  XXX is the Batch ID

    Once done, go to GP and pull up the batch then print the Edit List.  Check the Edit List for any errors.

    If there are any errors, let me know.  If there are none, post as needed.

    Let me know if you have further questions.

  • RHarper5 Profile Picture
    RHarper5 770 on at
    RE: Long Integer

    I can see in the batch master table (SY00500) that record is there. Im not sure what that means for the GL or if I can work some edit in SQL to resolve the error in GP..any advise would be appreciated Thanks.

  • RHarper5 Profile Picture
    RHarper5 770 on at
    RE: Long Integer

    I did follow the instructions on this KB but no results are returned in the SQL qurey. I don't see the item in any of the tables that are mentioned in this KB does that mean it didn't post to GL? if that is that case I can just have the client recreate the batch but i want to check to make certain. thanks!

  • Shyam Nath Profile Picture
    Shyam Nath 505 on at
    RE: Long Integer

    Did you get a chance to look into below kb article:

    support.microsoft.com/.../855322

    Cheers,

    Shyam.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans