'Document Number Already Exists' When Trying to Import Bank One Transactions Into Payables Management

Issue


'Document Number Already Exists' occurs when trying to import Bank One transactions into Payable MAnagement.


Potential Cause


The PM00400 (PM Keys) table still had records in it for the vendor with the Document Number set to the financial transaction ID from OCM. There are 2 records created in PM Keys for each transaction, one for the transaction and one for the credit card receipt. When a batch is deleted, the PM Keys records for the transactions are deleted, but the records for the credit card receipt/payment are not deleted.


Resolution

These records must be deleted from the table before attempting to import the same transactions again to Payables. Running Check Links on the Payables Transaction Logical file fixes the problem. This appears to be in Release 6 only and the problem does not occur in Release 7.

This article was TechKnowledge Document ID:27782

TechKnowledge Content

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×