Finance | Project Operations, Human Resources, ...

Deleted Batch tracker

(2) Share

Report

Posted on by NR-21081315-0

Hello!! In which SQL Table we can find out the information about deleted batch in GP. Like user who deleted the batch, time, Batch ID etc.
These information available in GP > Tools > Setup > System > Activity Tracking but would appreciate if someone can help me with query.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Lisa at AonC.com 958 Super User 2025 Season 2 on at

Like (1)

Report

Activity tracking is stored in SY05000 of the system (usually DYNAMICS) database.

Here is a link to an enhancement post that includes how to print and query on the data:

Improved Activity Tracking in Microsoft Dynamics GP!!

Was this reply helpful? Yes No
Joseph Markovich 3,976 on at

Like (1)

Report

If you want to supercharge auditing in GP, check out Auditor from Rockton Software. It is really awesome and tracks information about adds, updates, DELETES for everything in GP and any third-party.

I have no connection to them except being a long-time customer of their products. Couldn't live without Auditor now.

Joe

Was this reply helpful? Yes No