Skip to main content
Answer

Business event- Trigger on INItemsaleshis_FinYtdQTYSales Does not work. How to make it work?

  • June 7, 2021
  • 3 replies
  • 138 views

Forum|alt.badge.img+6

Hello,

      I have a need to monitor 1 item’s sales qty. If the qty reaches a certain amount, I shall do something.(business subscriber).

       I choose the INItemsaleshis_FinYTDQTYSales to monitor, because it is a aggregation sum value.


      However,  I add 2 “or” trigger conditions on business events. And both of them did not work.

 

 

        What is the right way to happen the trigger work?
       Or can I have another methods to monitor the sales qty increasing?

Best answer by Irina

@ray20 probably this will require customization that will store this data in a database.

Another suggestion from “dirty hacks” category is to create a custom field which should be incremented each time the item was sold. 

3 replies

Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Platform Analyst
  • August 18, 2021

Hello @ray20 

More likely this field is not stored in database but calculated “on the fly”. If this is true, business event is not going to trigger. This is just out of the general logic.


Forum|alt.badge.img+6
  • Author
  • Captain II
  • August 19, 2021

@Irina Thank you for your confirmation. But ,do you know a way to monitor the item sales qty?

If I would like to monitor if item A reachs qty.sales to 200, I shall do something, like cancel the promotion price or something else.


Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Platform Analyst
  • Answer
  • August 25, 2021

@ray20 probably this will require customization that will store this data in a database.

Another suggestion from “dirty hacks” category is to create a custom field which should be incremented each time the item was sold.