You’re offline. This is a read only version of the page.
15
Hi - my new company is currently using Dynamics GP 2015 - I have found that there are a lot of unapplied payables. I tried to apply them but I keep on receiving this error message. I have checked the batch recovery and found none. I also run the below scripts and not of them worked.. I have also look into table PM10000 and also found nothing. It is actually 2000 unapplied payables. If there is someone here who can teach or show me how to clear even just one payable, I will really really appreciate it. Thank you in advance for the assistance.
SELECT * FROM [DYNAMICS].[dbo].[ACTIVITY] ORDER BY USERID
SELECT * FROM [DYNAMICS].[dbo].[SY00800]
SELECT * FROM [DYNAMICS].[dbo].[SY00801]
SELECT * FROM [TEMPDB].[dbo].[DEX_LOCK]
SELECT * FROM [TEMPDB].[dbo].[DEX_SESSION]
If any records are returned run this.
DELETE [DYNAMICS].[dbo].[ACTIVITY]
DELETE [DYNAMICS].[dbo].[SY00800]
DELETE [DYNAMICS].[dbo].[SY00801]
DELETE [TEMPDB].[dbo].[DEX_LOCK]
DELETE [TEMPDB].[dbo].[DEX_SESSION]
Thank you Gavin and Richard for your comments. I agree that those are both good steps to try in a test company with a copy of live or after making a restorable back up with no users in the system to clear this error.
This issue can also occur due to having the same document in both work and open tables (Unposted PM10000 and Posted table PM20000) . In order to resolve the issue, you basically need to delete the record from the PM10000 work table.
I just wanted to add one more scenario that I have seen cause this error. (This is more likely not your issue if you say that there are no records in the PM10000 table, but I wasn't sure if that is what you meant or not in your initial description of the issue.
We can see this error if there was a posting interruption initially and the transaction exists in both the PM10000 and the PM20000 table
Again, please only do this if you are in a test company with a copy of live:
1. First, run these scripts to see if you get 1 record returned for each script, to verify that the invoice exists in both the open and work trx tables:
SELECT * FROM PM10000 WHERE VCHNUMWK = '00000000000XXXXX'
SELECT * FROM PM20000 WHERE VCHRNMBR = '00000000000XXXXX'
SELECT * FROM PM00400 WHERE CNTRLNUM = '00000000000XXXXX' --verify DCSTATUS=2
--Modify the voucher number in each script
2. If you get 1 result for each script above, then run this script to delete the one in work:
DELETE FROM PM10000 WHERE VCHNUMWK = '00000000000XXXXX'
3. Now test applying again to verify the message is gone.
Thanks,
Isaac Olson
Microsoft Support
You could also try this:
1) Perform backup
2) Using SSMS DELETE [dbo].[PM00400] on your company database
3) Run Check Links on AP Open and Historical tables. This will result in a long list
4) Hopefully this restores the batch containing these records
5) Review this batch and either post or delete it.
Do this with no one in GP.
Hi,
I'm fairly sure that when I've had this in the past its because of stranded records in the PM20100 table. (this holds information that would be later printed on the remittance advice)
Therefore check this table and if records exist for these documents remove them - I'd test one first. (also take a backup first - for a backup I tend to do a SELECT * INTO PM20100_BACKUP FROM PM20100 and then add a WHERE clause that captures the rows you are deleting. Then you can always reinsert them quickly if needed)
Hope this helps.
Thanks
Gavin
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (