Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Unanswered

The Item Journal Line already exists. Identification fields and values: Journal Template Name='PROD. ORDE',Journal Batch Name='CRONUSGRO',Line No.='-2147477296'

Posted on by 20

Microsoft Dynamics NAV

---------------------------

The Item Journal Line already exists. Identification fields and values: Journal Template Name='PROD. ORDE',Journal Batch Name='CRONUSGRO',Line No.='-2147477296'

---------------------------

OK

 

You may encounter this error when you try to open production Journal via released production order.

The major reason is number of data recoded for INT variable has exceeded. When user open production journal the system automatically creates temporary item journal lines. This has been generated via user ID & depend on the domain name. According to code unit 5510-Production journal Mgmt the following code will retrieve first ten characters from user ID.

ToBatchName := DELCHR(COPYSTR(User,1,MAXSTRLEN(ItemJnlLine."Journal Batch Name")),'>','0123456789');

When user opening production journal page the production journal batch is inherited by the usernames and it comprises of first 10 digits of the username. if company domain name longer than 10 characters irrespective of the username. All user’s id will refer same production journal batch, and this will affect to overflow this variable & error message appeared as above.

We have added additional code line & update toBatchName variable to create unique journal line user ID wise. Then temporary journal line will create user ID wise.

 

ToBatchName := COPYSTR(User,14,MAXSTRLEN(ItemJnlLine."Journal Batch Name"));

 

Further reference: -

https://en.wikipedia.org/wiki/Integer_(computer_science)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans