I have some data points that I'm not sure how to connect to give me the information I'm after.
Each item has a purchase price. To work on POs, this is necessarily the supplier's selling price, and stays relatively fixed until a price change happens. But my true delivered cost on many items needs to reflect shipping charges. Which I am able to add to a PO as a line item, but I don't see it anywhere involved in any of the useful math.
It can't update Purchase Price, I get that. But it seems like there should also be a Delivered Price that gets calculated on an ongoing basis and is the better number to use in calculating Gross Margin.
Where an item's price includes "free" shipping, then Purchase Price and the Delivered Price would be identical. But where shipping is a factor, shipping most often varies, and these days sometimes quite dramatically.
A further usefulness of a Delivered Price would be in the case of a product I can purchase from multiple vendors whose shipping rates differ. It would be incredibly valuable information to be able to see at a glance a true averaged delivered price on the same product over the history of purchasing it from more than one source. For example, I suspect (but it is non-trivial to manually determine) that Supplier A's lower per piece price translates to a higher true delivered price than buying from Supplier B, because of how much Supplier A's shipping charges end up being. It seems like all of the data exists to be calculating this. Is this already possible by some means I don't yet see, or would it be a feature request?