Skip to main content
Solved

Import Scenario to Change Sales Account Not Making Changes

  • Feb 27, 2025 1:46 PM UTC
  • 11 replies
  • 171 views
  • Translate All

We have a GI-based Import Scenario to change the sales account on the sales order lines that says it’s completing, but is not actually making the change. I have tried changing different things (looking for line number rather than inventory id & vice versa, or selecting/deselecting commit on different fields), and cannot get the change to actually happen. What am I missing here?

 

 

Best answer by dcomerford

​@DMT Try this now

 

View original

11 replies

dcomerford
Captain II
Forum|alt.badge.img+16
  • Captain II
  • Feb 27, 2025 2:30 PM UTC

​@DMT This is one i did for Purchase Receipts

Your <Line Number> should be  = 0

Remove Inventory and also you dont need Customer and Locations

Translate

  • Author
  • Freshman I
  • Feb 27, 2025 5:39 PM UTC

Thanks ​@dcomerford. I made the changes you suggested, and when I deactivate customer & location, I get the “x items have not been processed successfully. View name: Document” error.  When I just made the change to the line number and deselected inventory id, it still did not make the change (but said it did). 

Translate

dcomerford
Captain II
Forum|alt.badge.img+16
  • Captain II
  • Feb 27, 2025 5:41 PM UTC

​@DMT Can you share the screen shot of the import scenario

Translate

  • Author
  • Freshman I
  • Feb 27, 2025 5:56 PM UTC

​@dcomerford , sure. Thank you!

 

Translate

dcomerford
Captain II
Forum|alt.badge.img+16
  • Captain II
  • Feb 27, 2025 6:06 PM UTC

​@DMT This line should be Line Nbr to Line Nbr as per my screen shot

 

Translate

  • Author
  • Freshman I
  • Feb 28, 2025 2:03 PM UTC

​@dcomerford , I made the change, and when the Line Nbr line is inactive (like screenshot below), it’s the same issue--says it changed but it didn’t. When I select it, it gives me an error of the unit conversion is missing.

 

 

Translate

dcomerford
Captain II
Forum|alt.badge.img+16
  • Captain II
  • Mar 1, 2025 1:59 PM UTC

​@DMT Can you share me the import scenario will test it on my local pack as that sounds like it is adding not updating a line

Translate

Forum|alt.badge.img+11
  • Captain II
  • Mar 3, 2025 11:15 AM UTC

HI ​@DMT 

 

Have you tried deactivating the <Line Number> line?

 

Aleks

Translate

  • Author
  • Freshman I
  • Mar 3, 2025 2:36 PM UTC

​@dcomerford , here’s the XML. Thank you for your help so far on this. I appreciate it.

Translate

  • Author
  • Freshman I
  • Mar 3, 2025 2:37 PM UTC

​@aiwan , I did. It still does not make the change.

Translate

dcomerford
Captain II
Forum|alt.badge.img+16
  • Captain II
  • Answer
  • Mar 10, 2025 3:42 PM UTC

​@DMT Try this now

 

Translate