*This post is locked for comments
*This post is locked for comments
There is no builtin function for this in GP as far as I know.
From SQL you can export the tables out and reimport them.
Can't you just update the batches that are stuck and exclude this batch in the WHERE clause of your SQL script?
Hi,
Let's simplify your case:
You have few single use batches with posting interruptions which you'd like delete. (In my personal opinion, why not recover using the facility in Great Plains, if possible)
You have few recurring batches which are unposted which you'd like to keep.
What process in Great Plains will affect the latter batches when you delete the former batches? Or am I missing a major detail in your scenario?
Cheers,
Dencio
Hi,
What if you just recover the batch using Batch Recovery?
Another is just update the status of the batch?
Is the transaction saved in that batch corrupted?
Please let us know further details so we can recommend more applicables resolutions.
Cheers,
Dencio
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156