After uploading your demand in Demand Management, an orange notification at the top will indicate if there are any duplicate lines present. You can either Consolidate or Remove the duplicate lines to resolve this error.
Click on the Lines with Duplicates alert to filter your list for only the duplicated lines. You will see the Duplicates filter listed above your line items once the filter is applied. Click the 'x' in the filter to remove the filter when needed.
Consolidating or removing your duplicate lines is helpful when working on a large list. You can see what is recognized in your demand list as duplicates within its Template Settings.
Consolidate Duplicates
Consolidation allows duplicate lines to be combined and their quantities aggregated. Consolidating cannot be undone. You can start the consolidation of lines by individually clicking them, or by using the "Select All" function to choose all of the filtered duplicates on the page. When there are additional pages of line items, you will be asked if you want to select all the duplicate items in the project. Click on the blue link to select all pages (if applicable).
In the top navigation bar click on Project and then click on Consolidate in the dropdown.
Within the Consolidate modal, you can choose to consolidate your quantities by the following options:
- IPN/CPN
- MPN
- Manufacturer
- Plant
- Subcontractor
When selecting to consolidate by multiple options, it then requires that parts must meet and match all of the checked criteria in order to be consolidated. Click on Consolidate to complete.
Your line items will have been consolidated based on your selections. Then click the “x” next to the filter name when finished to clear the filter and see all of your line items.
Remove Duplicates
Another option is to your remove your duplicates. This will keep one unique record by mass deleting all duplicates with the click of a button. This will completely delete your duplicate lines instead of consolidating them and cannot be undone. Click on Remove Duplicates in the top navigation bar.
Within the modal, click on Yes to confirm that you want to Remove duplicates. Your duplicate lines will have been deleted. Then click the “x” next to the filter name when done to clear the filter and see all your line items.