Skip to main content
Question

Unable to delete lines using @@LineNumber

  • June 19, 2026
  • 2 replies
  • 29 views

Forum|alt.badge.img

Hello all,

I have been trying to delete line item from SO Line using import scenario mapping as below where I am using Line Number as the sales order has same items being used in multiple lines, hence making use of Line Nbr to delete them out, however I am unable to delete them:

 

 

What is it that i am missing out or making a mistake?

2 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+16

@Harry Try using the below sample import scenario and write line number=-2 for delete.

 


bwhite49
Captain II
Forum|alt.badge.img+12
  • Captain II
  • June 19, 2026

You are missing a line as shown in Manikanta’s import, but you should stick with LineNbr as your key and not use Inventory. Using Inventory ID will only delete the first matching record, so line nbr is more reliable.

You might also need to add the LineNbr= -2 to just above the save. I think it needs to be below, but you can test which one works.