Skip to Content
Mar 27, 2019 at 08:41 PM

OINV.Canceled base reference


Good afternoon experts,

I have several canceled invoices, when I query my database their canceled value is 'Y'

There are also several which value is 'C'.

I know they are related, the original should be 'Y' and the canceled should be 'C' but how can I find out the base reference?

For example, the original has a DocEntry = 522 and the Canceled has a DocEntry = 300303. I saw the comments and sometimes it shows "based on document..." but sometimes my client enters some other information.