Tracking payment promises kept

[HaydenRussell]

We have a number of customers with overdue accounts

The credit team contact these customers to arrange payment.

We want to see if payment arrangements are kept, (i.e. payment is made within 28 days of arrangement).

Not sure to approach this scenario, is it best to:

- Create a new table to summarise arrangements and payments?

- Add a new column to the arrangements table, and summarise payments within 28 days of the arrangement?

- Build a measure?

Does anyone here have any advice?

Example data sets below (two tables)

1. tracks when arrangements are made

2. tracks payments by customers

Thanks in advance for any advice.

Hayden

[Vvelarde]

@HaydenRussell

Hi, how is related each payment with Payment Arrangements.

For example:

How identified that first payment (15/08/2016) is related to which Payment Arrangements (in your case 1/8/2016)