Fixed Assets Revise Unposted Entries - Error: Duplicate Keys Not Allowed

[123ecmd]

We did a journal entry to assign cost to new assets. When we tried to post the entries in the revise unposted entries program we received an error saying the posting account was invalid. The journal entry was voided and re-entered. The second entry posted correctly. However, the first entry (that was voided) will not allow us to pass. When we try to pass on the entries we receive the error message: Duplicate Keys Not Allowed. Does anyone have a suggestion as to how we can pass or delete these entries? Thanks in advance for your help!

 

[samir0075]

We did a journal entry to assign cost to new assets. When we tried to post the entries in the revise unposted entries program we received an error saying the posting account was invalid. The journal entry was voided and re-entered. The second entry posted correctly. However, the first entry (that was voided) will not allow us to pass. When we try to pass on the entries we receive the error message: Duplicate Keys Not Allowed. Does anyone have a suggestion as to how we can pass or delete these entries? Thanks in advance for your help!

Cannot confirm how to Pass the entries without more details , but yes , if you want to delete the entry ,using backend query/sql, just delete the original journal along with the void from F0911 and then repost the balances in GL for the account ID /Batch.
Also assuming there is no impact on FA balance ( F1202 ) as the original journal was not posted to FA because of the error.
Run the GL to FA integrity report to make sure there are no issue.

 

[dschleicher]

Cannot confirm how to Pass the entries without more details , but yes , if you want to delete the entry ,using backend query/sql, just delete the original journal along with the void from F0911 and then repost the balances in GL for the account ID /Batch.
Also assuming there is no impact on FA balance ( F1202 ) as the original journal was not posted to FA because of the error.
Run the GL to FA integrity report to make sure there are no issue.

I've never seen that error come up "Duplicate Keys Not Allowed" when Passing entries in Revise Unposted Entries. However, if you are going to SQL anything, I would maybe recommend just putting "P" into the GLBRE field instead of deleting the F0911 records.

 

[123ecmd]

Thank you for your responses. We will try to put a "P" in the GLBRE field.