Share
Report
702We are using ver 9.0. A single invoice in a payables batch was posted . The
batch did not appear to post and said go to batch recovery. In batch
recovery the status showed as Posting Interrupted and said "A save operation
on table "PM_Transaction_Open' has created a duplicate key ". Running batch
recovery did not work. Check links was then run and then when batch recovery
was run a Payables Transaction Posting Journal was automatically printed.
The posting journal says "This transaction already has been posted. This
transaction contains errors. It won't be posted " The transaction appears to
be correct and the proper entries have been posted to the GL and the AP
Vendor.
The batch could not be deleted or posted. Eventually we tried to edit the
batch by changing the invoice # and the amount of the transaction to 0. When
this was done the batch could then be posted.
Now however when you do an inquiry on the vendor it gives an error "The stored procedure
createSQLTmpTable returned the following results: DBMS: 2627, Great Plains 0.
Any suggestions as to what should be done next ??
*This post is locked for comments
I have the same question (2)
All responses (
Answers (
