0

Bin Contents and SKU - slow

Hi, I am new to Jet Essentials & we have Nav 2009 R2, I need a report that list the Bin Contents Table 7302 by certain Locations, but to also include the shelf Field from Stockkettping units - Table 5700

the reason is we want to identify in more detail in Nav where an item is stored & how many we have, so we are going to start to use the Shelf Field in the SKU as we are only dealing with SKU's.

I had originally created a report just on Bin Contents, filtered by Location, this ran well, for Quantity's by Location and Bin Code.
I decided to modify this report by linking in the Stockkeeping Table, but when I made the adjustments as below, the report tool 2 hours 39 mins to run instead of 5 mins, please advise if you can see any ways to improve the performance of this report:-

=NL("Table","7302 Bin Content",$E$10:$K$10,"Headers=",$E$9:$K$9,"TableName=","Bin Content","Filters=",$C$5:$D$6,"InclusiveLink=7302 Bin Content",$E$8)

Cell E8 =NL("Link","5700 Stockkeeping Unit",,"4 Item No.","=2 Item No.")

The new field for the shelf is =NL("LinkField","5700 Stockkeeping Unit","12 Shelf No.")

The report filters by Location code in the Bin Contents Table

If you require anything else, let me know

Thanks in advance

1 comment

Please sign in to leave a comment.