Skip to Content

how to know document posted through cash journal - FBCJ

Hi All,

Could you please guide me how to know documents number posted through FBCJ (cash journal). I mean after posting in FBCJ, where we can view the documents which have been posted.

Regards

Deepak

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Aug 05, 2013 at 03:27 PM

    Hi .

    You can view the FI document that was posted via FBCJ froim transaction FBCJ itsself.

    Select one line (representing an incoming payment or outgoing payment ) and than click button "Follow-on document".

    Or you can go in se16 for table bkpf and filter by company code and bukrs-tcode=fbcj.

    Or you can go in spro ---> Financial Accounting ---> Bank Accounting ---> Business transactions ---> Cash Journal ---> Set up Cash Journal and you'll find out which GL account is posted through fbcj and what document types are used for posting from fbcj.

    You can use these information in different reports to filter for a list of documents posted via fbcj.

    I hope this helps.

    Let me know how it goes.

    Makkie

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Makkie,

      thanks for your reply. There is a concept of "Document Split" in cash journal itself. Could you please explain something on this - configuration part & how to use this.

      Regards

      Deepak

  • Aug 05, 2013 at 04:14 PM

    Hi Deepak,

    FI Cash Journals Document Following viz 

    1. Select One Line Item and Click Follow on document

    2. Directly go Table Level

    A.  TCJ_DOCUMENTS  

    B. TCJ_C_JOURNALS

    C. TCJ_BALANCE

    D. TCJ_POSITIONS

    3. Document Type - Cash Journals Document Type CK and SK

    4. Cash Journals GL Account

    Thanks

    Muthu


    Add comment
    10|10000 characters needed characters exceeded

  • Aug 06, 2013 at 10:27 AM

    Hi Deepak,

    Its Possible to Post Document Split in FBCJ.

    Select Business Transaction and Select split option in FBCJ

    Example:

    Exp A  500

    Exp B 500

    Exp C  1000

    Cash 2000 cr

    Thanks

    Muthu

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 06, 2013 at 10:51 AM

    Hi Deepak,

    Transaction code FBCJ update in all posted documents ,which same would get from header of every document. If you want list of documents,use FB03 > Click on Document list > Enter Company code > Fiscal year > Posting date > Click on Dynamic selection > Enter transaction code as FBCJ & Execute.

    All list of documents were posted through FBCJ.

    About splitting :- You can split your invoice as mentioned.

    There is one stationary invoice with respect several cost center's > If total amount is INR 4500.00

    Respective cost center wise :- 101 CC........3000.00 102 CC......1000.00 103 CC......500.00 > Enter Amount INR 4500.00 > Click on split >so you can get one additional tab where you have to enter expenses with respect cost center. With in single FI document ,you can get 3 expenses line items and respective cash posting.

    Regards

    Mani


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 06, 2013 at 11:38 AM

    Hi Deepak

    In document list display, change layout by selecting view transaction code.

    Here set filter for FBCJ

    Regards

    Nakul

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 07, 2013 at 08:22 AM

    Check this transaction codeĀ  S_P6B_12000118

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 07, 2013 at 10:45 AM

    Hi Deepak,

    You can check all the FI document posted by transaction FBCJ in table BKPF. Enter the value FBCJ in BKPF-TCODE field for the co. code and year you want to check the documents.

    Additionally, Table TCJ_DOCUMENTS (Cash journal documents header data) contains all the cash journal documents header data information and TCJ_POSITIONS contains line item information. Table TCJ_BALANCE contains the Total records. YOu can see all the Cash journal related tables by giving TCJ* in t. code SE16

    Regards

    Amitash

    Add comment
    10|10000 characters needed characters exceeded