AnsweredAssumed Answered

How to compare line items from different records

Question asked by donjuancarlos_1 on Jan 5, 2011
Latest reply on Jan 5, 2011 by donjuancarlos_1

Title

How to compare line items from different records

Post

FM 11 Windows

Situation: Quoting database - Each quote record has 40-60 line items.

I want to be able to use the quoting database to create change orders. I would do this by taking two records and create another record in a Change order database that has the part number and difference in price and quantity between the two quote records.

What is the best way to set the data up to compare line items from two different records? (some sort of temporay storage?)

Outcomes