0

Bin Code and Serial No.

Vince Rinner

February 02, 2018 19:33

None

Follow

I want to create a Jet report that shows me the Bin Code, Item No. ans Serial No. in that particular bin.

When you go to the Bin Contents List in NAV, it will show you all of the info including the Serial Number in the Serial Number by Bin FactBox which has the serial number info in it.

If I do an about this page on the Bin FactBox I see that the source table is Serial Numbers by Bin Buffer (50014)

If I add that NL function to look at the Serial Numbers by Bin Buffer table linked to item number and bin code it comes up blank.

Question; How can I get the Bin No, Item No, Serial No. on a Jet report.

Thanks!

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Harry Lewis February 07, 2018 16:54

  I am not familiar with you custom table #50014.

  If possible, you may want to access that table in the NAV Development Environment:

  

  and either RUN or DESIGN to help you determine how that table is related to others.

  You could also try creating a simple Jet report that uses the NL("Table") function to show you what that table looks like:

  =NL("Table","50014")

   

  I hope that helps get you pointed in the right direction.  If there are others here on the Community that have experience with this, maybe they can help, too.