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) / Checklinks - Created B...
Microsoft Dynamics GP (Archived)

Checklinks - Created Batch without BatchID

(0) ShareShare
ReportReport
Posted on by Cindy E 50

Checklinks created a batch in financial without a BatchID.  There are zero transactions in the batch.  When I click to open the batch, it states " Please select a record first".  I want to delete it.  I ran checklinks on the entire financial series and clear data on the Transaction Work table.  Any other ideas?

*This post is locked for comments

I have the same question (0)
  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Get it deleted on the SQL level , SY00500

    Run the following SQL statement,

    SELECT BACHNUMB, DEX_ROW_ID, * FROM SY00500 WHERE BACHNUMB = ''

    You can then proceed deleting this record by considering the Dex_Row_ID. Run the following SQL Statement;

    DELETE FROM SY00500 WHERE DEX_ROW_ID = Dex_Row_Value

    If you are not quite accustomed to using SQL, please contact you DB administrator.

    Hope this helps,

  • Cindy E Profile Picture
    Cindy E 50 on at

    First statement worked.  After runninb second, it states that "Dex_Row_Value does not exist".  Any ideas?  

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Cindy,

    you are supposed to replace the "Dex_Row_Value" with the number retrieved from the first statement.

    I mean, the first select will give you the Dex_Row_Id of the empty batch id. Suppose it says "543". Now you run the delete statement replacing the (Dex_Row_Value) with 543.

    Your feedback is highly appreciated.

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
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans