Both of the 'Inv #' calculated columns are the same in each view:
{Trx Type} & {Doc #}

You then could choose to do a filter on the Matching view to select only invoices as the document type and cash as the matching type, or whatever else is desired. The video workspace doesn't have this.

These are required in order to get the GetLinkedValue to work as desired, as you have to sort the Matching file by invoice number and then by date descending in order to get the most recent payment date per invoice.

PS: I am that demo guy...

Your Adagio Consultant knows as well...

John:

As your Adagio consultant, I would say this is a great project for us to work on togther.

Reading through this thread I would say that all of the useful information that can be provided in this forum has already been said.

Good day gents,

I spent the afternoon Friday and most of the day yesterday and have now viewed the video 3 times and still cannot make the nice easy join that was shown in the Gridview demo for version 9.0C.

Considering that I am a programmer way back from the Clipper days and now into C# - I do not understand why this process seems so unattainable - something is wrong!

Cheers, JK

Good day gentlemen,

Thank you very much for the information - for some reason Friday's posts just appeared on my systems in the last few minutes.

I agree with Doug in that there is nothing further that can probably be communicated on this forum and will make arrangements to work with him directly.

Cheers, JK

PS: thank you demo guy!

Good day everyone!

After following up with professional support I have been told that what we are trying to do will not work and that the only path forward for this kind of analysis is to send everything through Adagio invoices and then use the tools provided in Sales Analysis.

We are taking this under consideration and have asked our reseller to make a request to development that would allow for better database intelligence by carrying the required information into these tables as I am certain there are others who are trying to do the same thing.

Thank you and,

Cheers, JK