Solved

Import scenario to update PO lines

  • 25 January 2023
  • 5 replies
  • 471 views

Userlevel 6
Badge +3

Hello,

I want to remove all NOTES from all PO lines.  I created a GI and exported to excel all PO IDs and all of their line numbers.

I created a data provider with these 2 fields.

I then created an import scenario to replace the notes with nothing.

I can get this to work for the first PO line number without specifying the line number.  However, when I introduce lines into the scenario to select all PO lines, it throws an error like it is trying to add a line to the PO instead of simply updating the NOTES.

For my @@Line Nbr. line, I don’t see the PO Line number as an available field.  The “Transactions.LineNbr” is the only line number field available in “Internal Fields”.

Any suggestions?

 

icon

Best answer by manikantad18 25 January 2023, 16:31

View original

5 replies

Userlevel 6
Badge +3

Further information.  The goal here is to blank out the notes on all PO Lines.  So if there is a way to do that without first exporting a GI with PO ID and PO line number, that would be best.

 

Userlevel 6
Badge +3

Latest attempt.  Added PO ID @@Order Nbr selection.  Getting error about the vendor ID now.

 

Userlevel 7
Badge +12

Hi @ltussing03 

Userlevel 6
Badge +3

Thank you!!!

 

I really appreciate you taking the time to post this!

Userlevel 5
Badge +2

Larry, one other thing here.

For the Note Text record, you have =’’ for the Source Field / Value.

With that value, the system is expecting something to be added, which is why it is attempting to add a new line.

If you are wanting to blank out a field, your Source Field / Value should be =Null.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved