Equation / Criteria to extract Incremental Date Range in IDEA using Direct Extraction

Hello Group Members,

 

Let’s say your Application System by default has a facility to download a Year to Date (YTD) General Ledger each month. In this General Ledger you would like to use IDEA to specifically test Accrual Provisions and Reversals each month for potential duplicate provisioning and non-reversals.

 

Your first step would be to prepare the right review time period data in IDEA for the Duplicate check (Duplicate Key Detection) and Non Reversals (Direct Extraction). Your mandate is to analyse, review and report on potential duplicates and non-reversals for the last month (30 - days) gone by on an incremental range basis each month.

 

So as a first step to prepare the right review time period data for the incremental month range you can apply a Direct Extraction with the Criteria ~

 

@between(@dtodays(GLTRANDATE), @dtodays(@date())-30, @dtodays(@date()))

 

The above criteria will simply return the GL Transaction Date which falls between today’s System Date and the last 30 days gone by - hence - the incremental month range.

 

Now the above criteria works on the criteria of dynamic incremental month Extraction and that is the reason we use @Date() for System Date. In case you need this as on a static fixed date your criteria will look like ~

 

@between(@dtodays(GLTRANDATE), @dtodays(“20181128”)-30, @dtodays(“20181128”))

 

Best Regards

 

Group Admin Team