Skip to main content
Solved

Create Service Orders via import scenario

  • Mar 11, 2025 10:06 PM UTC
  • 5 replies
  • 203 views
  • Translate All

I created an import scenario to create new Service Orders.  It only works when I run a row individually?  Does anyone know why this is happening??  

 

Best answer by hkabiri

​@KShepherd  That is not the proper way to map RefNbr you need one line for defining the key fields which are srvordtye and RefNbr and one line for each of these keys values from the data provider. In your screenshot you pass the value of refNbr to the Key and mapped the orderType value twice.

 

Now look at this import scenario which you can see how I defined the keys and mapped value to the key fields

 

View original

5 replies

hkabiri
Acumatica Moderator
Forum|alt.badge.img+8
  • Acumatica Support Team
  • Mar 11, 2025 10:26 PM UTC

​@KShepherd That is because you do not have any mapping for the RefNbr. You need to map RefNbr to a field which has unique value if you have auto numbering on Service Order Numbering Sequence.

Translate

  • Author
  • Freshman I
  • Mar 11, 2025 11:35 PM UTC

But i want to create NEW Service orders and generate a new Ref Number.  I read that i should remove the RefNumber but the scenario requires it.  In my file the Service Order Number column exists, but it has no values.  

Translate

  • Author
  • Freshman I
  • Mar 11, 2025 11:51 PM UTC

In my import file i numbered the Service Order Numbers with unique values then updated the scenario to this…. still only allowing processing one at a time:

 

Translate

  • Author
  • Freshman I
  • Mar 12, 2025 12:07 AM UTC

oh and thank you all for whatever help you can provide - and details!  I’m 14 months post implementation but eager to learn:)

Translate

hkabiri
Acumatica Moderator
Forum|alt.badge.img+8
  • Acumatica Support Team
  • Answer
  • Mar 17, 2025 9:17 PM UTC

​@KShepherd  That is not the proper way to map RefNbr you need one line for defining the key fields which are srvordtye and RefNbr and one line for each of these keys values from the data provider. In your screenshot you pass the value of refNbr to the Key and mapped the orderType value twice.

 

Now look at this import scenario which you can see how I defined the keys and mapped value to the key fields

 

Translate