List of Contributions

I have new codeset values being created in our ERP's quite frequently and I'll like to know the best method by which to automatically add these to our Enterworks environments. Our ERP system is in an Azure database (replicating from our source AS400 environment).    I have SQL's which give me the ...

Hi Jon, Try this: SELECT s.internalRecordId FROM SKU_STAGING s JOIN (SELECT DISTINCT a.SKU_Number FROM AREA_STAGING WHERE a.Status != 'Discontinued') a ON s.SKU_Number = a.SKU_Number The inner select of  (SELECT DISTINCT a.SKU_Number FROM AREA_STAGING WHERE a.Status != 'Discontinued') just ...

Some great ideas here!   I'll see what I can do to explore several of them to see what works for me. Thank you very much! ------------------------------ Rick Spencer | PIM Administrator Animal Supply Company | 972-474-6949 ------------------------------

Hi Jon, I've looked into using the Record Security Filters for specific User Groups but unfortunately as you've stated it completely cuts off visibility for the users of one ERP from seeing the others. I have common attributes used by all ERP's. I want each ERP to have control over these common ...

Is there a way currently to filter a list of records based on the preference used? We have 5 different ERP's in our company and I'd like to be able to chose a Preference that maybe is called "West ERP Details", and besides having it display the list of chosen attributes, it also automatically filters ...

Hi Kerry, I am the PIM System and Data Administrator for Animal Supply Company.  We have been using PIM now since 2018 to help consolidate 5 ERP systems. I am a huge movie buff, primarily action and adventure, also the occasional rom com, but my favorites are Zombie movies and of course the Walking ...