Options

how to find stock report with sl.no. in a date range

pravin_mpravin_m Member Posts: 67
hello everybody,

I am usning nav2009r2. i want a stock of an item with sl.no. in which report Opening stock detail with sl.no. , total in qty. with sl.no., total out qty. with sl.no. and closing stock with sl.no. in a date range

Date Range = 10-04-11 to 20-04-11

Stock as on 10-04-11
slno-002 05-04-11 1
slno-004 08-04-11 1

IN
slno-006 10-04-11 1
slno-007 15-04-11 1

OUT
slno-002 05-04-11 1 10-04-11
slno-006 10-04-11 1 14-04-11
slno-007 15-04-11 1 18-04-11

Stock as on 20-0-11
slno-004 08-04-11 1

pls. help me

Thanks in advance

Regards
Pravin Maheshwari

Answers

  • Options
    ChinmoyChinmoy Member Posts: 359
    Hi Pravin,

    By sl.no. - I hope you are talking about 'Item Serial No.' or is it something else? If my assumption is correct, you will have only 1 (one) quantity of an item with a single serial number. You can have one 'In record' and one 'Out record' beside which you can print the serial number, but how will you print the serial number against the opening and closing stock lines, because these lines will be a sum of all the quantities.

    Please let us know, what you are exactly looking for in some more details.

    Best regards,

    Chn
  • Options
    pravin_mpravin_m Member Posts: 67
    hello chinmoy,

    thanks for reply,

    your are right that op. & closing qty. is sum of qty. & sl.no. is Item sl.no., but my clint is automobile spare manufacturer. so he wants to know that item which he manufactured, how mutch old and detail of old stock.

    regards
    Pravin Maheshwari
  • Options
    ChinmoyChinmoy Member Posts: 359
    Hi Pravin,

    Unfortunately there are no base reports which can serve you purpose (at least not to my knowledge and on the basis of how I perceive your requirement). However, you can customize a new report to get desired results.

    See the "Inventory - Transaction Detail" report. I think you can add the "Tracking Specification" table as a dataitem linked to the Item Ledger Entry dataitem and print the serial number details below every line of transactions getting printed.

    Cheers!

    Chn
Sign In or Register to comment.