A batch is held in the Posting, Receiving, Busy, Marked, Locked, or Edited status
By: Dean Dorton | May 16, 2014
Accounting Software | Microsoft Dynamics GP | Uncategorized
1) Have all users exit Dynamics GP before running a SQL backup.
2) Run the below SQL query and if any rows of data are returned then go to step 3, if no data is returned go to step 4.
SELECT * FROM DYNAMICS..ACTIVITY SELECT * FROM DYNAMICS..SY00800 SELECT * FROM DYNAMICS..SY00801 SELECT * FROM TEMPDB..DEX_LOCK SELECT * FROM TEMPDB..DEX_SESSION
3) Run the below SQL query to remove the data from the tables.
DELETE DYNAMICS..ACTIVITY DELETE DYNAMICS..SY00800 DELETE DYNAMICS..SY00801 DELETE TEMPDB..DEX_LOCK DELETE TEMPDB..DEX_SESSION 4) Run the below SQL query against the company database. Replace XXX with the batch number or the name of the batch that you are trying to post or select in Microsoft Dynamics GP. UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'
- Note The value of BACHNUMB is the same as the value of the Batch ID window in Microsoft Dynamics GP
Have a question? Click here to contact this representative.
Related Posts
-
3 Reasons to Consider Outsourced Accounting for Your Nonprofit
-
Horse + Trainer + Sage Intacct = A Prosperous Equine Business
-
When MSPs Knew They Outgrew Their Accounting Software
-
Dean Dorton Expands into Florida with Acquisition of Leading Technology Consulting Firm
-
Is it Time to Upgrade Your Nonprofit Accounting Solution?
-
Cloud Accounting – A Perfect Fit for the Sport and Entertainment Industry