We felt s necessity of a daily report to show sales tax paid against sale of each item with qty. Finding that no such report existed in the system, I have created a format using Custom Report to generate such a report. The screen shot is attached of the input made in each field:
However, it is noticed that while all the information is correct except a small glitch showing quantity of each item twice the actual sale qty for each item. I have tried may ways but cannot solve it. Can anyone extend help to solve the dilemma.
I confess I failed. I tried choosing qty, sales invoice, transaction in “where” but could not solve the problem of the qty which is still reporting twice the actual qty. I wonder if you can elaborate further for a sloution.
Manager is double entry accounting system, as Tut said earlier
In double entry accounting systems, each transaction is entered twice -hence “Double entry”
Once as a debit entry to one account and then as a credit entry to a different account
So each sales invoice line is posted to two accounts
In the Where clause you need to select one of these entries not both
The easiest way is to add the account to the Select clause in your reoprt, so that you can see what accounts are being used
Then you can select the accounts or accounts you need and remove the account from the select clause
To facilitate the search, remove the group by clause until you are happy that you are selecting all the entries you need
If this is not simple enough to do, consider getting a programmer to help - any competent programmer would sort this out in a matter of an hour or so
