XL-Reporter - Evaluation of bookings in journal
I'm working with SAP B0 SP01 PL29 and XLR PL29.
I specify my reports with the Advanced Report Builder.
I want to evaluate the journal to display the bookings per month of selected BusinessPartners and accounts.
My first idea was to specify:
1. column expansion selection:
PER(Code = 200701:200712) and
2. row expansion selection:
BPA(CardCode = xxxxx:yyyyy)
ACC(AcctCode = 8500)
Group By BPA.CardCode
with the main attribute for the values =ixGet("Amount").
Here I got only 0 values! The reason is apparently that amount here means only
the accumulated sum of all values booked on the account for the selected month.
And on this level we have no correlation to single BusinessPartners, so the
combination of BP and this sum over the month never matches and the result is 0!
After I deleted the BPA specification from the selection I got values. But only the
(already mentioned) sum over the month.
How can I realise what I have specified above (selected accounts, here 8500) and selected BP?
Thank you all in advance for any help!