Database Invoice

Hello,
In the database that field can help me to know what is a sales invoice or a purchase invoice, thanks for your time.

hi,

sales:
issotrx= Y

purchase:
issotrx=N

cheers,
norbert

I was adding and they were not giving me the total, but with your help I am sure that this is the field, thank you very much.

if you want to go a step further also join c_doctype
then you can distinguish between invoice, credit memo, etc.

1 Like