I have recently installed Jet Enterprise for NAV 2013 R2 but I’m still trying to figure out on how to use the system and having difficulty on producing a report based on posted QC tests. I can see where the data lies on two tables and can pull the data individually but having trouble linking and formatting it into a final report.
The two tables are “Posted QC Batch” and “Posted QC Line”. The posted QC Line has numerous entries for each Posted QC batch.
I have attached screenshots on what I would like the report to look plus data from the two tables.
Can anyone help me out to get started?
New to Jet and need help with designing a QC Report