Dear Community,
I was wondering of there is any "quick fix" for Publisher Names. When creating my compliance report I can see that could be 1, 2 or 3 Publishers with the same name or typo error.
What would you do to sort this? Would you do it at the Purchase level?
Many thanks,
Victor.
‎Nov 20, 2019 09:27 AM
Hi Victor,
Yes, Purchase level is where I usually fix such things. Assuming you have FNMS on prem, here would be the quick & dirty approach if you have access to the database:
If you have FNMS Cloud, you will have to stick to a Business Import to update your PO data. Also, the Business Import might be a better maintainable solution, if you think this problem is going to occur repeatedly.
Best regards,
Markward
‎Nov 20, 2019 01:41 PM
Hi Victor,
Yes, Purchase level is where I usually fix such things. Assuming you have FNMS on prem, here would be the quick & dirty approach if you have access to the database:
If you have FNMS Cloud, you will have to stick to a Business Import to update your PO data. Also, the Business Import might be a better maintainable solution, if you think this problem is going to occur repeatedly.
Best regards,
Markward
‎Nov 20, 2019 01:41 PM
‎Nov 21, 2019 01:51 PM
@Victor_MacBeath - One method that is used to ensure that consistent Publisher Names are imported into FNMS from your purchase data would be to:
1) Take the purchase data to be imported into FNMS and load it into a SQL Staging database
2) Within the SQL Database, normalize all of the Publisher Names to a consistent value that exists in FNMS
3) Write a Business Adapter that reads from the staging database and uploads the purchase data to FNMS.
Another option to prevent extra publisher names from being created in FNMS:
1) Change the Business Adapter so that for the Publisher Name matching, DO NOT create a new vendor in FNMS if the imported publisher name does not exist in FNMS
2) This would require that you monitor new purchases that are imported into FNMS and look for blank publisher names and assign the correct publisher name within the UI.
The last option (which in reality is probably not possible) would be to clean up all of the publisher names in the original source of data that is providing the Purchase Data to be imported into FNMS
‎Nov 21, 2019 02:54 PM