How to sort by Shelf No. in Phys. Inventory List Report

selece28
selece28 Member Posts: 316
edited 2007-11-09 in NAV/Navision Classic Client
Hi Nav masters,
My client want me to add shelf no in Phys. Inventory List Report.
I manage to do that, but now they want it to be sorted by the shelf no.

Can we do this?
I have no idea how to do it, could anyone please help me. How to sort if the report dont have Item as the dataitem?


Thanks in advance
______________

Regards,
Steven

Comments

  • ara3n
    ara3n Member Posts: 9,258
    You need to create a new field in Item Journal Line "shelf no"

    OnValidate trigger of "item No." field you need to asign the "shelf no" form item

    "Shelf No." := Item."shelf no";

    Create a new key in item journal line
    Journal Template Name,Journal Batch Name,Shelf No.


    Modify the report and change Item Journal Line Dataitem key to the above key.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Savatage
    Savatage Member Posts: 7,142
    Note it pays to sort the report the same way as the Phys. Inventory Journal. That way when go to the journal to make changes all you have to do is go right down the list instead of looking around.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • Savatage
    Savatage Member Posts: 7,142
    What We did was..

    On the Item Journal Line (83) We added "Shelf/Bin No." field 50000

    We also Added a Key "Shelf/Bin No., Item No" Just in case there were two items listed with the same Shelf No adding the Item part wold keep them seperate.

    On The Phys. Inventory Journal form (392) the SourceTableView is:
    SORTING(Shelf/Bin No., Item No.) ORDER(Ascending)

    We use the Calculate Inventory Report (790)
    So Just before the INSERT(TRUE); code of the InsertItemJnlLine We added
    If "Shelf/Bin No." = '' THEN
    "Shelf/Bin No." := Item."Shelf/Bin No.";

    Then on the Physical Inventory Count Report (10151)
    We changed The DataItemTableView of the Item Journal Line Dataitem to:
    SORTING(Shelf/Bin No., Item No.) ORDER(Ascending)

    also.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • selece28
    selece28 Member Posts: 316
    Wow we have to modify that many objects?
    Can we just modify the R722 Phys. Inventory List?

    Ow ya, and what is Report 10151? I don't have that.

    Ow and one more, is it save to just add new fields in Item Journal Line, I'm afraid i will have an error in the future for other process that use the Item Journal Line table.

    Please advice

    Thanks in advance
    ______________

    Regards,
    Steven
  • Savatage
    Savatage Member Posts: 7,142
    You don't have to it all.

    you'll need a key thou to sort
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org

Categories