Skip to Content
0
Former Member
Feb 22, 2006 at 10:28 AM

Cost of sale oinm table

20 Views

Hi

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 ?

Many thanks

Regards Andy