Update SOLine 'Requested On' field with import scenario

Hi @timKallman ,

To start you will want to uncheck the line that sets <Line Number> to -1.  The -1 value tells Acumatica to insert a row.  Alternatively, leave this row active and replace -1 with the formula below.

Lookup the existing row either by <Line Number> or by the using the Inventory ID as a custom key.  Both lookups are not needed.  Use @@InventoryID in the Field/Action Name for the inventory id lookup.  However, if the same inventory id may appear multiple times on a Sales Order, then the Line Number is a better option.  Through trial and error I’ve found that the formula CInt([Line Order]) - 1 returns the correct row.

Hope this helps!

@timKallman Hey! I’ve experienced bugs in import scenarios before, so that can’t be ruled out if it was working previously.

However, I do see that you have the “Line Nbr. =-1” line set to active.
The line number should not be active for Import Scenarios that update existing lines. The mapping in your screenshot is correctly adding a new line based on the LineNbr. row being active.
 

Thanks for the suggestion, but unfortunately I’ve already tried unchecking the line with various combinations of the ‘commit’ checkbox with the other fields and it didn’t change the outcome. 

@timKallman Hey! I’ve experienced bugs in import scenarios before, so that can’t be ruled out if it was working previously.

However, I do see that you have the “Line Nbr. =-1” line set to active.
The line number should not be active for Import Scenarios that update existing lines. The mapping in your screenshot is correctly adding a new line based on the LineNbr. row being active.
 

 

Hi @timKallman ,

To start you will want to uncheck the line that sets <Line Number> to -1.  The -1 value tells Acumatica to insert a row.  Alternatively, leave this row active and replace -1 with the formula below.

Lookup the existing row either by <Line Number> or by the using the Inventory ID as a custom key.  Both lookups are not needed.  Use @@InventoryID in the Field/Action Name for the inventory id lookup.  However, if the same inventory id may appear multiple times on a Sales Order, then the Line Number is a better option.  Through trial and error I’ve found that the formula CInt([Line Order]) - 1 returns the correct row.

 

Hope this helps!

 

Could you provide a copy of your import scenario?
 

Your Order Summary is not correct you must lay it out as follows. Also remove the Inventory bits on the Details as you dont need it Linenbr will do. Also ensure the Line Number = -1 is not active. The one below updates discount (not mine but i have borrowed and used it for other feilds)

Your Order Summary is not correct you must lay it out as follows. Also remove the Inventory bits on the Details as you dont need it Linenbr will do. Also ensure the Line Number = -1 is not active. The one below updates discount (not mine but i have borrowed and used it for other feilds)

 

 

unfortunately this also doesn’t work, using this I get ‘unit conversion is missing’ as an error, I think because it thinks I’m still entering a new line into the order

Hi @timKallman were you able to find a solution? Thank you!

Hi @Chris Hackett, not yet unfortunately

@timKallman please try this

@johnythevara48 

I get ‘unit conversion is missing’ with that setup

@timKallman  Can you please share your updated import scenario?

@Naveen Boga 

Hi @timKallman  I just tried with the below import scenario and it is working as expected.

@timKallman did this work for you?
@Naveen Boga Followed this thread because I’ve been trying to do a similar action to update a field on an existing line item, and followed your steps here but I still get the same error mentioned about unit conversion. Is stopping us through all variations of the attempt above. Any other help on this would be greatly appreciated!