Unit Costs on sales order lines

andrewt

Hi all,

In Ax 2009, I am trying to create a report which calculates sales order margins.
It looks like AX does not track the unit costs within the sales order lines so I do not
have direct access to this value.
My question here is what is the best way to collect item unit costs, will I have to
read these values from InventTable or are there classes/methods which should be used
to collect the cost values ?

Thanks in advance
Andrew

kranthi

Hi,

I dont know at what stage on sales order u are generating the report.

if u are generating the report after invocie, go through the code available in

Table - CustInvoiceJour
Method - contibutionMarginMST.

I think it will help u.

andrewt

I found form SalesTotals which displays exactly what I am looking for. This form uses Class SalesTotals which is an extension of Class TradeTotals. The class provides methods to return
the total amount, total costs, margin (contribution) value and margin pct. which is perfect to my requirements.
Unfortunately the class delivers values for open orders / quantities only, not for invoiced.
So I will now try to follow your hint to get values for invoiced sales orders.

Many thanks for your assistance
Andrew