Im trying to setup a view in A/R Invoice History inquiry ... what i want to do is have it not show invoices of .00 value , however when setting up the filters this does not seem possible to do. because MAS treats 2 different filters with an AND value so for example if i do
INV Total , is greater than , .01
I dont see the .00 value , however i lose all my invoices in the negative values same is true for the reverse where i can see then negatives but not the positives.
The problem with the AND value that is attributed to multiple filters is they cancel each other out.
My ideal filter would be
INV Total , is not equal to , .00
Anyone have a solution for this ?
Thanks
Steven Yvinec-Kruyk
Ubisoft Canada
INV Total , is greater than , .01
I dont see the .00 value , however i lose all my invoices in the negative values same is true for the reverse where i can see then negatives but not the positives.
The problem with the AND value that is attributed to multiple filters is they cancel each other out.
My ideal filter would be
INV Total , is not equal to , .00
Anyone have a solution for this ?
Thanks
Steven Yvinec-Kruyk
Ubisoft Canada