When loading Reconciliation transactions we need to filter the data loaded
Summary:
The load file contain transactions that should not be loaded to ARCS. In the file I have an attribute containing the Status with values: Approved, Canceled or Attested.
One reconciliation (Match Type) should have the Approved and Attested records loaded an other reconciliation (other Match Type) should have the Canceled records.
Where do I apply that kind of filter to ARCS?
I have tried to add it to the Source definition, but it seems not to work:
Filter Criteria
Type equals 'Tilsagn'
Or Type equals 'LT-tilsagn'
And Status equals 'Approved'
An other one is:
Filter Criteria
Type equals 'Refusjonskrav'
0