I am trying to get count of unique Document No that are grouped by Document Type and Journal Batch Name fields. Currently i can display these fields directly and it shows document no.
This is what i am expecting
| Document Type |
Journal Batch Name |
Document Count |
|
Default |
1
|
| Invoice |
TestEntry April |
5 |
| Payment |
Test |
2 |
I tried to Querying Gen. Journal Line and provided method sum but got this result
| Document Type |
Journal Batch Name |
Document Count |
|
Default |
8 |
| Invoice |
TestEntry April |
8 |
| Payment |
Test |
8
|
| Payment |
Default |
8
|
| Invoice |
Test |
8
|
| Invoice |
Default |
8
|
Please let me know how i can get count of document numbers with Groupby on Document Type and Journal Batch Name
Regards
