Skip to Content
0
Jul 13, 2010 at 10:04 AM

how to see data for for deffirent customers with deffirent dunnings

15 Views

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