Tables for Data of Outstanding & Invoiced Orders

murtazakhan

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.

MarkHamblin

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

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

37
111
113

There is a report that calculates back order quantity, use the logic in that to work out order quantities.

MarkHamblin

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.