Tables for Data of Outstanding & Invoiced Orders

murtazakhan
murtazakhan Member Posts: 11
edited 2012-11-26 in NAV/Navision Classic Client
Hi Everybody,

I have been trying to get a report of all sales orders (outstanding & invoiced) but the perusal of previous posts revealed to me that there is no such standard report. Now I am trying create a report, but for that I need to know which table is the data it stored in. I have checked Customer, Sales Line, Customer Ledger Entry, Order Type and a few other tables but did not find the required data.

I would greatly appreciate if someone can help me with this.

Appreciate your support.
Regards,

Murtaza.

Comments

  • MarkHamblin
    MarkHamblin Member Posts: 118
    Sales Line will give you any open order lines (fields of interest are qty, outstanding quantity, and shipped not invoiced), and the Sales Invoice Line will give you everything that's invoiced. (And of course the sales shipment line for shipped items, which also includes the qty invoiced).
  • murtazakhan
    murtazakhan Member Posts: 11
    Hi Mark,
    Thanks a lot for the response. I have observed that there is another table Cust_ Ledger_Entry. Does it have the same data as Sales invoice line or includes more than that or less.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    37
    111
    113

    There is a report that calculates back order quantity, use the logic in that to work out order quantities.
    David Singleton
  • MarkHamblin
    MarkHamblin Member Posts: 118
    murtazakhan wrote:
    Hi Mark,
    Thanks a lot for the response. I have observed that there is another table Cust_ Ledger_Entry. Does it have the same data as Sales invoice line or includes more than that or less.
    The customer ledger entry is essentially a "summary" of everything that's been invoiced. It does not include anything not shipped, or anything shipped and not invoiced. It also does not include amounts in the SQL table - for that you need the detailed customer ledger entries.

Categories