We’ve discovered an issue from the looks of it between the net weight entered on the part catalog and the total net weight on the customer order. Our general rule for the part catalog UOM is that we match the inventory UOM as there is no conversion (that we know of) between the part catalog record and the inventory part record. We tend to set our inventory parts up as to how we are going to store/consume the product which we believe is best practice.
Either way, one of our parts net weight for a CS (which is our inventory UOM and Part UOM) is 220 lbs. We have this setup to SELL in EA (we have 200 EA/CS and 1 EA is .005 of a CS). What happened is, our customer, who also orders in eaches, put in a desired qty of 2000. It looks like the conversion is not looked at as the total net weight of the order turned out to be 440,000 lbs when it should have been a total of 2,200 lbs. I can get to this number if I multiply the qty requested (220 lbs * .005 conversion gives me my EA weight then multiply that by the qty of EA requested. Does anyone else have this problem? Is there a field that we aren’t taking into account or a checkbox that can be set so we get accurate weights?
What’s worse, the inventory part net weight, read only field pulls from the part catalog record and that CS qty is not equal to 1.1 lbs.
