Quote from Tim Keating on 05/03/05 at 07:35:45:I agree that a safeguard would be very desireable. In my experience, double issues can always be tracked to input error but it should not be that easy to make the error.
It is very disheartening how many of these little gotchas are in DBA.

SOP should be that no part of the transaction is committed until all of the transaction variables are validated. It would be better to lose the entire transaction when a problem occurs than to capture part of it and then waste time figuring out what to fix. I understand that the Serial module is separate from the inventory transaction module, but losing the one-to-one relationship between those two bits of data is a big issue in the eyes of our regulators.