Anyone know the logic for Querying Shipped not billed with SQL in BC?
What are the tables/fields I should be checking for Shipped not billed?
Anyone know where I can find these fields - in page inspection it says Sales Header but they are not in the table
Shipped Not Invoiced (5751, Boolean)
Completely Shipped (5752, Boolean)
The simplest place to start is to create a trace on the SQL server. Then run the page that shows the flow field you are chasing. Then look at the TSQL in the trace and you will find the subquery (APPLY) that you need.