meesam
June 17, 2020, 4:58pm
1
Hello Managers
i am trying to generate a report by custom field in this report everything is ok but qty is show double in report
i make 2 invoices see image below
item qty is in 2 invoices are 18,18 and 12 but report shows qty is 36,36 and 24 see the image
@lubos @Tut please help to solve this.
Thanks
Joe91
June 17, 2020, 5:06pm
2
You need to show the edit screen for the custom report?
You are double-counting the transactions
meesam
June 17, 2020, 5:11pm
3
@Joe91
thanks for your reply here is the edit screen of report
Joe91
June 17, 2020, 5:18pm
4
You need to add a “Where” clause so that you select only one of the two entries - by selecting on something but it isn’t clear what
Try adding other columns to the “Select” clause until you find one that will allow you to only select one of the two lines
Get rid of the “Group by” so that you can see the two lines
Once you have the field you need to use in the Where clause you can put back the Group By and get rid of the extra unwanted columns
Joe91
June 17, 2020, 5:30pm
6
Only you can solve this by doing what I suggested - I do not know what information you have entered into your business file so I can’t give any advice other than what I already said above
meesam
June 17, 2020, 5:32pm
7
i am tried but i can’t do this
can you make report to what you suggest.?
meesam
June 17, 2020, 5:41pm
8
one more thing can you see end of the report why show “empty”
Joe91
June 17, 2020, 6:30pm
9
You need to get did of the Group by
Tut
June 18, 2020, 12:37am
10
You see two entries because Manager is a double-entry accounting system. Your custom report picks up both legs of the transaction because you did not apply any filters.
meesam
June 18, 2020, 1:00am
11
@Tut
Please explain how i use filter to see exect qty.
Thanks