Solved

Import Scenario to Change Ship Via

B
Rank
Userlevel 4
Badge

Hi all, 

I’m trying to create an import scenario to change the ship via when an order includes an alcoholic item. 

I’ve created a GI to catch all the orders with the targeted items, and then have a business event setup to run every time a record is inserted into this GI. The business event then runs the import scenario. 

It says it’s running without errors, but the sales order ship via’s are not changing. And also, it looks like the business event is running multiple times instead of just once per record? 

Anyone know what I might be missing? 

Thanks!

 

icon

Best answer by manikantad18 30 June 2023, 18:26

View original

11 replies

manikantad18
Rank
Userlevel 7
Badge +12

Hi @bclark 

Please share the Business event xml and GI to review quickly and update.

Thanks

Acumatica Functional Consultant
B
Rank
Userlevel 4
Badge

@manikantad18

I’ve attached the XML for the Business event, generic inquiry, and the import scenario. 

Thanks for looking into this!

I’m not having issues with the GI as much as the rest of the process. 

3 Attachments
manikantad18
Rank
Userlevel 7
Badge +12

Hi @bclark 

Please Update the IMport scenario like this and share feedback,if not resolved I will look into Business event file shared

 

Acumatica Functional Consultant
B
Rank
Userlevel 4
Badge

@manikantad18 

I originally had that value as just “Ship Via” and had changed it to Ship Via→ Ship Via to test things. 

I switched it back now, but it still is not changing the ship via on the sales order. 

manikantad18
Rank
Userlevel 7
Badge +12

Could you please uncheck on Order hold for now, and check if the Business event is working or not?

 

Acumatica Functional Consultant
B
Rank
Userlevel 4
Badge

@manikantad18 

I’ve unchecked the Hold buttons. The business event appears to be working without errors. Is there another way to check that the business event is working as it should?

 

manikantad18
Rank
Userlevel 7
Badge +12

Hi @bclark 

to verify quickly I have disabled all the conditions in the Generic inquiry and made the record change when the sales order status changed from Hold to open and run an import scenario to update the ship via.

I verified with one sample and it worked.

Attached are GI, BE and  Import scenarios for reference,

Please Upload in the test instance first.

Trouble shooting steps:

If you still think the Business is not working then Please uncheck all conditions in the generic inquiry As I do and start checking which condition causing a conflict.

3 Attachments
Acumatica Functional Consultant
B
Rank
Userlevel 4
Badge

@manikantad18 

I was unable to get it to work with the new uploaded XML versions you provided. 

I also am confused as to why it would something with the GI. The conditions I had in the original GI are exactly what we need, and the sales orders were showing up on that screen appropriately. 

The business event is set to run whenever a record is inserted into that GI, and I haven’t had issues with the sales orders showing up on that screen. 

Still experiencing issues with the import scenario not changing the shipvia. 

manikantad18
Rank
Userlevel 7
Badge +12

Hi @bclark I request you, please Uncheck all the conditions and verify once.

In a General way, the Acumatica Import scenario runs but it will not update the results that we needed, sometime it will show wrong error nformation.

 

Acumatica Functional Consultant
B
Rank
Userlevel 4
Badge

@manikantad18 

I did try running it with all the conditions unchecked, with the new XML versions you shared. 

It did not work. 

manikantad18
Rank
Userlevel 7
Badge +12

Hi @bclark 

I have one last suggestion.

In your generic inquiry there are some keys are missing, for any Business events all keys fields are needed/

For example

You have used PX.Objects.AR.Customer table in the GI but there is no key d added.

Key field which is yellow in colours

 

I hope when you uncheck you have added one condition in your GI, sales order - Open status.

when the sales order comes moved from Hold to open it did not update the ship via?

Thanks

Acumatica Functional Consultant

Reply


Terms & ConditionsCookie settings
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