Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Sales Analysis report. where the data comes from?

(0) ShareShare
ReportReport
Posted on by

I have this developed funcionality which deletes all posts in the system, item ledger entries, chart of accounts etc get blanked up. Nevertheless after pressing this button and deleting all posts , when I go to Sales analysis Report it actually gives me a "proper" report as if nothing had been deleted, so I wonder, where the Analysis report pulls out the data from then?

*This post is locked for comments

  • Suggested answer
    dkatson Profile Picture
    2,263 on at
    RE: Sales Analysis report. where the data comes from?

    Why? If the case is preparing new company from existing one, by copy existing and delete of posted data, than this tables should be deleted also.

  • Suggested answer
    Maneesha Profile Picture
    5,891 on at
    RE: Sales Analysis report. where the data comes from?

    Dmitry Katson , you are mentioning very sensitive data tables to delete , there is no need of those to delete  

  • Verified answer
    dkatson Profile Picture
    2,263 on at
    RE: Sales Analysis report. where the data comes from?

    Don't forget to delete Analysis view entry, and also dont forget to delete 480, 481, 5804, 6508, 5811.

    This are tables that usually forget to delete.

    And don't forget to delete "Last used No." in No. Series =)

  • Suggested answer
    Amol Salvi Profile Picture
    18,698 on at
    RE: Sales Analysis report. where the data comes from?

    Check whehter you have deleted data from Analysis view entry table and othere related tables

  • Suggested answer
    Maneesha Profile Picture
    5,891 on at
    RE: Sales Analysis report. where the data comes from?

    your developed function missed to delete Analysis tables

  • Verified answer
    Suresh Kulla Profile Picture
    47,789 on at
    RE: Sales Analysis report. where the data comes from?

    It will retrieve the data fromt Analysis Line and other Analysis tables which are in range 7111..7156

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Liquid error: parsing "/globalsearch/?q=ikilt++pv+plant" - Nested quantifier +.