on 07-12-2007 4:01 PM
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 detailed solution is highly appreciated.
Thanks
krishna
GLT0 table has its period column always showing 16. You may access BSIS for open items and BSAS for cleared items to reach daywise transaction, where you can subtotal.You may need Developers help in bringing both these tables data together, if you want in one report.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Krishna,
Is your questioned answered, if so please mark thread as answered.
Have you any further questions on the topic?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can find out the balance of an account per month/period using T Code FS10N.
Hope that helps...
Thanks,
Nandita
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.