Thursday, November 11, 2010

Cash Flow Statement

depends on your format of cash flow. You have to obtain a cash flow format and work accordingly to include the relevant GL accounts. I have given a sample format.

Operating Profit before Depreciation
Add (Less): Decrease / (Increase) in Working Capital
(Increase) / Decrease in Debtors
(Increase) / Decrease in Inventory
(Increase) / Decrease in Loans & Advances
Increase / (Decrease) in Creditors & Provisions
Less: (Capital Expenditure)
Net Cash generated from operations
Add: Opening Balance of Cash & Cash Equivalents
Less: Closing Balance of Cash & Cash Equivalents.

The BI Business Content for the application Accounting for Financial Instruments contains a process that can be used to display and merge the data from the Bank Analyzer subledger and general ledger. This enables you to meet the requirements of IFRS, country-specific reporting requirements, and your bank's own reporting requirements regarding financial instruments.

SD flow basically has ORDER TO CASH flow

Customer comes to Business for Inquiry of a material with cost and Delivery & Payment terms
Business will raise a Quotation with reference to Inquiry and send to Business, if customer agrees then ,
Customer Places a Purchase order ( which is an external document like phone call or fax) for some material to the company and we will generate an order against the Purchase order
Delivers the goods to the customer
Bills the customer

The Amount will be posted to respective GL accounts

This is the Main flow and in between there are many integrations with other Modules like MM, FI, PP
So first get familiarize with the SD stuff and then you can learn the Integration.

You have to know the functionality of each field , then it will be easy to understand the End to End flow.

load master data of SD, MM , HR and FI-CO from R/3
Step 1: Activate the Master Data Data Source in R/3 using RSA5 transaction.
Step 2: Replicate the Data Source to BI.
Step 3: Craete Transformation using the above data source.(Before this step make sure that your InfoObject is in the InfoProvider menu as a data target. If not make this. To do this go to the InfoArea under which you wnated this InfoObject, Right Click and Insert Characteristic as InfoProvider)
Step 5: Create DTP.
Step 6: Create InfoPackage and load the data upto PSA.
Step 7: Then run the DTP and load to the InfoObject.

Then activating and attribute change run are commonly...
SD Data Sources:
Document Header: 2LIS_11_VAHDR
Document Item: 2LIS_11_VAITM
Document Condition: 2LIS_11_VAKON
Document Schedule Line: 2LIS_11_VASCL
Document Item Allocation: 2LIS_11_V_ITM
Allocation Schedule Line: 2LIS_11_SCL
Order Delivery: 2LIS_11_SSL.

MM Data Sources:
Goods Movements: 2LIS_03_BF
Stock Revaulations: 2LIS_03_UM.

The preconfigured Financial Data Mart scenario contains the following objects:
  • Extractors
    Transfer of aggregated transaction data from the Analytics Layer of the Bank Analyzer subledger
  • Preconfigured data model that contains the following objects:
    • Three DataStore objects
      Extraction targets for the data from the Bank Analyzer subledger and general ledger
    • Six InfoCubes
      Balance sheet, income statement, ERP GL, Financial Data Mart, and three virtual providers
    • Process chains
    • Queries
      Balance sheet, income statement, and notes
The data from the Bank Analyzer subledger adn general ledger are reconciled using a rule-based logic defined in the transformations. This ensures that the level of detail used in the subledger is retained, and that none of the amounts that exist in both sources are duplicated in reporting.

1 comment:

  1. Hello all,

    In financial accounting, a cash flow statement is also known as statement of cash flows or funds flow statement, that shows how changes in balance sheet accounts and income affect cash and cash equivalents and breaks the analysis down to operating, investing and financing activities. Thanks a lot!

    Extract Data From Web