I have a report that on certain entries, it duplicates the same entry a number of times. This is not happening on all entries so i do not know what it is that is wrong.
Any suggestions will be greatly appreciated.
Book2.xlsx
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi,
If you unhide all your hidden columns and rows, it should become clear what is happening. If you examine the 3 groups of duplicates, you can see in column I that each group has a different G/L Entry number (that's the last part of the string, "549473", "549474", and "549475"). However, when you scroll over to columns N and O you will see that those entries all have the same document number and document type (Invoice, PPI-003272). Since all you are filtering on in the rest of the columns is based on the document number and document type, this is why these 3 groups appear identical.
I don't know enough about your report or what result you want to know how to fix this problem. However, the reason it is happening is because you are assuming that each row of the G/L Entry that matches your filters will have a unique Document No./Document Type and clearly this is not the case. I hope this helps.
Regards,
Hughes -
Jet Reports Historic Posts Thanks again Hughes…
This report is to get all expenses by GL Account.
In regards to the Entry No. And the Doc Number, i had seen that but i assumed that since the Entry number is unique, it would only return one entry.
Is there any report/function i could use to see what fields are the same/relate to one another in different tables? Maybe i could use that to add a filter? -
Jet Reports Historic Posts Your replicator from the G/L Entry table in column I does only return one row per entry number. However, several of those entry numbers have the same document number/document type, and your replicator in column R is replicating based on those document number/document type.
As far as seeing relationships, you can import your NAV objects into your data source. Export the tables as text from NAV and then import that text file into the data source in the Jet Data Source Settings. Often users don't have permission to export NAV objects as text, so you might have to have your NAV provider do this. After you do that, in the Jet Browser you can select a table and expand the details at the bottom and see the tables it is related to and what the related fields are.
Regards,
Hughes
Please sign in to leave a comment.