"This transaction already has been posted" when there is no such transcationin GP

(0) Share

Report

Posted on by Community Member

----------------------------------------------------- ERROR--------------------------------------------------------------------------------------------------------------------------

CRM    1000615584             33IN3211               3/3/2013          A31688                         $0.00           $46,788.60
                  $46,788.60                     $0.00                 $0.00                 $0.00                  $0.00
Payment Information   Checkbook/Card    Payment Number         Document                   Date                   Amount
    Cash                                                                               0/0/0000                   $0.00
    Check                                                                              0/0/0000                   $0.00
    Credit Card       MASTERBILL        999703136              33IN3211                3/3/2013                   $0.00
Distribution Messages:

Work Messages:
This transaction already has been posted.
This transaction contains errors. It won't be posted.

----------------------------------------------------------------------------------------------------------------------------------------------------------

While checking in GP transcations we are unable to locate any tranascation with the specified Document no(invoice no). Please help me with the cause of the issue and solution.

Regards,

Leodwin

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Richard Wheeler 75,852 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

I would start by running Check Links on the Payables Open and History tables. There amy be an orphaned records.

Tools->Mantenance->Check Links->Purchasing highlight these two and click Insert and then OK.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like
a
(1)

Report
Copy link

Link copied!

Yep,

And after you do your Check Links, be sure to run Reconcile. After the reconcile, look in the history tables with Studio Manager and see if the document number is in the table but may be missing the vendor ID.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Richard Wheeler and L Vail . Will check as you suggested

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Richard Wheeler and L Vail . ,

Is there a script /query that i can run againt the DB to find out the orphned records?. Reson is the db is huge and cannot run the checklinks and reconcilation during the production hours and without proper backup.

Thanks,

Leodwin

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Leodwin, there are so many tables when it comes to AP the question becomes where is the orphaned record? Here is what I would try first. Create a backup compnay of your existing data and then go into SSMS. Then run DELETE PM00400 (Payables Key Master) and then run Check Links on the Payables Open and Historical Transactions. This will completely rebuild the key master table which would be my first guess as to where the orphan resides. Then see if you continue to get the message. If this works, then plan a time after your production company's backup to do the same thing in the production company. If you are nit familiar with SQL you can clear the key master table form within GP by going to Maintenance->Clear Data> click on Display then Physical and choose Payables Key Master. Insert that table and click OK

Was this reply helpful? Yes No