Hello everybody, a few days ago I was working with a report but I saw although the information its correct, the report give me information duplicate (in disorder). I add the screenshot of relations and report:
someone have idea about how fix this?
Answer
Report with lines dupplicate IN Tran table
Best answer by bwhite49
I don’t think you need the INTran table if the INTransferStatus table has the inventoryID. I would remove that join and that should fix the issue.
+11I don’t think you need the INTran table if the INTransferStatus table has the inventoryID. I would remove that join and that should fix the issue.
+8Is this INTransferStatus a custom table? The join adding the INTran should also have a condition on the LineNbr, otherwise you are linking all the lines of that transaction to the single record from INTransferStatus.
Samvel Petrosov | www.iigservices.com | https://www.linkedin.com/in/samvel-petrosov-096880107/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.