- Flexera Community
- :
- Flexera One
- :
- Flexera One Forum
- :
- Duplicate Vendor Issue
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have multiple duplicate vendor listed in All vendor list and purchases are added to them. Kindly let me know how can i move all purchases and assign to single vendor and delete the duplicate. Since moving single purchases is time consuming.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That sounds like a messy situation!
If you can prepare a spreadsheet that maps purchase records to the vendor records you want (using suitably unique identifying field(s) for both record types), you could consider developing a business adapter to update the Vendor field on the identified purchase records.
Deleting vendor records would probably need to be done through the UI. Business adapters can't directly delete vendor records.
And one other thought to consider: If you are using FlexNet Manager Suite On-premises (not Cloud) and are a bit of a wiz with working directly with the SQL compliance database, you could potentially look to use SQL queries to update details directly in the database. You would be needing to look to update VendorID references across any tables where they exist (such as dbo.PurchaseOrder for purchase orders). However I wouldn't normally recommend directly updating data in the database unless you are very confident in what you are doing.
This thread has been automatically locked due to inactivity.
To continue the discussion, please start a new thread.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That sounds like a messy situation!
If you can prepare a spreadsheet that maps purchase records to the vendor records you want (using suitably unique identifying field(s) for both record types), you could consider developing a business adapter to update the Vendor field on the identified purchase records.
Deleting vendor records would probably need to be done through the UI. Business adapters can't directly delete vendor records.
And one other thought to consider: If you are using FlexNet Manager Suite On-premises (not Cloud) and are a bit of a wiz with working directly with the SQL compliance database, you could potentially look to use SQL queries to update details directly in the database. You would be needing to look to update VendorID references across any tables where they exist (such as dbo.PurchaseOrder for purchase orders). However I wouldn't normally recommend directly updating data in the database unless you are very confident in what you are doing.
