dawn@comfortfoods.
Member


No...no...don't make me go into edit database!
Posts: 69
Gender:
|
Thanks for the Lot Control Exceptions Report - very useful for us! The difference collumn is confusing and displays the wrong number. The difference collumn carries the previous items difference quantity until it reaches the end of the next item. For example: Item Description Lot Lot UOH Location UOH Difference 1 Stuff XX 273 928 0 1 Stuff YY 895 928 33 2 MoreStuff AA 5 614 33 (This is the error - 33) 2 MoreStuff BB 61 614 33 (Still wrong) 2 MoreStuff CC 555 614 -7 (this is now the correct number) So either the second & third "33" in the difference collumn should be zero or -7, or it could be the running difference - but I think that would also be confusing. Thanks - keep up the good work ISTS!
|