R119 Customer Sales List by country

CrunchCrunch Member Posts: 38
edited 2013-02-26 in NAV Three Tier
This is both for Classic and RTC and also for both R119 Customer Sales List and R309 Purchase List.
I'm starting on R119 in Classic.

I need to group and show amounts by country besides the total already on the report.
On Customer dataitem I changed key in tableview to Country.
Since the amount is summed up only at the end of the report, I'm unsure how to get the totals printed for each country.
I considered an extra variable to add to the line
CurrReport.CREATETOTALS(AmtSalesLCY);
However I'm unsure how to make it show ouput in the report only for each group of customers by each country.

Sorry if this seems extraordinaryly simple.

Answers

  • CrunchCrunch Member Posts: 38
    It actually did work with a grouptotal and a groupfooter the second time around I tried it. It's unknown to me, why it didn't work the first time around.
Sign In or Register to comment.