You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Are calculated attributes dynamic?

in Account Reconciliation 3 comments

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')

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!