How to link purchases to an MIP Asset Number

How to link purchase orders 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


Creation date: 6/29/2020 12:21 PM      Updated: 6/29/2020 12:23 PM
Files   
image001.png
21 KB
image002.png
28.2 KB
image003.png
57.6 KB