Hi Steve,

Thank you very much for confirming what I understood - you have saved me a considerable effort.

I have dumped the data dict down and have started poking around (iow: back where I was working before) but at least now I have a map of what is where.

If anyone is familiar with the data flow through these tables and could shed some light on what to join with what I could surely take it from there using the tools provided.

Again, I am trying to create a view that will show the first (or last preferably) payment date on an invoice bearing in mind that we are only using Adagio A/R.

Going with the last date will better reflect a customer's payment habits as using the first date would be misleading in the event numerous entries are done on the one invoice.

I have tried using the document number but that did not work and I know I've got the GetLinkedValue() call correct because I can relate the item to itself in another view.

Recapping: Is there a field which relates the invoice payment data (CA) to the original invoicing data (IN) and if there is such a key what general relations need to be used (high level only)..

Thanks in advance and,

Cheers, JK