Notifications
Announcements
No record found.
How can I find batches that have been deleted? What table and field would be queried in the database to find the batch creation date and deletion date?
*This post is locked for comments
The Inventory Transaction Batch History is iv30004
The Invoicing Batch History is IVC301000
The Purchasing Batch History is POP30000
The Receivables Batch History is RM30502
The Sales Batch History is SOP30100
Other batch headers are just deleted.
These tables are identified in our updated Information Flow and Posting available in the Convergence Store in Atlanta or on our web site ( www.AccoladePublications.com )
Kimberly, as Richard implies above, if the Batch was Posted, the Batch history, including the user that posted it, would be found in the tables indicated.
However, if the batch was just outright deleted and not posted, it is gone forever. Deleted batches or transactions are not stored in GP.
Thanks for the replies, great help!
Kimberly, if you would, please mark one of the responses as a verified answer so we can get credit.
Both answers are of value to me, I'm a DBA new to GP. Do you have a resolution for finding the transactions that were in the deleted batches? They are pretty much orphaned, what is the best method or query to find all of them. We have a feeling we are missing muliple batches.
And is there a way to see the batch was deleted, it seem that would have to be a transaction as well. I know I won't know what was in it but will the transaction be tied to a user name or userid?
When the batch is deleted, the transactions go with it. There is no trace left behind. The only possibility would be to restore a backup of your database at a point prior to when the deletion occurred.
If the PMCHK batch was deleted before being posted to the GL (deleted from the Transactions>Financial>Series Post screen), how can I recreate the PMCHK batch and post it to the GL? The checks were processed, but AP is not reconciling because of the batch deletion at that point.
Reports->Purchasing->Reprint Journals and choose Transactions and Distributions journals and that should give you enough information to complete a GL batch.
Thanks, Richard
I'm not quite following. If I go to Reports>Purchasing, I have a Posting Journals option. Following that (Reports>Purchasing>Posting Journals), I have a GL Distribution Detail. Is that what I want?
How do I complete a GL batch from there?
Sorry, I'm new to GP and had no predecessors to show me around the system before I started.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
mtabor 1
Victoria Yudin 1
