Could a log be made available in your warehouses to track direct purchases? Quantity, Cost and Avg. cost per crate(bar)?
Not everything is purchased to be sold today, so being able to see what your cost are in storage across 21 ports would be helpful.