I have always struggled with the Inventory module in SL. Especially arriving at year end inventory value to calculate Cost Of Goods Sold. The other issue I have is items with changing cost. Say I bought 100 locks in 2017 for $4.00 each. Sold 75 in 2017. Ordered 50 in January 2018 at cost of $4.75 each. Sitelink doesn't have an option for FIFO (first in first out) or Cost Averaging. Basically none of my cost figures are correct. For several years I tried to keep track of inventory and figures in my accounting software but it was taking too much time.
Any suggestions? Thanks Julie