Total no of sales quotes,orders

sathangai

Hi all..

iam new to development and i want.....
my client asks me a report for the total no of sales quotes(each quote) raised and orders...
(or no of sales quotes,orders raised for an year).

i looked in [sales header table,sales line] and [sales header Archive table ,sales line archive] for document type..quote,order.......

i)when a sales quote is converted to Sal.order,the sales.qoutes disappeared.
ii)in sales header archive table..iam getting only archived sales quotes...

the same for sales orders...
iam in need of a report showing total no.of sales quotes raised(each quote) in a
report.

will it be achieved through code(if yes help me) or any other method is there?
iam using nav 2009 classic client with sql server
Thank you

matttrax

When a quote is turned into an order, the quote no. field is filled in. That should get you the numbers you're looking for (with a little math).

sathangai

Thanx mattrax.....

but iam not clear....if i want the no of sales quotes raised for a year...how can i?......

matttrax

You filter on the order date (or posting date or whatever date is required) and filter on the quote number where it is filled in. That's your number of quotes.

The ones with it not filled in are your number of orders.

murtazakhan

Hi Mattrex,
And which tables would be having the "amount" the data of outstanding and invoiced orders.

Appreciate your response.
Regards,

Murtaza.

abhi1901

murtazakhan wrote:

Hi Mattrex,
And which tables would be having the "amount" the data of outstanding and invoiced orders.

Appreciate your response.
Regards,

Murtaza.

Calculate it from sales line on behalf of your sales header.