Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

cancelling invoice in Query

Hi all

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.



I would u say u should use Canceled='N' in most of the time. In this case, u will avoid all the canceled the documents and the cancelation documents.


0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question