Skip to main content
Answer

Import scenario to update GL account on balanced invoices

  • June 28, 2023
  • 2 replies
  • 135 views

Forum|alt.badge.img

Creating an import scenario to mass update the detail section line of a group of invoices. I seem to be adding a new line rather than updating the existing one.

 

Here’s my import scenario which is adding a new line and updating to account 40005 instead of updating the existing line.

 

Best answer by ed.goodman

@jwarren, Your mapping looks correct except for the record that reads <Line Number> and =-1.  That is the standard record to add a new line.  Deactivate that record and your mapping should function as desired.  If not, try updating the custom key field to match the actual field name (ie. @@LineNbr instead of @@linenbr).  Upper case vs lower case may make a difference when it comes to custom key field names.

2 replies

Forum|alt.badge.img+7
  • Captain II
  • June 28, 2023

The Line Number value of -1 is causing the new record to be created.  Assign the line number key value from your source field that holds the line number to update to the <Line Number> row.

You should be able to then removed the Line Nbr row from the import.


ed.goodman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Employee
  • Answer
  • June 28, 2023

@jwarren, Your mapping looks correct except for the record that reads <Line Number> and =-1.  That is the standard record to add a new line.  Deactivate that record and your mapping should function as desired.  If not, try updating the custom key field to match the actual field name (ie. @@LineNbr instead of @@linenbr).  Upper case vs lower case may make a difference when it comes to custom key field names.