Announcements
Hi,
we convert Sales quote to orders and then to posted sales invoice.
how can I get the data of posted sale lines with sq no.
basically I want to know which all sales quotes were converted to the sales invoices along with the line details.
I need to get the line details as well.
In posted sales invoices you can set a filter on the Quote nr. field with the value <>'' (different from empty)
That should show you all invoices that originated from a quote.
But the quote no. is not visible in the list page so you need to extend the Posted Sales Invoice list page to make it visible if you want to see it there.
The quote number is only stored in the Header, so you will have to take the document number from the line and read the header to get the quote number.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156