Remove specific item lines from the PO/SO through CSV

Scenario

User uploaded many po/so with line items, which is not part of it. So, user would like to remove the wrong item lines.

Solution

1. Create a csv import file with following mandatory fields
   a) internal id of the PO/SO
   b) Line ID of the item
2. After file preparation, Go to Setup > Import/Export > Import CSV Records
3. On scan & upload CSV file, Select
   a) Import type: (Transaction)
   b) record type: (so/po)
   c)select one file to upload
   d)Click next button
4. On the Import option, Select
   Data handling: add/update/ add or update
   a) under Advanced options,
   b) Check: validate mandatory custom fields
   c)Under Advanced Options > Overwrite Sublists = TRUE
   d) Click next
5. On field mapping,
   Map the fields:
   a)Internal id = internal id (can be found under the PO / SO field)
   b)Line id = line id (can be found under PO- items/ SO – items)
   c)Click next
6. On save mapping & start import
   • Enter an import name
   • Click Save & Run.