Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

XL-Reporter - Evaluation of bookings in journal

Hello everybody,

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!

Regards,

Frank Romeni

Former Member
Not what you were looking for? View more on this topic or Ask a question