ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Material cost
http://www.istechforum.com/YaBB.pl?num=1269949200

Message started by TFay on 03/30/10 at 04:40:00

Title: Material cost
Post by TFay on 03/30/10 at 04:40:00

This is going to sound stupid but should be easy for someone to answer. In the SA-A or SA-B report, where does the material cost generate. If the report prints a zero value is it because of the way the item was entered to finished goods?

Once a work order is closed, is it possible to still generate this data for this report?

Title: Re: Material cost
Post by dameng on 03/30/10 at 13:25:35

the material cost comes from the sales order invoice file, specifically the BKARHINVL for the line items on the invoice. what happens, is that AT the Time of Posting the invoice, the data is copied from the Sales order files and records created to the Invoice files during which time, the AVG cost from the Item master is taken to update the cost of the Item just shipped.

so, if your Work orders are finished after the sales order is invoiced and your items on hand are zero, and or avg cost for that item is zero, then your material cost at invoicing is also going to be zero.

thing to do, is make sure the work orders production is finished and posting with a cost, prior to (at least...) Posting the Invoice. ( but don't forget to post the invoice before you try to re release the same sales order if processing multiple shipments)

hth