Monthly GL balances Query

[Former Member]

I am working on a query to retrieve GL balances for the month the query is run.

This should include the company code, GL account, GL text, year, period, GL balance for the corresponding period and currency. The should be capable of getting upto date balances of the month selected. Even if run on the specific day of a month should provide with the total balances from the beginning of the month until that day. Only one month should be displayed at a time. My Question is how to get the balances for each month What tables should I use etc,

for example

abcd 12000 bank account 2007 03 12125.00 USD

Any clarification is appreciated.

Thanks

krishna

[Former Member]

Hi,

Use the tables:

<b>skc1a,skc1c, rf42b</b>

and a standard inlude:

<b>RFBALANCEDATA</b>

Regards,

Pankaj

[Former Member]

What do you mean by a standard inlude and how should I get that. Could you please explain in detail. I am a Functional developer, hence need more info on that.

Thank you

krishna

[Former Member]

hi,

Its an include, If you are functional guy,it wont be of any help for you.It contains coding.

[Former Member]

Check table GLPCT.

Rob

[Former Member]

close thread