Register Login

Transaction code for check opening + purchase+issue+closing stock

Updated May 18, 2018

Dear All

Please let me know that which T-code i use for taking opening + purchase-issue+closing stock report.

Regards

Vimal Lakhotia


Comments

  • 05 Oct 2012 10:15 am Guest Best Answer
    hi

    vimila go with mb5b
  • 06 Jul 2011 10:46 am Kiran V.Deshpande Helpful Answer
    Hi Vimal What do you want exactly.

    you wated to vendor stock (Op. or closing)

    so you can use T-code MBLB.
  • 07 Jul 2011 5:21 am vimal lakhotia
    Actually i want to check my company Balance sheet.

    And i have to match this value with Fico.


    Regards
    Vimal Lakhotia
  • 13 Dec 2013 3:33 pm Guest
    I WANT TO TAKE MONTHLY TRANSACTION REPORT IN SAP. i.e. OPENING BALANCE + RECEIPTS - ISSUES = CLOSING BALANCE. CAN YOU GUIDE ME HOW TO DO THIS? PLEEEEEZE.

    SHANKAR IYER
    MUMBAI
  • 19 Dec 2013 12:50 pm ಶ್ರೀ ಹರ್ಷ

    Dear Mr. Shankar Iyer

              It depends on the process elements also apart from Opening balance and Closings balances, Example in SAP issuing stock to quality is also issues and receiving only accepted stock apart from initial GRN is also receipts. The calculation goes like Opn=9(+)GRN=34(-)Issues to Quality=34(+)Receipt from Quality=30(-)Issues to production=25(=) Closing Balance=14Ea

    If run any typical T.code like MB5B, MCBC, MB1B etc. you may find Opn and closing stock matching to physical stock but receipts and issues may have different values. Receipts will be showing as 34+30=64 and issues will be showing as 34+25=59, so by that Opn=9(+)Receipt=64(-)Issues=59(=)Cls.Bal=14Ea

    if you are looking for the same you can use above t.codes

    Also you may please use other ledger T.Code : J3RFLVMOBVED, S_P00_07000139, S_P00_07000140

    Otherwise you need to go for ABAP programing with functional team help based on excluding some unwanted movement types to summarise the report.


×