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

selece28

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

ara3n

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.

Savatage

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.

Savatage

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.

selece28

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

Savatage

You don't have to it all.

you'll need a key thou to sort