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't delete a Sales B...
Microsoft Dynamics GP (Archived)

Can't delete a Sales Batch

(0) ShareShare
ReportReport
Posted on by Kent Flora 170

I'm needing to delete a Sales Batch that doesn't think it's empty.  When loading it into the Sales Batch Entry window, attempting to delete it says, "Some documents in this batch could not be deleted." There are no values in the Control Column.  There are values in the Actual Column.  But there are no associated transactions to be found whe clicking the Transactions button.

Can I just delete this record entry from the SY00500 table or are there additional records in other tables to consider?

I've scowered Customer Source and there isn't anything that refers to this issue at all.  Hope to hear from somebody.

Sincerely,

Kent

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Are there sales orders left in this batch? Do any of them have customer pre-payments against them? If you print an edit list it will only list orders and returns, no orders. Try doing a lookup on the order number and have it sort by batch. I bet you will find orders sitting in this batch.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Correction, I menat to say:

    If you print an edit list it will only list invoices and returns, no orders

  • Community Member Profile Picture
    Community Member on at

    There is a SQL way to find whether this batch has been used on any transaction, which somehow is/are not showing up on GP.

    A stored procedure named "spSearchOnAllDB" can be found from this link: blogs.msdn.com/.../spsearchonalldb-sql-stored-procedure-to-search-an-entire-database.aspx

    Create this procedure on the respective company database and then execute this stored procedure with the parameter value being the batch number in question. From the results, I am certain, that you can figure out the actual issue. I assume that you administer the SQL Server OR have necessary permissions to do any SQL operations.

    Hope that helps.

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    I have seen cases like this before.  It usually occurs when someone changes a batch using the Sales Transaction Entry window and clears the screen but does not exit the screen before shutting down their terminal.

    First, try Richard Wheeler's instructions to MAKE SURE you really have nothing in the batch.  Then delete it from the table.  If you missed a document that really is in the batch, running a checklinks and reconcile will bring the batch back!

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