4 Replies Latest reply: Aug 16, 2018 3:52 AM by Bala Bhaskar RSS

    All unallocated cash receipt till yesterday

    Ugur Arslan

      Dear all,

       

      In order to see all unallocated cash (to a customer account) I use the following expression:

       

      Sum({<

      [code of cash applied]={'unallocated'},

      [date of cash applied]={"<=$(=today())"}

      >}[cash applied total USD])

       

      Now I want to see what case was unapplied till yesterday. This in order to see the difference between today and yesterday.

       

      What expression do I need to use for the date of cash applied?

       

      Ugur