Skip to Content
avatar image
Former Member

Functional Specification For Opening And closing stock On Particular Date

Dear Gurus,

I am creating report for opening and closing stock on particular date in which batch and storage location should also be included. I want to know the tables and fields for the same.I have searched the forum and got report on month basis but I want this report on posting day basis.kindly suggest tables and fields. Thanks in Advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 23, 2011 at 09:43 AM

    When a standard TCode MB5B is there, why do you want to go for zee report. ??

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear sir,

      There are many other colums that client wants to add which are not present in MB5B transaction.columns which client wants to add are as follows...

      Material Number

      Material Description

      Material Type

      Material Group

      External material Group

      Movement Type

      Plant

      Storage Location

      Customer Number

      Customer Name

      Vendor Number

      Vendor Name

      Posting Date Receipt Doc. Number

      Issue Doc. Number

      Reference Issue Document Number

      Opening Stock Quanity

      Material Receipt Quantity

      Material Issue Quantity

      Material Closing Stock Quantity

      Value Of Closing Stock

      And for this I want tables and logic for the same. kindly provide the solution for the same.