I am having a bit of a hard time with this report I am trying to build. Full disclosure I am still a beginner when it comes to Jet Reports.
I am using the Item Ledger Entry No. as my main field to pull my information from. However, when I run the report I am getting duplicate values and I am not sure why. See screen shot. How can I just get the one entry like it shows in NAV?
Thank you for any help!
Without seeing the functions and tables, there really isn't an answer. You could be pulling from a table where the Item Ledger Entry No. is duplicated, you might have multiple rows replicators on the same row, something could be locked down that shouldn't be... There are too many unknowns without seeing the report. This is where Jet Services can come in handy to work with a report analyst who can be on a call with you and see your screen/report.
