We are running Item Modifier but we are getting Primary Key errors on MPA01000. Currently our Item Numbers are UPC Numbers but we are switching over to Friendly Short Names- this is causing problems in the MPA01000 table since some items are in there with the Friendly Short Names already (not sure how that happened, plus it even has some non-inventory items).
The question is: does anyone know where this MPA01000 table links up to a window (in GP8 or Dynamics9) or how this table gets populated? We need to clean out this info but we don't want to delete directly out of the table (unknown repercussions). We already checked the Tools > Resource Descriptions > Tables but couldn't find where this table is used.
We have Manufacturing and Fixed Assets installed. MPA01000 is the MRP Activity File (Manufacturing MRP) but we can't find documentation or any info from GP concerning this specific table about where and how it is used.
The question is: does anyone know where this MPA01000 table links up to a window (in GP8 or Dynamics9) or how this table gets populated? We need to clean out this info but we don't want to delete directly out of the table (unknown repercussions). We already checked the Tools > Resource Descriptions > Tables but couldn't find where this table is used.
We have Manufacturing and Fixed Assets installed. MPA01000 is the MRP Activity File (Manufacturing MRP) but we can't find documentation or any info from GP concerning this specific table about where and how it is used.