Hi,
We have few AR Payment Transaction saved in a Batch.
When we try to post the Batch, we have the following 2 Errors, Can anyone help to resolve this?
Thanks.
*This post is locked for comments
If you haven't already, try removing everyone from GP and then clear the "activity" tables. It is possible something is locking a record/table you need. Clearing the "activity" tables should remove any stranded/orphaned records.
1. Create a backup of your company database.
2. Have all users log out of Dynamics GP.
3. Stop and start the SQL Server to clear the temp tables.
4. Run the following scripts in SQL Management Studio to clear activity records:
use DYNAMICS
delete SY00800
delete SY00801
delete ACTIVITY
use TEMPDB
delete DEX_LOCK
delete DEX_SESSION
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
