Monthly reprice of consignment goods

Summary:

We need to update prices of consignment goods on a monthly basis, including those that were received on a previous month, so the consumption advice matches the price agreed for the current calendar month and is also the price on our vendors' system.

Content (required):

I asked something similar on another thread, but we still cannot figure out the right solution. So, I am posting this question again with different focus.

We have consignment negotiations with around 70 vendors, where we need to reprice goods each calendar month to apply our currency hedging.

We issue a Consignment Order associated to a Consignment Agreement by vendor. The consigned goods are later received on +20 different warehouses.