Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) How do I link revised ...

How do I link revised quotes in a single query?

(0) Share

Report

Posted on by John_Smickel

I am trying to create a report a customer using SQL Reporting Services built on data from Dynamics GP. The customer who requires the report has a process whereby he creates a quote with prices, updates the quote multiple times with revised prices and then zeroes out the prices on the final quote before the quote is transferred to an order and then an invoice. He wants me the report to display the invoice but but with the prices from the final quote before they are zeroed out. I am troubling figuring out the best way to structure a SQL query to create a table with the appropriate data as I cannot figure how the quotes are linked to one another besides the '-#' naming convention. Can anyone offer me some help? Thanks!

John

*This post is locked for comments