Online Tutorials & Training Materials | STechies.com
Register Login

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

|| || 5

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

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
    hi

    vimila go with mb5b
  • 06 Jul 2011 10:46 am
    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
    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
    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.

Related Articles

0.0162 seconds.