Skip to main content
Question

How to trigger sales order and create sales commission through business event.


Forum|alt.badge.img

Hello Expert, i am getting stuck in on of the business event scenarios i.e once sales order is created business event will get trigger and create a commission sales for that sales order. I have created business event and import scenario for the same but was unable to trigger the business event.

Please have a review and let me know if i am missing out something

9 replies

dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 622 replies
  • January 31, 2025

@vishalsharma49 What’s in the Business Event History as in is the Business Event being triggered or it is and it is failing.

Generally if the Business Event is not being triggered it is because all the key fields on the table in the Generic Inquiry are not on the Results grid of the GI.


Forum|alt.badge.img
dcomerford wrote:

@vishalsharma49 What’s in the Business Event History as in is the Business Event being triggered or it is and it is failing.

Generally if the Business Event is not being triggered it is because all the key fields on the table in the Generic Inquiry are not on the Results grid of the GI.

It is my GI which i have created to use business event. Have used only two tables. 

 


Forum|alt.badge.img+8
  • Captain II
  • 362 replies
  • February 7, 2025

HI ​@vishalsharma49 

 

As ​@dcomerford said, you need the key fields of all tables in your GI, so that includes SOOrder.OrderNbr & SOOrder.OrderType

 

Aleks


miguel80
Semi-Pro II
Forum|alt.badge.img+1
  • Semi-Pro II
  • 71 replies
  • February 12, 2025

Hi,

I’ve found that using a GI that has “Grouping” won’t trigger the business event. Does your GI have a Group?

Perhaps you can try using a GI that doesn’t have the SOLines and only the SOOrder for the business event and another one for the scenario.


Forum|alt.badge.img
  • Author
  • Freshman I
  • 31 replies
  • February 13, 2025
miguel80 wrote:

Hi,

I’ve found that using a GI that has “Grouping” won’t trigger the business event. Does your GI have a Group?

Perhaps you can try using a GI that doesn’t have the SOLines and only the SOOrder for the business event and another one for the scenario.

Hi Miguel, I do not have any grouping in my GI


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

@vishalsharma49 

First can you confirm if you are able to update the commissonable checkbox using import scenario with business events.

 

2nd. if above steps 1 is working then We need to investigate the business events using record by change, 

 

Make sure all the Keyfields which are in yellow color in DAC should be added.

check if any GI conditions are causing an issue.

 

Other wise we can add record by schedule action and update the commisionable checkbox for every 30mins.


Forum|alt.badge.img
  • Author
  • Freshman I
  • 31 replies
  • February 14, 2025
Manikanta Dhulipudi wrote:

@vishalsharma49 

First can you confirm if you are able to update the commissonable checkbox using import scenario with business events.

 

2nd. if above steps 1 is working then We need to investigate the business events using record by change, 

 

Make sure all the Keyfields which are in yellow color in DAC should be added.

check if any GI conditions are causing an issue.

 

Other wise we can add record by schedule action and update the commisionable checkbox for every 30mins.

Hi Manikanta, i am unable to update commisson check box through import scenario. I am uploading import scenario screenshot please check is it ok .

 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13
vishalsharma49 wrote:
Manikanta Dhulipudi wrote:

@vishalsharma49 

First can you confirm if you are able to update the commissonable checkbox using import scenario with business events.

 

2nd. if above steps 1 is working then We need to investigate the business events using record by change, 

 

Make sure all the Keyfields which are in yellow color in DAC should be added.

check if any GI conditions are causing an issue.

 

Other wise we can add record by schedule action and update the commisionable checkbox for every 30mins.

Hi Manikanta, i am unable to update commisson check box through import scenario. I am uploading import scenario screenshot please check is it ok .

 

Please try with the line nbr like below

https://community.acumatica.com/import%2Dand%2Dexport%2Dscenarios%2D117/updating%2Dunit%2Dprice%2Don%2Dopen%2Dsales%2Dorders%2Dmulti%2Ditems%2D20452


Forum|alt.badge.img
  • Author
  • Freshman I
  • 31 replies
  • February 14, 2025
Manikanta Dhulipudi wrote:
vishalsharma49 wrote:
Manikanta Dhulipudi wrote:

@vishalsharma49 

First can you confirm if you are able to update the commissonable checkbox using import scenario with business events.

 

2nd. if above steps 1 is working then We need to investigate the business events using record by change, 

 

Make sure all the Keyfields which are in yellow color in DAC should be added.

check if any GI conditions are causing an issue.

 

Other wise we can add record by schedule action and update the commisionable checkbox for every 30mins.

Hi Manikanta, i am unable to update commisson check box through import scenario. I am uploading import scenario screenshot please check is it ok .

 

Please try with the line nbr like below

https://community.acumatica.com/import%2Dand%2Dexport%2Dscenarios%2D117/updating%2Dunit%2Dprice%2Don%2Dopen%2Dsales%2Dorders%2Dmulti%2Ditems%2D20452

Hi Manikanta, the xml file attached is not working.


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