Orders that are “Released”, But Not Yet Shipped – Which Table(s) contain this data?

Business Central/NAV User Forum
1

I have been asked to create a report of orders that have been released, but have not yet shipped.
I do not have access to any of the NAV screens. I only have access to the NAV database via ODBC (read only).
I have looked at the fields in the “Sales Header” table but I am not sure if this table contains the data that I need. For example, is there a field in the “Sales Header” table that indicates if an order has been shipped or not. There is a status field, but I am not sure what this is used for.
Thanks for your assistance.
Brad

2

There is also a Flowfield called Completely Shipped…check that…

3

Brad its going to be a huge job to do this from the back end without Navision knowledge. You need to work with the client’s Navision partner that will know the requirements and be able to tell you what you need.

4

In Sales Line you have that information on field “Quantity Shipped” - Compare with field “Quantity” and you know if a line was shipped or not. But you need to make that compare for all lines, because you can ship part of total quantity for each line, or completly ship one of the lines and another one you didn’t ship anything.
If you just have access to database you can’t see the NAV flowfields, it was just a NAV field, but does not exist on database table.

5

You can’t create a report if you don’t understand the data structure of what you’re reporting on and worse can’t see how it is actually used. Take David’s advice here.

6

Thanks to everyone who provided their insights and ideas.

I am planning to push to obtain access to the NAV system in order to better understand it. It is difficult for me to understand things when my only access is ODBC.

I also plan to work with our Navision Partner to obtain their advice.

I have worked with database systems since 1975. All of the purchased products that I have worked with included some sort of “Data Dictionary” or “Data Model” to make is easier to understand the underlying database. It appears that Microsoft has not provided such documentation with Navision, as least I have not been able to locate any so far.

Thanks again for your assistance.

Brad