Sales order status in table

Finance and Operations/AX Developer Forum
1

Hello,

I want to know sales order status in ‘Salestable’, in database.

I want to figure out

1-- Sale order which are Invoiced

2-- Sale order confirm but not invoice

3- Sale order created not confirm nor invoice.

can someone tell me which status field I have to check above status of a sale order???

Thanks in Advance…

2

Combination of Salesstatus and Documentstatus fields in salestable will give you the data you are looking for.