Skip to main content
Solved

Unable to delete lines using @@LineNumber

  • Jun 19, 2026 6:49 AM UTC
  • 3 replies
  • 123 views
  • Translate All

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?

Best answer by haarshita51

Make use of @@LineNbr instead of @@LineNumber.

 

Hope this helps!!

View original

3 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.

 

Translate

bwhite49
Captain II
Forum|alt.badge.img+12
  • Captain II
  • Jun 19, 2026 1:45 PM UTC

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.

 

 

Translate

Forum|alt.badge.img+5
  • Varsity III
  • Answer
  • Jul 10, 2026 5:56 AM UTC

Make use of @@LineNbr instead of @@LineNumber.

 

Hope this helps!!

Translate