Error: Cannot create a record in . The record already exists

Hi Amer,

Thanks for your post. Your solution seemed reasonable but a little drastic. I attempted a less involved fix by adding a dummy field to my table, which forced a re-synchronise, then I removed the dummy field (another synchronise). This seemed to have the desired effect, although I should note that we only encountered your error message (also on the LedgerJournalTrans table) occasionally, so the underlying cause may have been slightly different.

Hi Amer,

I would be careful deleting a table like that. When you import a table using the build-in import/export functionality you create new rows in that table. Thereby that rows get new RecId-values.
Now the problem that there are a few tables that references entries in LedgerJournalTrans by RecId but their reference values are not refreshed by that import method. Thats why you should test if you have produced database/reference errors by your ‘fix’.