how to see data for for deffirent customers with deffirent dunnings

[former_member657893]

Hi

i want to make BI report like this.

how can i see balance for deffirent dunning levels at ECC system

Customer Number (Payer) Description Dunning Level 0 Dunning Level 1 Dunning Level 2 Dunning Level 3 Dunning Level 4 Dunning Level 5 Total Balance

7019706 Carefour 82 38 92 82 17 5 316

8281554 Sheffield Central 22 48 88 57 87 92 394

8256558 Liverpool Ents 65 66 17 26 26 64 264

2920349 The SUA 52 95 40 3 99 98 387

9376822 Bar Central 1 96 43 52 40 66 298

4777091 Bar Local 62 78 0 68 9 79 296

1910859 Café Colombus 93 32 8 53 1 11 198

Total 377 453 288 341 279 415 2153

[Former Member · Accepted solution]

In FBL5n, You need to sub total based on the customer number and dunning level and you will get the data required, however to have the output in the specific format required by you, you need to make the report using this data.

Regards,

Gaurav