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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / This Checkbook has alr...
Microsoft Dynamics GP (Archived)

This Checkbook has already been assigned to a Bank Upload ID

(0) ShareShare
ReportReport
Posted on by Kim Hippen 105

I am getting this error in GP 2010 with SafePay when I try to connect the checkbook. The checkbook is not connected to another Bank Upload ID.

How do I clear the Bank Upload ID from this checkbook so I can attach it to the correct Safepay?

Is there a table where I can do this?

I've tried checklinks on the Checkbook Master and CM setup and that didn't fix the issue.

I've looked at Table ME142801 and it is blank.

I see other people have had this issue - but I can't find out how they fixed it.

Your help is greatly appreciated.

Thanks.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Pam Robertson Profile Picture
    Pam Robertson 4 on at

    Look in the ME123502 table for a record with a blank PP_Number and that checkbook ID, and delete it.  We had the same problem, and once we deleted the record from the ME123502, the error went away and we were able to add the checkbook to the Bank Upload ID.

  • Verified answer
    Kim Hippen Profile Picture
    Kim Hippen 105 on at

    This is the solution that worked for me.

    To resolve this, please follow the steps below:

    1. Open up SQL Query Analyzer.

    2. Select the correct company database.

    3. Run the following script to identify damaged records:

    SELECT * from ME123502 where CHEKBKID = 'XXX'

    SELECT * from ME123501

    ***Where 'XXX' pertains to the checkbook that you are trying to assign to a new 'Bank Upload ID'. The 'ME123501' pertains to the 'ME_PP_Upload_MSTR' table and 'ME123502' pertains to the 'ME_PP_Upload_Checkbooks' table.

    4. Verify if the checkbook is assigned to a blank 'Bank Upload ID' in the 'ME123502' as well as how many 'Bank Upload ID' is showing in the 'ME123501' table.

    5. If the checkbook is assigned to a blank 'Bank Upload ID' and only one 'Bank Upload ID' is showing in the 'ME123501' table, take note of the 'DEX_ROW_ID' of the damaged record in the 'ME123502'.

    6. Run the following script to remove the damaged record:

    DELETE ME123502 where DEX_ROW_ID = 'AAA'

    *** Where 'AAA' pertains to the 'Dex_Row_ID' containing the blank Bank Upload ID.

    7. Once done, log back to Microsoft Dynamics GP and try to add the checkbook to the new 'Bank Upload ID' you've created (Microsoft Dynamics GP| Tools | Routines | Financial | Safepay | Upload Maintenance). Verify if the issue is now resolved.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans