Cash Book.

[Former Member]

Hi Experts,

In FICO we have cash journal FBCJ. In FICA we have FPCJ.

Can anyone suggest, in IMG shall we give same cash A/c GL in both FICA & FICO. Our expectation is in B/S we will get cash balance amount of both in same GL.

If we are giving same GL can we get the daily cash book of both fica & fico in one TCODE.

1. Can we give the same GL a/c for both?.

2. if we are giving same gl a/c will it possible to see the transactions of fica in FBCJ.

Please correct me if i am wrong.

Thanks

RAM.

[Former Member · Accepted solution]

Hi

1. You can have the same G/L account for both FI and FICA cash desks.

2. No. FICA uses different tables. You can develop something, but I don't know any standard way of getting information from FICA cash desks to FI cash desks.

Hope this helps,

Bogdan

[Former Member]

Very Very useful

[Former Member]

Hello,

I understand that your requirement is from the business to view the GL Acc balances in FICA!!!

Unfortunately, SAP does not provide any report in FICA to view GL Balances :(...however if you want to see the balances in FICA itself, you can pull the data from the table DFKKOPK using a query....

Anyhow coming to your query, as you are aware FICA is only a Sub-ledger...while transferring the data from FICA to FICO, you get only the consolidated list of the documents as the docs are transferred per Reconciliation Key....

How ever there is a workaround for this. If the user selects the Check box 'Separete GL Item' <this is available in FPE1.Hopefully this should be available in FPCJ too>...then items to FIGL are transferred on 1:1 basis contrary to 1:many basis. Hope this is clear. But do remember that you'd be flooding your FI-GL with loads of documents which is not advisable.

In summary here are the answers to your questions:

1. Can we give the same GL a/c for both?.

Yes! you can give...but that does not automatically qualify your requirement as docs from FICA are tr to FIGL per recon key and a recon key obviously contains 'n' number of documents. You need to go for the above work around or else you have to close recon key immediately after each and every FPCJ doc!!! <not sure one day you may run out of Recon keys!!!:)>.

2. if we are giving same gl a/c will it possible to see the transactions of fica in FBCJ.

Yes of course provided you tr data to FI-GL from FICA on 1:1 basis as mentioned above.

I hope this is clear and useful...

Rgds

Rajendra

Any points would be motivating