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) / Can not delete batch G...
Microsoft Dynamics GP (Archived)

Can not delete batch GP2010

(0) ShareShare
ReportReport
Posted on by George Wang 280

Hi, Guru,

One user try to delete batch under "receivables batch entry" and got error "exception_class_script_out _of_range scrip_cmd_set". so I try to run query cmd "update sy00500 set mkdtopst=0, bchsttus=0 where bachnumb="xxx" follow microsoft KB 850289. I got error 'invalid object name 'sy00500'. appreciate for any help!

thanks

 

George W

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Josh P Profile Picture
    Josh P 2,895 on at

    Hi George,

    First, I would have the user log out of GP, log back in, then try again. If they are accessing GP through a terminal server, log out of that too. Sometimes, the SQL connection for that session gets wonky.

    Second, on your script, make sure you are running the script for your company database. I assume you are using SQL Management Studio or something equivalent,

    put a "use <database name>" statement above your query, and execute. You can also select the database from the drop down in the header.

    Third, your script will set the status for any batch that has that batch id. Batch names are not unique across all modules. Have a look at fields "SERIES" and "BCHSOURC"

  • George Wang Profile Picture
    George Wang 280 on at

    Hi, Joshua,

    Thanks for your help. I run the procedure last night all users log off out.

    I put  "use company DB" first line and run other cmds. It shows "one row affected" and "execute successful".

    Then I go into GP to check the batch, it still there. I try to delete it in "receivables batch entry" and got same error "exception_class_script_out _of_range scrip_cmd_set".  any suggestion?

    thanks!!!

    George W

  • Josh P Profile Picture
    Josh P 2,895 on at

    That script does not delete the batch. It only resets the status of it to "Available" and unposted. Try running check links for the RM Transactions work and open tables. It is not necessary to have users logged off for 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

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