Bug in Qty Total (custom reports experimental)

[meesam]

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]

You need to show the edit screen for the custom report?

You are double-counting the transactions

[meesam]

@Joe91

thanks for your reply here is the edit screen of report

[Joe91]

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

[meesam]

@lubos

please solve this

[Joe91]

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]

i am tried but i can’t do this

can you make report to what you suggest.?

[meesam]

one more thing can you see end of the report why show “empty”

[Joe91]

You need to get did of the Group by

[Tut]

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]

@Tut

Please explain how i use filter to see exect qty.

Thanks

[Tut]

Filter for one account.