Does anyone know how the TotalQtyAvg on PartLot is calculated or where it comes from? The field description isn’t particularly helpful. Every plant/company at my place uses avg costing for every part, and I am trying to figure out why a part would have a 0 TotalQtyAvg for a given lot when I can see that that same lot has on hand qty via the PartBin table.
The actual issue is that we have an email that gets sent out when someone ships parts in non FIFO order (ie they should be shipping the oldest parts on hand if we have multiple lots in stock), and since we use that TotalQtyAvg for the older lot quantity, users are thinking that the email is incorrect. The obvious solution would be to show the PartBin.OnHandQty for that part and lot, but I don’t know if there are any side effects of that that I may not be aware of.