How to link purchases to an MIP Asset Number

1. Create “Asset No” User Defined Field and set the control type to “LookupEdit”. Use the SQL script below to populate the UDF with  a list of MIP’s active assets.

SQL Script: Select sAssetID, sDescription from MIPDBName.dbo.tblFACode where sStatus='A' (NOTE Change the MIPDBName to your MIP database name)

2. Map the ENC Module to use the new UDF Asset No.

3. When creating a purchase order, employees are able to link the purchase to an existing asset number for reporting purposes