Symptom: When editing the Employee Badge in Labeler, there is a column in the data for department_id, but the number there does not match out Department Code or Department Name that we entered into Mobile Asset.

Cause: The id number shown is the record number SQL Server uses to reference the department data on a different database table.

Resolution: Download and extract this file on your database server machine: https://dl.waspbarcode.com/wasp/supportfiles/Assetv7EmpBadgeLabelView.zip

If you are running the Enterprise version of MobileAsset and the database is installed to your own SQL Server, edit UpdateDB.wql with Notepad or similar text editor to replace server=(local)\waspdbExpress with your correct instance name, and set password= to your correct sa password.

Run FixEmployeeBadgeLabelView.bat to update the database view, and the next time you open the label, it should show two new columns: DeptName and DeptCode.