RE: Bank Account Ledger Entry already exists
Hello DebKumar,
Technically speaking, "Document No." field is not a primary key in table "Bank Account Ledger Entry" which means there can be multiple entry with the same Document No. Which also makes sense from a business perspective. In your case there were three bank transaction posted for the same document no.
Diagnosis:
Coming to your main issue of Posting error:, It seems like someone posted a manual payment & used that #? or someone manually deleting records from Bank Account Ledger Entry (271) table.
Solution:
Delete the record from other related tables associated with the same entry no. .
Check the records in Tables
- Detailed Vendor Ledg. Entry (380)
- Vendor Ledger Entry (25) & also
- G/L Entry (17)
Note: If you have technical skills, try turning on Debugger from development environment, it will take you to the root issue.