It is an incredible amount of work finding the 'Landed Cost' of one item.
Our sales people are paid commission from PROFIT of each item sold, and we look up individual 'item landed cost' for several other reasons also, including pricing.
After a PO is converted to a bill if we could auto populate the 'Cost Price' field on the detail page of the item (IT WILL BE GREAT)
At the present time we run a 'FIFO Cost Lot Tracking' custom report then divide number of items received so we can get accurate cost of one item. This must be done for each item sold every pay period. It is a lot of work finding the cost of a single item and we stock over 50,000 - Please Help Thank You