When I create a project quote, it is pulling from AVG cost from my inventory ID instead of Last Cost. This is a problem because
1- if I’ve never bought the item before, there is no average and there for the system puts in a 0.00
2 - The Last Cost is my updated price which is the price I need when vendors change pricing.
I am currently tracking inventory via FIFO (and testing specific).
-Added a few screen shots for reference.
Thanks for your help!