Need your help
I am using the value entry table linking production order data via the table builder. The issue that I have is the value of the expected production order is repeated for each value entry so when comparing the expected consumption to actual consumption the expected consumption is overstated by full expected qty and $amount each time a value entry is created.
Please see attached file. The report has a snapshot of the repeated values that I am referring too.
Thank you
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello Nav_Newbie,
I believe this inquiry is similar to the one posted in the below forum and that has received a response from a Community member.
https://community.jetreports.com/viewtopic.php?f=7&t=4417
Cheers, -
Jet Reports Historic Posts What is probably happening here is that you based your report on 'lines'. A document often has more than 1 line.
If a document has 5 lines you will receive 5 duplicates in your report.
In this case you can prevent duplicaties by using other data or use the solution NAV_Newbie gave you. (which is probably your best option)
Danny
Please sign in to leave a comment.