Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Look up a journal table

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi, I have a bespoke system that has a corruption within on of its journals so we are unable to post it to the ledger. I have indentified the bespoke table name where the information is being held but how do you or can you bring up a this table complete with all the data so I can look through the info see where the issue is? The error im trying to investigate is a entry line number already exsists so the number sequence is out of align.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Look up a journal table

    Error message says "the job journal line already exists. Indentification fields  and values: journal template name='job, journal batch name='time',line no=40000"

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,749 on at
    RE: Look up a journal table

    Hello, You can bring up the table by using the development environment and by running the table from there, but don't modify the table directly, you can verify the data but never modify/delete/insert.  Regarding your error it could be a setup issue , send us the screenshot and we can help you identify the issue.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Look up a journal table

    As Alex suggested Kindly paste screenshot for error so it will helpful to check

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Look up a journal table

    Hi Alex correct its just when I'm trying to post them entering them is fine, it's the time sheet system of Nav and yes it's been developed from the standard system, it's been working fine for 2 years.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Look up a journal table

    This would be more helpful if you kindly post the screenshot with the error you are facing. There might be different reasons for that error, e.g. number of series mismatch.  Do I understand correctly that you are facing this error while posting the journal, but not while entering new lines?

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Look up a journal table

    Is this Navision or any add on develop on Navision?

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans