Good Day

I had a pastel consultant set up my data base. He created raw materials as an inventory item and cost of sales. However when running an Income statement the purchases captured under supplier invoice using the raw material inventory item does not post to cost of sales raw materials and show on the income statement. When i queried this, i was told to do an inventory journal. The problem with this is it is only bringing up an average cost of the item which is not a true reflection of the actual cost of sale. How can i fix this problem please ? p.s going forward im capturing the raw material under GL cost of sale rather as we do not need to keep record of the item under inventory item.

Thank you