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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,537 Super User 2024 Season 2
Martin Dráb 228,520 Most Valuable Professional
nmaenpaa 101,148