Skip to main content
Solved

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


Forum|alt.badge.img+5
  • Captain II
  • 398 replies

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. 

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

3 replies

Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Support Analyst
  • 504 replies
  • 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+5
  • Author
  • Captain II
  • 398 replies
  • 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 Support Analyst
  • 504 replies
  • 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. 


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