Share
ReportPurchasing Module: A manual payment chk. # 5498 was entered in GP and applied to an outstanding invoice # 2553 to pay it in full. When navigating to the vendor’s inquiry screen, an error message was received – ‘The stored procedure creatSQLTmpTable returned the following results: DBMS: 2627, Microsoft Dynamics GP: 0.‘ The inquiry screen displayed only 2 open trx and no historical trx. Invoice # 2553 showed as open. I ran check links on the Payables History Logical Files and Payables Transaction Logical Files and reconciled the vendor. Check links generated a message ‘Microsoft SQL Native client SQL Server violation of PRIMARY Key constraint ‘PKPM30200’ Cannot insert duplicate key in object dbo.PM30200'. The DBMS message was resolved. The invoice #2553 moved to history and all the history transactions show in vendor inquiry. The payment date on the Payables Apply Zoom screen shows 0/0/0000. The invoice doc date is 12/3/14. The invoice posting date is 12/12/14 (date is from batch).
Upon further investigation, table PM30300 showed DOCDATE and DATE1 = 12/03/6201 for the payment voucher. The date was corrected to 12/3/2014 via SQL. When drilling down on the journal entry for check # 5497 in the same checkbook, an error message was received – ‘Unhandled script exception: Index 0 of array “Pm Transaction Abbreviation’ is out of range in ‘Script_Transaction_Inquiry_Scroll_FILL’. Script terminated.’ Check links and reconcile was run for the payable logical files as well as the CM trx file. No errors were reported. The "unhandled script.... ' message was not resolved and the payment still does not have the correct date on the Payables Apply Zoom screen – it shows 0/0/0000. Check # 5498 does not show in the check register nor does the transaction show in GL. The trx does not show in PM30200. The check is not available to be voided via GP. The date was changed 12/26/2014 via SQL so it was later then the invoice posting date. Check Links and reconcile did not generate any errors or changes.
Next step taken was to delete PM00400 and regenerate it by running check links and reconcile – no errors were reported. Drilling down on check # 5497 no longer generates the 'Unhandled script exception....' error. A comparison of tables impacted for check # 5497 and # 5498 shows that #5497 is present in CM20100, CM20200, PM00400, PM20100, PM30200, PM30300 and PM80500. Check # 5498 is present in table PM30300 and PM00400.
Next the TRX was removed from PM30200. Check links and reconcile did not populate the tables. The record was reinserted.
What else can I do to resolve this payment?
Thank you very much for your help.
Marty
*This post is locked for comments
All responses (
Answers (
291,711
