cancelling invoice in Query
How to show Sales amount in negative for cancelling Invoice?
Example Invoice A is the Invoice being cancelled and Canceled status is 'Y" when Invoice B is the cancelling Invoice to reverse Invoice A. There is another Invoice C that is the correct Invoice.
Now the Query result is showing all Invoice A, B and C.
Even if I include where cancelled <> 'Y' it is showing both Invoice B and C instead of only C.