On Wed, Apr 21, 2010 at 5:48 PM, BJ Freeman <[email protected]> wrote:
> you may confused by InventoryItEM and its variance. > see the Datamodel book Vol 1 page 84 > the product is the item you ordered > the inventory item is how many and where located. > Inventtory Item has a variance about how many you actually have. > > Ok, but the scenario is something like this: A purchase order is cut for Product 10000, qty 1, price $100.00. That item is then received. The person doing the receiving has no authority to vary the price, only to inspect it and give it a lot number (InventoryItemId.) Inventory record is written. After this, while invoicing, and long after the Order is "COMPLETED", we want to change the price, and have that altered price be reflected in the inventory record that was written. I'm obviously not communicating the scenario very well, and I don't understand how inventory variance can change an OrderItem line. I think I solved the problem for my shop by doing exactly that, making it possible to edit the price on an OrderItem after the fact, and having that price change update whatever inventory was received against that item, all while keeping the order closed. What I'm trying to learn is whether there are going to be any strange consequences from doing that.
