Skip to main content
Solved

SO Import -Orders with multiple items- one order per item


Forum|alt.badge.img

Good day, see the attached SO import.  I have used it before and it worked to have one order with multiple lines items.  Now the scenario is importing one order per one line item.  The original file contents have changed; I did use the same columns remapping them.

Any suggestions;  I have orders with multiple lines.

Thank you

 

Best answer by vkumar

Hi @EvanG 

I have reviewed the scenario and made one change for following line.

Attached updated scenario. Let us know if that works. 

Regards,

View original
Did this topic help you find an answer to your question?

6 replies

Forum|alt.badge.img+12
  • Acumatica Support Team
  • 871 replies
  • Answer
  • April 22, 2022

Hi @EvanG 

I have reviewed the scenario and made one change for following line.

Attached updated scenario. Let us know if that works. 

Regards,


Forum|alt.badge.img
  • Author
  • Varsity I
  • 93 replies
  • April 25, 2022

Thank you for your assistance.  I found your assistance very valuable and was able to import the sales order information.

 

Evan


Forum|alt.badge.img+12
  • Acumatica Support Team
  • 871 replies
  • April 27, 2022

@EvanG you are most welcome!

 


Forum|alt.badge.img
  • Jr Varsity III
  • 65 replies
  • June 10, 2022

Hi @vkumar , if i wanted to remove the hold for these SO with multiple items, how would i go about that? I tried on my import scenerio and received the error The Remove Hold button is disabled. However, the import works for orders with a single item. i attached my import scenerio if you can take a look and help.


Forum|alt.badge.img+12
  • Acumatica Support Team
  • 871 replies
  • June 11, 2022

Hi @marisa10 

Are you importing a new SO and then marking them as Open ( remove hold )? or are you trying to update existing SO as Open ( release from hold )? Error indicates that the SO you are trying to update does not have ‘Remove from hold’ action ‘Active’.

You may move this as a new thread as well.

Regards

 

 


Forum|alt.badge.img
  • Jr Varsity II
  • 25 replies
  • August 25, 2022

Hello,

I downloaded the change that @vkumar presented going from [order Nbr→order Nbr] to just [order Nbr].

I am trying to use this import, however the import scenario is currently only adding the last line of the upload file.

I have not changed any of the columns but I have changed the data within. It shows no errors for the other lines and says that the import was successful and that the other lines were processed. 

I think the issue is that it is not saving until it hits the very last line, even though I would want it to save on each new order.

Any advice?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings