Vendor Payment Stuck in Database not showing in GP

(0) Share

Report

Posted on by Ahmed Zaveri

910

One of my users have created a payment using manual payment screen in purchase module, the user posted the batch but due to some reason the batch was not posted and the vendor and bank ledger was not affected. Now the data is residing in PM10200 and document status is unposted, however the document is not showing in MS GP enquiry screen or smartlist.

How to fix this problem.

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

The transaction would only show in Inquiry window if it were posted. Can you still pull the transaction up in Manual Payment Entry? It's unusual that you cannot see it in SmartList. I assume the batch is not sitting in batch recovery, correct? If not, try the following:

1. 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.

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 Great Plains.

2. View the contents of the SY00800 table that is located in the DYNAMICS database to determine the value of the DEX_ROW_ID field for the batch that you are trying to unmark. You can view the contents of this table by running the following script.

SELECT * FROM DYNAMICS..SY00800

Note If no results are returned, go to step 5.

3. Run the following delete script that is based on the results that you received in step 3. Replace XXX with the DEX_ROW_ID value of the batch that you are trying to unmark.

DELETE DYNAMICS..SY00800 where DEX_ROW_ID= 'XXX'

4. Verify the accuracy of the transactions.

5. Verify that you can edit and post the batches.

Hope this helps,

Was this reply helpful? Yes No
Ahmed Zaveri 910 on at

Like (0)

Report

Thanks for replying, but the problem is PM10200 table do not contain a batch number field, also i have checked sy00500 there is no such batch in this table which the user entered when entering the transaction. any suggestions?

Was this reply helpful? Yes No
Hossam Fathy 2,611 on at

Like (0)

Report

Are you using GP9?

Run check links for payable module.

Was this reply helpful? Yes No
Ahmed Zaveri 910 on at

Like (0)

Report

im using GP 10, already ran check links, reconcile but nothing happenned. cant see the batch or payment in GP but the record is there in the database.

Was this reply helpful? Yes No
Victoria Yudin 22,769 on at

Like (0)

Report

Is there anything in the PM10400 table for this payment? Also, can you see what this results in:

select * from PM10200 where VCHRNMBR not in (select CNTRLNUM from PM00400 where CNTRLTYP =1)

Was this reply helpful? Yes No
Ahmed Zaveri 910 on at

Like (0)

Report

there is no data in PM10400, and the query is return the payment record. any idea??

Was this reply helpful? Yes No
Ahmed Zaveri 910 on at

Like (0)

Report

sorry victoria for the last reply, actually the query is returning 4 records but not the payment record which im looking for. please help

Was this reply helpful? Yes No
Victoria Yudin 22,769 on at

Like (0)

Report

Admed,

It's difficult to help with this without seeing the data. Going back to your original question - you say "Now the data is residing in PM10200 and document status is unposted". Can you please post the actual data from PM10200 that led you to say this? As well as the 4 records resulting from my query?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Victoria - six years later, sorry and I'm having a similar problem. Hoping you can help.

There was a hiccup in the system during the application of manual payments to a vendor's invoice.

When I run a Payables Transaction Query for the Vendor the following is observed:

1. The INV record is in "OPEN" status but there's no values in the "Unapplied Amount" column - suggesting that the amount was applied, but not yet POSTED

2. There is no associated PMT record found in the query results - however, if I look in the PM10200 table, I can see a record along with the associated PMT number (00000000000000000693)

We also ran a Trial Balance excluding "Credit Applied but not Posted" - the report shows the invoice as outstanding, i.e. as if no payment was applied.

Mark.

Was this reply helpful? Yes No
Victoria Yudin 22,769 on at

Like (0)

Report

Hi Mark,

Often running check links and then reconcile may help with this. However, usually you will need to fix this directly in the SQL tables. Since there are many tables that might be involved, I hesitate to offer suggestions for fixing this without seeing all the data. You may be better off asking your GP partner for help with this.

Was this reply helpful? Yes No