We are needing to change the price that we invoice for on consignment items as our pricing fluctuates each month. The scenario is:
- We send 100 consignment parts to the customer on May 15th - These were against a customer order and price of $1.00 each.
- The customer consumes them on June 15th - The new price for their item in June is $1.10
- When we invoice them, it is going against the original customer order at time of shipment ($1.00 each)
- We tried updating the customer order pricing before consuming out of consignment but it still pulls the pricing at time of shipment
Anyone else doing this and any ideas on how to handle?