Questions about NAV schema on SQL Server

RSA_Tech
RSA_Tech Member Posts: 65
in NAV Three Tier
Hey all, NAV 2013 R2 here

Trying to find a way via sql to find all Sales Orders that have had a picking list printed but have not been shipped.

Using some homebrew queries to dig around the schema has me abit overwhelmed with options.

Could any one point me to the tables I'd need to join together to get that info?

Info needed:
Order No_
Picking List printed yes or no
Shipped or shipment date

I was working from the [Sales Invoice Header] table and figured I'd see what you grizzled vets have to say.


The reason why this occurred is because the user was batch printing the picking list for Shipping Orders and hitting 'ENTER' too many times effectively canceling certain orders from being printed. Those orders were marked as printed somehow (because they didn't come back into the queue). We found out the error and now I'd like to look at the last few days of orders to see if any others were accidentally canceled at that point.

Answers

  • RSA_Tech
    RSA_Tech Member Posts: 65
    Should I be looking at existing reports or is fishing around in SQL good for historical things?
  • RSA_Tech
    RSA_Tech Member Posts: 65
    I've been using a combination of column searching within SQL, the NAV dev client and MSDN to find columns and fields.


    to synthesize and restate the question:

    What's a good way to get my head around the NAV table and column scheme to be half decent and pulling reports together?

Categories