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
This question has been flagged
11
Replies
20339
डेटा देखने का तरीका
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.
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
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.
I'm using only one company I have only default Journals
This should be converted to a comment, not enough rights to do it
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
साइन अप करें| Related Posts | Replies | डेटा देखने का तरीका | ऐक्टिविटी | |
|---|---|---|---|---|
|
2
जून 22
|
5056 | ||
|
0
मार्च 15
|
5643 | ||
|
1
दिस॰ 23
|
27657 | ||
|
1
मार्च 15
|
7021 | ||
|
journal voucher approval
Solved
|
|
2
अप्रैल 26
|
2921 |
did you make experiments with two or more companies, or have you this problem on fresh installation?
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.
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?
I have created new journals and i can't remove old ones, as they have reference to it. I have deleted the company.