Sales Analysis report. where the data comes from?

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

your developed function missed to delete Analysis tables

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

dkatson 2,263 on at

Like (0)

Report

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 =)

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

dkatson 2,263 on at

Like (1)

Report

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.

Was this reply helpful? Yes No