| Subject: | Asset Management - Import Assets From File - Delete Order has missing Fields | | Summary: | When importing assets in the Asset Management Modue in Epicor, we found that the Delete Profile only contained the ASSET Control Number. When importing assets, we need to provide the file layout the sme as the IMPORT layout, which caused a problem as the delete layout had one field.
To correct the problem, we can run the script below which will create all the fields in the DELETE profile similar to the IMPORT and UPDATE profile
-- START of SQL Script
Insert into imaction
select 1,0,1,field_id,file_order,field_default_is_null, field_default, update_allowed, required_field, nulls_allowed
from imaction where file_type = 0 and action = 0 and field_id <> 1
-- select * from imfields order by field_id
-- select * from imaction order by file_type,action,file_order | | Audit Notes: | |
|