SageForum for UK versions of Sage 50- Help and support.

After spending a few hours this morning trying to teach myself table joins in report designer I can happily confirm I am still lost.

So I am reaching out to see if anyone can help

I am trying to add sales delivery address information to an invoice report, which I can get it to do using certain join methods on the delivery name field, however upon exporting data to Excel a lot of transactions are heavily duplicated. Can anyone help?

Namely I want to add the Notes information from the delivery address section to an invoice report to be exported to Excel. Is there a way? Thanks in advance.

I think you are on a loosing battle, the delivery address is not linked to the invoice, it only takes an update to the delivery address and things break.

If you want the data in excel then the best way is to use odbc to read the data directly from the tables in sage.