Hi,
I want to generate sales for the month for each Business area in Jet report. Business Area is department for us. I can view business area dimension through GL dimension overview tab in Navision.
Please help how do i generate jet report by using Business Area.
Thanks,
Hello.
There are various ways to design such a report (e.g., one Excel worksheet per business group - using the NL(Sheets) function, a grouping report, etc.).
Here is an example of a sample Grouping Report.
I start out by listing my Business Group Codes, then use the Sales Header table to list the various document types and the sum for each document type, and finally list some other information (whatever that might be).
I've used the NL("Rows=4") technique to group multiple rows together. This is a really useful reporting method.
(you may need to view the image in a separate browser tab to see it easier)
When I run the report, I get something that looks like this:
Note: for this to deliver data that is actually useful, I would need to include a date range filter to my functions. I left that out of this example just to keep things simple.
I hope that points you in the right direction.
