XL-Reporter - Evaluation of bookings in journal

[Former Member]

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]

Some additional information on my problem.

I have added the dimension 'Original Document' (TTY) to the row selection to specify which documents is the basis for the journal entry, but the effect is that I get the codes and names of the selected business partners but no values.

Now the selection is

row expansion selection:

BPA(CardCode = xxxxx:yyyyy)

ACC(AcctCode = 8500)

TTY(Code = "APCreditMemo","JournalEntry")

Group By BPA.CardCode

Regards,

Frank Romeni

[Former Member]

After a webex session with SAP Support we could realise that there are no errors in the logic of the report definition - the report, running on the support-server, produced correct values.

Currently we are searching for the reason of this erroneous behaviour - but it can't be solved here, because there are no errors in the logic of the report definition! Hence I'll close this thread.

Frank Romeni