Skip to main content
Solved

Business Event and Import Scenario run but no record change

  • February 26, 2024
  • 9 replies
  • 214 views

Forum|alt.badge.img+2

I have a business event that I am trying to make so that it creates an opportunity and a quote for certain business accounts on a regular basis. I have set up the business event to run an import scenario on a schedule and everything seems to work fine, except there is no actual opportunity or quote created.

I set up the import scenario separated from the business event with the exact same settings and source and it runs perfectly. The automation schedule runs correctly and both the schedule and the business event say they run without any errors. 

I have tried setting up a task template (using the business account id as the related entity) as a second subscriber and it creates the task successfully, just without the related entity. This makes me think that there is something wrong with my generic inquiry that is not passing the business account ids properly to my business event. 

Any input would be appreciated!

Thanks,

Drew

Best answer by DrewNisley

So, I feel a little stupid here but I figured out the cause of the problem. Our test company that I was using to set these automation schedules has two branches and the account I was signed in as was only able to view one of the branches. I didn’t think about this, but the other branch that I couldn’t see was set up as the default for system actions or something like that. So all the opportunities that I thought were not being created were being created in the other branch which is why I could see the opportunities when I manually ran the import scenario, but not when it was on the schedule. 

I do appreciate the help though Daryl!

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

9 replies

darylbowman
Captain II
Forum|alt.badge.img+13

Without seeing what you have, there’s not a whole lot we’re going to be able to help you with. Can you share screenshots of the Business Event and Import Scenario?


Forum|alt.badge.img+2
  • Author
  • Semi-Pro III
  • 59 replies
  • February 26, 2024

 


darylbowman
Captain II
Forum|alt.badge.img+13

In your import, it looks like you have OpportunityID mapped to BAccount_acctCD. I’m guessing this is your problem. It should be mapped to the Opportunity ID field of your GI.


Forum|alt.badge.img+2
  • Author
  • Semi-Pro III
  • 59 replies
  • February 26, 2024

I have it like that so that it creates new opportunities for each business account. When I run the import scenario by itself without the business account, it works great and creates an opportunity and quote for each business account specified. The generic inquiry is solely to filter the business accounts I want to create an opportunity for. 

Although if there is a better way to do this, I am open to suggestions.


darylbowman
Captain II
Forum|alt.badge.img+13

Sorry, my bad. Try this instead: =CStr(0-LineNbr())


Forum|alt.badge.img+2
  • Author
  • Semi-Pro III
  • 59 replies
  • February 26, 2024

That formula works and my import scenario still works when I am running it outside of a business event, but it doesn’t work when I use it in a business event.

I checked the business event history and it looks like it is firing the import scenario for all three of the accounts I have marked, but nothing happens and there are no error messages


darylbowman
Captain II
Forum|alt.badge.img+13

I’m not sure why this isn’t working, but maybe you can come at this a different way. You don’t need to use a Business Event to run an Import Scenario on a schedule. You can base an Import Scenario on a GI (similarly to a Business Event) and schedule it to run through ‘Process Import Scenarios’. Just make sure when you’re creating the schedule that you add a Condition to filter the Import Scenarios to just the one you want to run or it WILL attempt to run them ALL.

 


Forum|alt.badge.img+2
  • Author
  • Semi-Pro III
  • 59 replies
  • Answer
  • February 26, 2024

So, I feel a little stupid here but I figured out the cause of the problem. Our test company that I was using to set these automation schedules has two branches and the account I was signed in as was only able to view one of the branches. I didn’t think about this, but the other branch that I couldn’t see was set up as the default for system actions or something like that. So all the opportunities that I thought were not being created were being created in the other branch which is why I could see the opportunities when I manually ran the import scenario, but not when it was on the schedule. 

I do appreciate the help though Daryl!


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2754 replies
  • March 1, 2024

Thank you for sharing your solution with the community @DrewNisley!


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