Skip to main content

Notifications

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

Analysis View table 365 not showing the Entry No when exported

Posted on by 240

Good morning

I've noticed that if I use a configuration package on table 365 where I have all the possible fields ticked, the Entry Number field in Excel is showing a zero.    I have previous exports of data where that field did have the entry number.   I have deleted and re-created my Analysis View definition but still the entry number is zero.

Has anyone else come across this please?

Thank you

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Analysis View table 365 not showing the Entry No when exported

    Great work and again good catch!

  • Marmeduke8 Profile Picture
    Marmeduke8 240 on at
    RE: Analysis View table 365 not showing the Entry No when exported

    Hello Marco

    I just kept at it as it did not make sense to me and so I tried various options and then saw that the difference in the compression choice brought back different results.

    Regards

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Analysis View table 365 not showing the Entry No when exported

    Hello,

    Great work, that is good to know. How did you figure that out? I don't recall that to be listed in our docs.

    Thanks.

  • Marmeduke8 Profile Picture
    Marmeduke8 240 on at
    RE: Analysis View table 365 not showing the Entry No when exported

    Hello Marco

    I have done further testing on this and I've discovered that if the Date Compression is set to "none" then an entry number is visible in the table.  

    That closes this topic

    Thank you for your time.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Analysis View table 365 not showing the Entry No when exported

    Hello,

    If you have a repro in Dynamics NAV 2015 where entry numbers are not "0" while this is now changed to "0", then feel free to raise it as an issue and we will look into it.

    Thanks.

  • Marmeduke8 Profile Picture
    Marmeduke8 240 on at
    RE: Analysis View table 365 not showing the Entry No when exported

    Good morning Marco

    That is happening to me now, but I have earlier extracts from Nav 2015 where the entry number in the 365 table was the same as the entry number in the General Ledger Entries table.

    I'm wondering if something has been changed in this recent version of BC where the entry number is now being reflected as zero.

    That is what I'm trying to establish.

    Thank you

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Analysis View table 365 not showing the Entry No when exported

    Hello,

    When I generate records in that table, the source for entry number are also all "0". Export via rapid start will also show zeros.

    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,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans