Start a conversation

Using QES - Incorrectly set Item Tracking Type - ItemTrackingSID

The item tracking type is not used for any logic other than showing and hiding the serial lot tabs and enabling or disabling the serial lot entry areas on different forms.  Editing the HQMS_items_1 table ItemTrackingSID field to modify it incase of accidently putting the wrong tracking type is not a problem as long as the user has not entered any serial or lot numbers against the item.

The main issue is that the user manually enters an item and the ERP import process is enabled.  When serial or lot numbers are imported QES will not allow the user to change the tracking type from the user interface.  The user can

If a user has entered serial or lot numbers against that item then the ItemTrackingSID should not be changed without consulting Horizons Support. 

The ItemTrackingSID's are as follows
11001    None    
11002    Serial    
11003    Lot    

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Jaydel Gluckie

  2. Posted
  3. Updated

Comments