Skip to main content

Hello, i am trying to update multiple field values using a business event action attached to a GI. 
My Import Scenario has all necessary fields, but my business event won’t work.

I always get the following error and we can’t see why he would need this. 
The Formula for “Type” returns the Shortcode for Dropship - so just DP.
 


 


I created:

  • Generic Inquiry
  • Data Provider (Business Events)
  • Import Scenario
  • Business Event

Any ideas? We are clueless.

@jwestermann17 

I tested locally and I can confirm the Import Mapping looks fine unless there is something with that formula mapped to OrderType field or something on module configuration.

Can you test by mapping the type from the POOrder.OrderType insetad of formula or just hardcode =’DP’ for the record you are sure it is a DropShip and test.

I also wonder you have the feature Business Account Locations enabled?


Hello @hkabiri 

I’ve tried mapping POOrder.OrderType before but got a Error: “The string value provided exceeds the field ‘Type’ lenght.

Mapping it hard to =’DP’ did the trick and the error disappeared.
I am wondering what is the difference between this and our formula?

This is what we used for the Formula to receive just “DP” as value. 
 




 


@jwestermann17 

It is probably related to the Translation you have for the field. I also get an error if I put the type on same formula as you did. Due to the fact we have overridden the DAC passing the value from DB field.

BTW, have you customized this field?


Hi @hkabiri,

no, the field is standard. 
We did not customize the field.

 

 


Hi @jwestermann17 - were you able to find a solution for your issue? Thank you!


Hi @jwestermann17 - were you able to find a solution for your issue? Thank you!



Hi @Chris Hackett, for our use case it was enough to use =’DP’ for the OrderType.
But it would be nice to find a better solution to this instead of hard mapping.


I am facing a very similar issue. The hard-coding is working for me in my IMPORT SCENARIO, but the formula fails to insert the record.


Reply