One of our customers wants a report of all invoices and the actual cost price of the lines of the invoice. I think the information is held in the oinm table. You have a base_ref and a doclinenum field which seem to link back to the original invoice.
The problem I have is that when I join the oinm table to the invoice table I seem to be out very slighty on the total value of invoices, ie I my link must be wrong
Just wondered if anyone has tried doing this before ?