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?
2 comments
-
Jet Reports Historic Posts 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

-
Jet Reports Historic Posts 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