| Author |
Message |
Jade
Joined: 12 Mar 2008 Posts: 23
|
Posted: Fri Apr 25, 2008 2:04 am Post subject: Query for total of a grouped transaction |
|
|
Hi again,
If I have an invoice total, but not the breakdown which created the grouping, is there a way to find the Invoice by a Query or Report?
For example I know I paid $100.00 for some items. When entering in ICash the invoice was used to created 2 transactions and then these were grouped.
If I do a Query for amount 100.00 nothing comes up. However, if I query one of the amounts of the group then I get the whole group of transactions up if I have the group selection checked off. Is there a way to find that transaction by the grand total rather than the individual group amounts?
Thanks again. Jade |
|
| Back to top |
|
 |
stanbusk Site Admin
Joined: 28 Dec 2005 Posts: 2086
|
Posted: Fri Apr 25, 2008 9:11 am Post subject: |
|
|
| Have you tried with the transaction comment? I guess you did but it is just to make sure. |
|
| Back to top |
|
 |
Jade
Joined: 12 Mar 2008 Posts: 23
|
Posted: Sun Apr 27, 2008 3:59 am Post subject: |
|
|
| I did finally find the item by using the comment but just wondered if it was possible to find the transaction by the total. Depending on who is looking up the information they may not be aware that it has been split into multiple transactions and may only know the total. In our case the person who inputs all the data is not always the person looking for information. Thanks, Jade |
|
| Back to top |
|
 |
stanbusk Site Admin
Joined: 28 Dec 2005 Posts: 2086
|
Posted: Mon Apr 28, 2008 8:48 am Post subject: |
|
|
| Ok, I take note. |
|
| Back to top |
|
 |
|