Payables Transaction Inquiry - Vendor in history

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi all,

I am a beginner of GP. I have one questions from my client. She ask me there is a payment in the payables transaction inquiry which she did not pay. However, this payment already turn into history.

This image shows the payment in HIST status.

2015_5F00_03_5F00_20_5F00_12_5F00_46_5F00_25_5F00_123_5F00_Notepad.jpg

However, nothing shows in this historical payment. It was paid with nothing inside!

2015_5F00_03_5F00_20_5F00_12_5F00_43_5F00_10_5F00_Void_5F00_Historical_5F00_Payables_5F00_Transactions_5F00_LSNA_5F00_CB1.LSLP.local_5F00_.jpg

Therefore, I ask my client to void this payment and do it again. She also shows me the payment does not exist in the void historical payables transactions. Then everything looks so weird for me now.

1. Payment is completed with no recorded inside. No one pay it, but it turned in the hist status.

2. Payment is not in the void historical payable transactions. This means we cannot void it.

This payment becomes a ghost for me. I can see it, but cannot touch it. Some screenshot is attached.

Also, I found this payment in the database table PM00400. I tried to change the DCSTATUS to '2' to make this payment open. This is not the solution for me:(

CNTRLNUM CNTRLTYP DCSTATUS DOCTYPE VENDORID DOCNUMBR TRXSORCE CHEKBKID DUEDATE DISCDATE BCHSOURC DOCDATE USERID DEX_ROW_ID
000163539 0 3 1 SNO001A 14881-1 PMTRX00005947 2014-11-20 00:00:00.000 1900-01-01 00:00:00.000 PM_Trxent 2014-10-21 00:00:00.000 HermonZ 233496

I am not an expert in GP. Therefore, I don't want to delete this record and get everything mess up. Can anyone help me out and explain how I can fix this issue?

Thanks,

Ming

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Payables Transaction Inquiry - Vendor in history

Hi Sue Conrod,

I just finished the first step you told me, but I am not sure am I doing in the right way since I am petty new at this system.

I tried the first time. It prints 0 record.

Second time, I am not sure if I should continue or not.

Third time, I don't know what I should put here.

If I am not doing it right, please point out.

Thanks,

Ming
Suggested answer

sueconrod 335 on at

Like (0)

Report

RE: Payables Transaction Inquiry - Vendor in history

1. Do not go in and delete or change anything in SQL unless you are doing it in a test company.

2. Run Utilities>>Reconcile for Purchasing against the Fiscal and Calendar Year and batches for all vendors. If that doesn't bring up the missing trx go to next step

3. go to Tools>>Maintenance>>Checklinks>>Purchasing as the series and run checklinks against the Payables Trx Logical, Payable History logical and the Payables Vendor Master logical.

See if that brings up the full trx.

Also, I would be checking my posting setups and make sure that everything is being posted.

if a check might have been cut go to Trx>>Financial>>checkbook register and look for the check.