Tables to get all sales orders

Business Central/NAV User Forum
1

Hi,
I want to get details on all sales orders including invoiced/non invoiced. I need to know which tables are the data it stored in.

I used below tables for that, not sure the logic is correct.

To get non-invoiced SOs,
Sales Header and Sales Line (by aggregating into order level) tables, by filtering the records via Sales Header,“Document Type” = 1

To get invoiced SOs,
Sales Invoice Header and Sales Invoice Line tables by filtering out the records via Sales Invoice Header.“Order No_” IS NOT NULL

Any help will be greatly appreciated.

2

Hello,

Yes, your logic is correct for fetching both invoiced and non-invoiced sales orders.

Thank you,
Arjun M

3

Hi,

Good day,

Yes, you can extract Invoiced/Non-invoiced sales orders by the logic you mentioned.

Regards,
Guru Krishnan.