Hi!
Previously I had made a publication with the same search that I am publishing right now, but the detail that I have now is in relation to the dates.
Currently, a transaction-type saved search is being carried out that shows the name of the opportunity, the total of the opportunity, the total invoiced and the total collected.
This search considers the following criteria:
- Type: Sales invoice (Select this type since it was easier for me to obtain the amount paid and thus be able to calculate the column of total collected)
- Main line: true
- Opportunity: it is not none (I put it this way so that I could contemplate those invoices that had an opportunity related to them)
- Status: it is not Bill of sale: Voided
- Transaction Application:Type : None of Credit Note, Currency Revaluation
- Date: is within this year
The detail that is currently being taken is that the date includes the whole year but when we want to select a certain period, for example, see until June 30 (It should be mentioned that this is only an example since the date may vary) I it continues to show those invoices that were paid outside of that selected date.
For example:
In the search results there is an opportunity
that when we see the detail has three related invoices, of which two are already paid,
what we want to see here With the issue of dates, for example, if I select that the date be until June 30, as a first point I must continue to maintain those three invoices because they are within the date range and I can continue to see the "total invoiced", as second point in the case of "Total collected" should not contemplate what was paid after June 30, in this example would be the two invoices already paid since they have a payment date of July 15.
I have tried several ways but I do not achieve the expected results, is there a way to carry out this search considering the previous points?
First of all, Thanks,
Cheers