Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Registry in Navision is missing entry No vs Data Dump from journals posted

Posted on by Microsoft Employee

Hi All

I am new on this forum so apologize if this question may have been answered. We provided our auditors a dump of of 6 months data. They also requested a Registry report for the same period, they have identified that there are some discrepancies between both reports in terms of  ranges of entry no jumping in the registry report.

When we query NAV 365 we can see the entries posted but when they reference this to the registry these ranges are missing. Does anyone one know what the cause can be is this an IT Database issue or can this physically be deleted by error on the Registry etc..

Any one shedding a light on this would be very grateful?

Soz

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 45 on at
    RE: Registry in Navision is missing entry No vs Data Dump from journals posted

    You can try to use DB Log if it is maintained or if you can get a backup of DB in back date.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Registry in Navision is missing entry No vs Data Dump from journals posted

    Hi Bilal

    Is there any Audit we can run on SQL Db to find out how they were removed or any report that qualifies this in Navision ?

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 45 on at
    RE: Registry in Navision is missing entry No vs Data Dump from journals posted

    It seems like around 200 entries are removed either through DB or by code.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Registry in Navision is missing entry No vs Data Dump from journals posted

    Hi Bilal

    It's not the GL Register, but Registers in Nav 365 my sequence jumps from 10429984 to 10430147 so i am missing from 10429985 to 10430146 thats what the auditors are questioning why does the register not show this sequence. When i check the entry numbers in Nav the GL postings are there. I am trying to understand why the Register is missing this information is this a known bug or Db issues etc..

    I hope this is a bit clearer 

    pastedimage1606813035590v1.png

    pastedimage1606813403209v2.png

    pastedimage1606813430204v3.png

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 45 on at
    RE: Registry in Navision is missing entry No vs Data Dump from journals posted

    Registers.PNG

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 45 on at
    RE: Registry in Navision is missing entry No vs Data Dump from journals posted

    Hi,

    May be you need G/L registers. You can search for G/L Registers and you can find a report and page as well.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Registry in Navision is missing entry No vs Data Dump from journals posted

    Hello,

    Are you talking about time sheets?

    community.dynamics.com/.../845653

    Thanks.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans