Skip to main content

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.

@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


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.


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.


Reply