1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Bank cash in & out flows

Discussion in 'Oracle Financials' started by RIAZ, May 7, 2009.

  1. RIAZ

    RIAZ Forum Advisor

    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    130
    hi all,
    I am using oracle financial apps 11i. Did any body guide me how to get bank cash in or out flows. for example if i pay some amount then what accounting head debit and which bank account is credit.

    Is there any standard report ?
    OR
    How to route from database tables ?
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    what kind of report are you looking for? are you interested in cash flow per bank account? Isn't the cash flow statement helping?
     
  3. RIAZ

    RIAZ Forum Advisor

    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    130
    I want to track the payment that occur from a BANK against a GL ACCOUNT and in the same way want to know about receivings.

    ACTUAL ACCOUNTING IS AS UNDER
    -------------------------------
    1- Inventory Receiving Time
    Inventory Account - DR
    AP Accrual Account - CR

    2- Invoice Time
    AP Accrual Account - DR
    Supplier Account - CR

    3- Payment Time
    Supplier Account - DR
    Bank Account - CR



    Now I need to know
    ------------------------------
    1- When Bank account credited ?
    2- What Inventory Account hits ?

    I got tables please let me know am i on the right track ???
    - AP_INVOICE_PAYMENTS_ALL & AP_CHECKS_ALL
    - PO_DISTRIBUTIONS_ALL
     
  4. anna575

    anna575 Active Member

    Messages:
    22
    Likes Received:
    1
    Trophy Points:
    90
    Hey, You can follow the rules of Cash outflows. Cash flow is the lifeblood of all businesses. I am also interested in cash flow per bank account. You can use the basic rules of to help you take control of your cash flow. Thanks...