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

Create a new date data attribute under the match type.

in Account Reconciliation 1 comment

This attribute should be derived from the existing day attributes :Bank Transaction Date and CH fields.

The new data attribute, Grouped Date, should be calculated as follows:

  • When CH = ‘RETU’, use the Transaction Date
  • When CH = ‘DEPOS’, use the Transaction Date + 6 days.

I tried multiple ways and nothing seems to work. Any help would greatly be appreciated. Thank you

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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