Hi, I'm using a query to append data to a table for both invoices and credit notes in the same list.
On this table, I need to have a document number field increased based on the document type.
In this table, I have fields, DocType (values INV or CRN) and DocNumber
For DocType Invoice, I need...