Skip to main content
Answer

Difference between Line Number and @@LineNbr?

  • May 9, 2025
  • 3 replies
  • 278 views

Forum|alt.badge.img+1

I’m hoping someone can confirm something for me.  I’m working on an import scenario to update PO Lines.  The source is a GI that brings back POLine records that meet the criteria that I want to update.  The data includes the PO Type, PO Number, and PO Line Number.

I first tried using <Line Number> (turning off the automatic <Line Number> = -1, of course).  If I use this, to get somewhat reliable results I have to subtract 1 from the line number in the GI.  But then when I hit a PO that has had a line deleted (I used one that had only one line, but it was Line 2 because the original Line 1 was deleted), I can’t select the line.

If I use @@LineNbr, I can use the exact line from the GI.

What I’m thinking (and this is probably one of those “Duh, didn’t you know that?” things)--<Line Number> references what line in the details grid to load.  The actual Line Number value on the line doesn’t matter--in my scenario above with the lone Line 2, if I set the <Line Number> value to 0, it updated.  

@@LineNbr, on the other hand, tells the import scenario to basically filter the grid to anything where the Line Number value in the grid matches the line number I provided.

Best answer by Naveen Boga

@lairdtim In the import scenario, The @@ line instructs Acumatica to look for a line having a matching Line. If found, that line will be selected and the mappings that follow will apply to that line. If not found, a new line will be added.

The article below provides a detailed explanation of the import scenario and should help clarify the process. I hope you find it helpful!

 

https://www.eis.consulting/post/acumatica-import-and-export-scenarios-tips-and-tricks

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • May 10, 2025

@lairdtim In the import scenario, The @@ line instructs Acumatica to look for a line having a matching Line. If found, that line will be selected and the mappings that follow will apply to that line. If not found, a new line will be added.

The article below provides a detailed explanation of the import scenario and should help clarify the process. I hope you find it helpful!

 

https://www.eis.consulting/post/acumatica-import-and-export-scenarios-tips-and-tricks


riglesias
Acumatica Employee
Forum|alt.badge.img+2
  • Acumatica Employee
  • May 12, 2025

Hello ​@lairdtim 

Here’s a link for a webinar where you can find an example that illustrates how to map the scenario to update lines from a grid (minute 44:56): 



Hope it helps.


plambert
Semi-Pro I
Forum|alt.badge.img+2
  • Semi-Pro I
  • May 13, 2025

A good note to help distinguish the two is that <***> denotes an action, while @@*** is a lookup. With <Line Number> you also have access to -1 (Add Row) and -2 (Delete Row), which you can’t exactly do with @@Line Number.