We would like to track our inventory in QuickBooks Online (QBO), but purchase our products from multiple vendors with different pricing. The amounts we purchase from each vendor varies by day. Is there a way to have QBO calculate the average cost from purchase entries and then automatically update the Cost on the Product, so it is accurate for Sales? With our volume of purchases, to do the calculation and update manually would be time prohibitive, and if not done perfectly, we might end up with a positive or negative dollar amount in inventory when the quantity is zero rather than $0 as it should be.