Options

Total no of sales quotes,orders

sathangaisathangai Member Posts: 25
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

Comments

  • Options
    matttraxmatttrax Member Posts: 2,309
    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).
  • Options
    sathangaisathangai Member Posts: 25
    Thanx mattrax.....

    but iam not clear....if i want the no of sales quotes raised for a year...how can i?......
  • Options
    matttraxmatttrax Member Posts: 2,309
    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.
  • Options
    murtazakhanmurtazakhan Member Posts: 11
    Hi Mattrex,
    And which tables would be having the "amount" the data of outstanding and invoiced orders.

    Appreciate your response.
    Regards,

    Murtaza.
  • Options
    abhi1901abhi1901 Member Posts: 102
    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.
Sign In or Register to comment.