Hi Experts,
In Report Id-16538(Purchase Book VAT),
There are 3 fields Fields:
1. Base.
2. Tax Amount.
3. Total Sales Incl.
How could the Credit Memo values have negative sign(-ve), and the remaining Invoice values have positive.
that means to differentiate between the Credit Memo and Invoice.
My idea is to put a Document field, which will differentiate the Credit Memo and Invoice, but still how could the Credit Memo
Values in 3 of the fields can be shown negative.
0
Answers
In this case ABS() is used,which converts all values to positive.
I have removed the ABS function and placed a negative sign placing the source expr in braces
Eg: Source Expr -(Base), its the negative sign with the source expr in braces