Hi,
I was having trouble getting the lines to have full gl ledger (dims concatenated), or column for each of the segments that displays the period totals for that gl segment combination.
Has anyone does this?
Tina
Example would be
segm 1 segm 2 segm 3 segm 4 segm 5 value
XXX 100 101 9999 100000 10
XXX 120 101 9999 100000 30
XXX 100 101 9999 100001 200
.
if you find a way i would also be interested. Unlit now I found only "partially working solution"
My latest result is that i prepared a report in RGS600 using the balance key that contains all required dimensions, then I run the report (this generates a file in table FFRPCI and I created a report in AHS110 to read from that table.
The result is ok.. not perfect but working.
How did you set up rows/columns/cells in RGS600? (what were the 4 different recorded amounts)? I was having trouble getting a column with all the segments.
in the columns i used the periods and in the lines the accounts.
I use a balance key similar to 8 were all the dimension I need are included.
I run the report, this creates data in RGS200 and then i read the data in the FFRPCI table to see the details. Would you like to have a Teams call together? I can show my settings maybe it gives a good idea for your report.
you can send me an invite at elisabetta.venezia@pfaudler.com
