Items and unit price

Unit cost is stored in the ITEMLOC table. You have a number of choices though- last received cost, last issued cost, and average cost. I tend to use last received cost (LAST_REC_COST). If you have multiple IC12 records for the item your query is going to return a record for each. You'll have to determine which one to keep in your report. I would use the one with the most recent last received date (LAST_REC_DT).

Another thing to consider is there may be items in your item master that have no purchase history so there will be no cost stored in ITEMLOC. If these are on contract in PO25 you could pull the cost (BASE_COST) from POVAGRMTLN. Keep in mind this cost is at the purchase uom and may have to be converted to your stock uom.

I would use the last rec cost as well for the nonstocks, we use average costing, so would use the average cost for stock items. Keeping in mind you need to factor in the issue UOM.

Thanks for the replies. We use average costing and also our non stock items are not defined on IC12. Will ITEMLOC have last received cost for those items?

We have our nonstocks built in IC12 so I do not know if the last rec cost would be listed there if you are not using it (IC12).

 

PORECLINE may be an option. It contains the MATCH_UNIT_COST (Invoice cost) at the purchase UOM, so a conversion to issue UOM would be needed. Link it to the ITEMMAST table and this will handle your stock and non-stock items.