Trying to pull data from Transfer Orders Table in NAV 2015

Questions and Answers asked by users to users, about how others use Jet Express.

Trying to pull data from Transfer Orders Table in NAV 2015

Postby sammok » Mon Sep 12, 2016 7:40 am

I am trying to pull the information from Transfer Order Tables. By using table builder, I made Transfer Header on top and Transfer Lines at the bottom and linked the No. and Document No. The problem is I am not able to get Item No from lines in the report, but I can see the description, Qty,.... Any suggestions?
sammok
 
Posts: 1
Joined: Mon Sep 12, 2016 7:28 am

Re: Trying to pull data from Transfer Orders Table in NAV

Postby MWilson » Mon Sep 12, 2016 1:38 pm

Hello Sammok,

Can you attach a '.xml' template of your Table Builder report?
Can you send some screenshots of what you are seeing on your end?

I created the same report as you are describing and had no issues viewing the Item No. from the Transfer Line table.
See the screenshots below.

Best regards,
MWilson

Table Builder_1.PNG
Table Builder_1.PNG (35.33 KiB) Viewed 2291 times

Table Builder_2.PNG
Table Builder_2.PNG (13.5 KiB) Viewed 2291 times
MWilson
 
Posts: 157
Joined: Mon Mar 31, 2014 8:37 am

Re: Trying to pull data from Transfer Orders Table in NAV

Postby krd1996 » Wed Sep 14, 2016 9:10 am

sammok,

Here is a tip from Jet kb article, https://jetsupport.jetreports.com/hc/en ... -NL-Table- :

TIP: When using the Table Builder or the NL("Table") function with both a header and a detail table (e.g., NAV's Sales Header and Sale Line tables), you will usually want to make sure that the detail table is the first one referenced. This will allow you to display more information than if you start with the header table.

Regards,
krd1996
krd1996
 
Posts: 2
Joined: Mon Jan 05, 2015 10:05 am


Return to Ask the Community

Who is online

Users browsing this forum: No registered users and 1 guest