Skip to Content
avatar image
Former Member

how to calculate opening stock month wise

Hi experts...

I m using mseg and mkpf tables .

I want to calculate opening stock month wise.

can anybody tell me the logic for calculate opening stock.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 18, 2007 at 05:51 AM

    Dear Ankita,

    If you want the stock monthwise, then I suggest you get ur data from the:

    -> S031

    -> S032 tables

    Since it stores the statistical data about goods movement, It would be faster and would serve the purpose better.

    The stock would be = opening + receipts - issue.

    Regards:

    Ravi Carpenter

    • Plz rate if useful

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 18, 2007 at 04:54 AM

    hi,

    take records from mseg where mkpf < s_budat-low.

    In first part of records ignore movement bwart not in ('641','642').

    plus stock for shkzg = 'S' and minus stock for shkzg = 'H'.

    In second part of records take mvement bwart in ('641','642').

    plus stock for shkzg = 'S' with bwart = '642'

    and minus stock for shkzg = 'H' with bwart = '641'.

    try it...

    thanks...

    raj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 18, 2007 at 06:33 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 10, 2014 at 07:21 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded