This question has been flagged
11 Replies
14704 Views

Helo,

When i try to do anything with modules of settings i get the error "Constraint Error

The code of the journal must be unique per company !"

Where do i fix this?

Best, Domen

Avatar
Discard

did you make experiments with two or more companies, or have you this problem on fresh installation?

Author

There were two companies and one got deleted: If i try to define jouranls per company there is no company option

If you dont have many data in database then make fresh database and you solve this problem and any other next problems.

Author

I have a lot of data in the db. Any other solution?

Try to make new journals (hope this will make new journals for correct company).

Did you delete other company or just make invisible?

Author

I have created new journals and i can't remove old ones, as they have reference to it. I have deleted the company.

Best Answer

It looks like that you are using more than one company, so you need to define financial journals per company. Accounting or Invoicing / Configuration / Journals / Journals and define journals per company.

Avatar
Discard
Best Answer

I have the same issue and now I know the reason.

I have a custom module which create Journals as module data. I removed that module from the system (but journals were left in the system). And when I try to install this module again system try to insert Journals from that module in the database with the same codes and names as before. That's why you get "The code of the journal must be unique per company !".

As a hack - just rename Journal's names and codes for a while then install your module

Avatar
Discard
Best Answer

I am having this error also when: I try to duplicate a journal with a code entry with 4 character. system try to change the code of the new journal by adding something like (copy) at the end of the code. Since length is limited a unique code cannot be created. As a result I see such an error.

You are getting this error because you are trying to create a new journal with already defined code. If you are duplicating the entry try changing the code first after duplicating revert it back to the original value.

If it is not the code of the journal it is code of the attached sequence or journal entry.

Avatar
Discard
Author Best Answer

I'm using only one company I have only default Journals

Avatar
Discard

This should be converted to a comment, not enough rights to do it