Solved

Purchase Order Import Scenario Issue


Userlevel 3
Badge

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.

icon

Best answer by jwestermann17 27 July 2022, 00:10

View original

6 replies

Userlevel 6
Badge +5

@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?

Userlevel 3
Badge

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. 
 




 

Userlevel 6
Badge +5

@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?

Userlevel 3
Badge

Hi @hkabiri,

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

 

 

Userlevel 7
Badge

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

Userlevel 3
Badge

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.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved