cancel
Showing results for 
Search instead for 
Did you mean: 

Cost of sale oinm table

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Louis

The customer is using moving average cost price. I am actually using 2 queries, one tran type 13 for invoice and one for delivery notes, type 15, if the invoice base document was an invoice.

Makes sense ?

Regards Andy

former_member184566
Active Contributor
0 Kudos

Hi Paul

Moving average should be fine

make sure on it's own it works great before seeing base docs. The sum of the values that goes in oinm for a transaction will be the same that is written to the stock control account. Look in the journal linked to invoice.

let me know if you need to know more.

former_member184566
Active Contributor
0 Kudos

Hi Paul

The link is the base_ref and the docnum in invoice. But your doctype must be limited to 13, this will only pull invoices.

What costing method are you using? FIFO?