Are calculated attributes dynamic?
Summary:
We are using a Data Source attribute (calculation - scripted) in our transaction matching. We have also enabled "Allow Edit". The business requirement is as follows :
Transaction matching is used for matching orders and payments. Business needs an indicator (on unmatched transactions) if the said transaction should be followed up or not.
If an order date is less than 2 months old, then there is no reason to investigate. Since the it may take up to 2 months for the order to arrive and the payment is made. The formula is
IF_THEN_ELSE(DATE_DIFF({Accounting Date},'TODAY','DAYS')<60 , 'Investigate')