DOWNLOAD LIST OF CASH ACCOUNT BY CC

[Former Member]

how to Download list of all cash accounts by company code and include currency and current balance?

how to take cash account. is it GL account account? if so how to take like the above requirement

[Former Member · Accepted solution]

Hi Laxmi,

Yes. Cash Account is a GL Account. You can see all Cash Gl Account for your Company code in T-Code FBCJC0.table TCJ_C_Journals. From this table you will get the list of all Cash GL Accounts maintained for your company code and the currency they are maintained in.

Secondly, to know the balance as on date for all cash journals, you can also go to FBL3N or FS10N to see the balance as on date or alternatively, you can go to table TCJ_Balance to display the balance for all cash journals in a company code. In this table, the Record Type "C" is for Checks.

Hope this helps.

Regards,

SAPFICO

[Former Member · Accepted solution]

my doubt is that my user asked to download list of cash account by company code and include currency and current balance. if i press f4 and find out giving cash it is bringing all gl account which has mentioned text as cash in gl master.

is it correct or we need to select bank account also. how to identify the cash account in sap. or what ever account involves in cash journal that alone we need to take? please suggest

[Former Member · Accepted solution]

Hi Laxmi,

In my previous reply, I have addressed all your Queries

1) Go to table TCJ_C_Journals, enter your company code and in here you get a list of all GL Accounts against your cash Journals and the Currency.

Do not include Bank Accounts, if you need the current balance of cash Accounts only.

2) Next, Go to table TCJ_Balance, and enter your company code, to get balance fo cash Accounts.

Hope it clarifies..

Regards,

SAPFICO

[Former Member]

Hi There,

I wonder if the instance does not activate cash journal that table TCJ_C_JOURNALS will not give you the correct answer.

Normally there will only have limited cash account in one Chart of Accounts, why not ask the requester which cash accounts are wanted, then just use Tcode FBL3N will solve your problem.

thanks,

Ken

[Former Member]

Dear laxmisathyanarayana ,

You can use FBL3N and choose multiple selection and give all the cash account and execute.

Otherwise you can use the S_ALR_87012309.