Unit Costs on sales order lines

andrewt
andrewt Member Posts: 73
edited 2009-09-16 in Dynamics AX
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

Comments

  • kranthi
    kranthi Member Posts: 72
    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.
    Kranthi
  • andrewt
    andrewt Member Posts: 73
    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

Categories