Opening Balance an closing balance

10-11  Source: Network gathering  Views:2 

Advertisement
Hi Gurus,
Please consider the following
1. Closing Balance for month of February  is the opening balance fro March
2. The closing balance is calculated in BW during execution of the report
2. How do i show the February closing balance as the opening balance for the month of March in the same report
Your help highly appreciated
TQ
BR
BR
Hi,
As per my understand you have IOBJ " Closing Balance" this value is populating at teh time of query execution.
Then create a Form,ula (Put the Description as Opening Balance).In the Formula screen put the IOBJ " Closing Balance"
Means Opening Balance = Closing Balance.So u routput diplays closing and oprning.
Back end executionn :
1.  First It will calculates the closing balnace (Already you will mainatian this IOBJ in your query structure) while diplaying it will displays the value in two columns for Closing and Opening(Formula that we have created in Query).
Try the above i think its definetly works.If not let me know
Regards
RAM.
Edited by: Ramakanth Deepak Gandepalli on Dec 22, 2009 10:54 AM
Related articles
  • Opening Balances and Closing Balance of customer 10-11

    Hi, Does SAP provide any standard customer account statement for Opening Balances and Closing Balance for specific date range have given in selection screen? The statement also contains reference number, order, and Delivery number. Note: FBL5N Transa

  • Opening Balance and closing balance 10-11

    Dear All,              Can i create a calculated field for ledger opening balance and closing balance. we are using  epicor. I dont know the exact table which captures opening balance and closing balance, where as i got credit balances and debit bala

  • RG1 register opening balance and closing balance updation 10-11

    Hi All, We are using the RG1 register recently i.e. after the Functional Upgrade (ECC 6.0). While executing J2I6 RG1 Excel report, opening balance and closing balance is not appearing in the report even though we have done the J1I5 extraction. Is it

  • REGARDING OPENING BALANCE AND CLOSING BALANCE 10-11

    Hi, All After executing the TCode - FBL3N, we get the details list. There we also need to display the OPENING BALANCE AND CLOSING BALANCE according to G/L Account and Company Code.Hi For opening balance, please use transaction F.01. Then go to specia

  • Opening balance and closing balance on Receivables Customer Statement repor 10-11

    I need an opening balance and closing balance of the customer statement in one report. Currently I developed a custom Customer statement report in report builder 6i. I developed a custom procedure to retrieve the previous statement balance. I'm able

  • Opening Balance - Transactions - Closing Balance in FD10N & FK10N 10-11

    Hi All, I need to see the report in following format for FD10N & FK10N 1. Opening Balance 2. (+/-) Transactions 3. Closing Balance FD10N and FK10N show the period balance and drilling into the balance shows the detail view of transactions posted in t

  • Opening balance and closing balances for discounts? 10-11

    Hi all, I have a typical sceanario where in opening balance for discounts 10,000 (balance of last month) actual discounts  from the sales order 5,000 manual upload is   from flat file            2,000 closing balance is 7,000 (which is opening balanc

  • Mismatching between opening balance and closing balance in F.08 10-11

    Dear Experts, i have one issue regardig the dismatching between the closing balance of 2010 and the opening balances of 2011. Actually we have the retention account for customer which showing a correct figure in 2010 but unfortnatly it showing anothe

  • Opening Balance and closing Balance - Crystal Report 10-11

    Hi, We have a report with account number, date , opening balance , closing balance and transaction amount. we had grouped the report by account. User will run the report with set of date range and we need to find the minimum date to find the opening

  • Opening balance and closing balance of BANK accounts 10-11

    I would like to see the replica of Pass book (bank statement ie opening balance +/- tranactions during the month then closing balance. I would like to execute and get these Bank Journals at any point of time for any period/year. Is this possible in S

  • Opening Balance an closing balance 10-11

    Hi Gurus, Please consider the following 1. Closing Balance for month of February  is the opening balance fro March 2. The closing balance is calculated in BW during execution of the report 2. How do i show the February closing balance as the opening

  • How is carry forward balance and closing balance stored in BW 11-30

    Hello all, I am working with the new G/L cube...and as per one of the reporting needs I need to display the carry forward balance and closing amount balance that comes from R/3. Can someone tell me how can this be achieved in BW. Thanks,if you are in

  • Gl opening balance and closing balance not maching 10-11

    Dear all, am looking at IT12 balance, and the issue is that the GL 495000 into the TB is 8,670.68   While if I browse in Fagll03 the balance is 7,307.88  Can you please clarify with figure is wrong !!!!!!   And why they do not match !!!!!!!! IT12 is

  • Opening and Closing balance in FBL3N? 10-11

    Hi All, In other ERP systems, if you browse GL Account, i.e. FBL3N in SAP, you get the list of documents within specified period but in other systems you also get the OPENING balance as well as CLOSING balance and the current postings are in between

  • Opening and Closing balances in RG1 register 10-11

    Hi, We are facing one issue in RG1 register. When we update and extract the RG1 register from system, its showing Sales Qty and Excise duties properly. But opening and closing balances are not coming, its showing zero there. I checked J_2IRG1BAL tabl

  • Opening/Closing Balance value missing in J_3RFCASH15 10-11

    Hello, I am having a problem with the new program for printing cash journal for Russia. When I am executing program J_3RFCASH15 and then select the KO-4 form layout the following data is missing: - Opening Balance amount - Closing Balance amount - Da

  • Opening/Closing Balance amounts missing in J_3RFCASH15 10-11

    Hello, I am having a problem with the new program for printing cash journal for Russia. When I am executing program J_3RFCASH15 and then select the KO-4 form layout the following data is missing: - Opening Balance amount - Closing Balance amount - Da

  • EBS Importing Opening / Closing Balances 10-11

    I am Importing EBS via transation FF.5 (APACS EBS), the file is importing all details except the Opening Balance and Closing Balance.  I have checked Algorithm and they are set up.   Using 4.7 Enterprise.  Has anyone got any suggestions.Hi, There are

  • How to check RG1 Opening and Closing balance 10-11

    Dear All, Kindly let me know how to check the opening balance and closing balance in RG1 register. Regards, MullairajaDear J Prakash, Do we need to check the balance based on Excise Transaction Type? I assumed that, we need to check as per the Regist

  • How to display Opening Balance/Closing Balance in Genral Ledger PLD 10-11

    Hi all, How to display Opening Balance in General Ledger PLD (OB is already displayed in header of print report) on first page only? How to display Closing  Balance in General Ledger PLD (CB is already displayed in footer of print report) on Last pag