Gross Profit Margin KPI Detail - Business Analyzer - What tables feed this report?

(0) Share

Report

Posted on by Community Member

Can anyone please tell me the tables and calculations used to generate this graph. Client has been using it for a few years but a few weeks ago it went nuts. I am trying to trouble shoot the cause but not having any luck. Sales Reports - Analysis and History that show Profit % and dollars look normal.

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

Nasha, I suggest you to use Profile Scripts and Sql server profiler while running the KPI. By using them you may get the table details.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

The answer to this question is GL Categories - it is not directly tables. I opened a ticket with Microsoft and as soon as he mentioned categories it was simple to see the problem.

Was this reply helpful? Yes No