Purchasing Open Invoices Show Already Applied

(0) Share

Report

Posted on by Community Member

Had a system crash while in the Purchasing module Manual Payment Entry screen entering manual payments to be posted to a credit card. Had applied seven invoices when system crashed.

Once SQL and GP came back up there were messages looking up a batch that it cannot post or unmark the batch and the batch is marked for posting by another user. We ran Microsoft's "DynamicsGP - Batch Fix (KB850289) MicrosoftEasyFix50435".

Now the batch is no longer visible.

Invoices still show as open in Payables Transaction Inquiry by Vendor.
However we cannot delete or void historical or open transactions since the invoices are showing applied.

The batch does not show up in historical or open transactions.

We have tried all the Check Links and Reconcile utilties after researching online but that didn't help.

I can browse the PM20100 table and see the records. It's only 7 records and don't care if we have to delete and recreate entries. We just want to get our balances correct.

Any ideas? Thanks in advance.

*This post is locked for comments

All responses (6)

Answers (1)

Heather Roggeveen 9,146 on at

Like (0)

Report

RE: Purchasing Open Invoices Show Already Applied

Hi

You are most welcome HatterasIT. I would appreciate if you would mark the answer I posted as verified - it helps other users if they are searching for information.

Cheers

Heather
Suggested answer

Community Member on at

Like (0)

Report

RE: Purchasing Open Invoices Show Already Applied

Heather thank you so much for your insightful assistance.

We were able to remove the records from PM10200, PM00400 then ran Check Links which created records in history. Removed the records from history PM30200 and after running Check Links cleared up the problem.

Our controller made an adjusting entry on the financial side but now we can revoucher and make payment.

Again thank you.
Verified answer

Heather Roggeveen 9,146 on at

Like (0)

Report

RE: Purchasing Open Invoices Show Already Applied

Hi

You may need to do some searching through the tables to clear records.

You note that you see records in the PM2xxxx tables. You may have a situation where there are records in the PM3xxxx (history tables) as well and PM1xxxxx for payment records.

This probably is a case where you will need to pull records out of tables to take it back to before the transaction.

If the invoices were an open invoice, then they should have records in the PM20000. If they were fully open (i.e. no partial applies already), then there should be no records in PM20100.

Look for any records related to the payment and the payment apply (more likely in PM10201 and PM10400) and remove those. Any records that may be showing in PM3xxxx series are probably also not correct.

Use the resource descriptions (Tools --> Resource Descriptions --> Tables) to look for the tables that would seem most relevant.

You may also need to check for payment records in the PM Keys table (PM00400).

I would once you have cleared the records in SQL run a check links. You may possibly also need to rebuild the keys table.

Make sure you have a back up, and if you want to see the impact and try it, do it in a test company first.

Double check that there is nothing for the user in SY00800.

I had to do a similar job myself last week with sorting out corrupted data - not fun - but sometimes the only way!

Cheers

Heather
Suggested answer

babubaskaran@outloo... 10 on at

Like (0)

Report

RE: Purchasing Open Invoices Show Already Applied

Hi,

Please run checklink against payable series and check the same.
Community Member on at

Like (0)

Report

RE: Purchasing Open Invoices Show Already Applied

Hi Babu. Thank you so much for your detailed reply.

Unfortunately the records do not exist in the SY00500 table.

The batch does not appear anymore in Dynamics GP. After the crash the batch showed with zero dollars and no entries. Since running Microsoft's batch fix it's no longer viewable.

I don't know what this means or how to correct, but I can see the 7 records in the PM20100 table. And the a record for each batch is still in PM20000.

Any additional thoughts are appreciated.

Thank you
Suggested answer

babubaskaran@outloo... 10 on at

Like (0)

Report

RE: Purchasing Open Invoices Show Already Applied

Hi,

Please run the following script from Microsoft KB. Please take a backup before doing this.

View the contents of the following tables to verify that all users are logged off: DYNAMICS..ACTIVITY, DYNAMICS..SY00800, DYNAMICS..SY00801, TEMPDB..DEX_LOCK, and TEMPDB..DEX_SESSION. To do this, run the following script.

SELECT * FROM DYNAMICS..ACTIVITY

SELECT * FROM DYNAMICS..SY00800

SELECT * FROM DYNAMICS..SY00801

SELECT * FROM TEMPDB..DEX_LOCK

SELECT * FROM TEMPDB..DEX_SESSION

Note When all users are logged off from Microsoft Dynamics GP, these tables will not have any records in them.

clear the stuck records by using any of the following appropriate scripts.

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

Run the following script 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.