on 05-07-2013 2:10 PM
Hi to all,
Here I have a Question how to find GL a/c's not yet posted in SAP?
EX:-
In our Company we have 2000 GL a/c's total created in that we are using 1800 GL's (postings were happened),
Now the remain 200 GL's we didn't use yet (postings were not happened) so that we want to Block,how to find these
GL's and is there any way to see these 200 GL's in one screen is there any T.Code for this.
Checking line items for a particular GL (or) GL a/c's from 2 to we can check using of these T.codes: FBL3N,FAGLL03.
It displays what are all the account's got posted,but I want to see rest of the GL a/c's not yet posted.
After finding the GL's we can block the GL's with the help of ABAPER creating program we can run Batch input.
Thanks in advance.
Thanks & Regards,
anilkumar.k
Hi,
To block the accounts you don't need an ABAPer: you can do mass maintenance of the accounts in question OB_GLACC12 (or OB_GLACC11 if it's on the level of CoA). In order to find the accounts where no postings were made, extract the data from FAGLFLEXT (or whatever totals table that you use under New G/L; if you are with classical G/L, then use GLT0 table) and compare the accounts mentioned there with the content of SKB1 table. You can do it either with Excel report or via ABAP report/query: whatever you like.
Regards,
Eli
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
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.