Ohh I see. We have our own AR Aging Report (MS Access)
I hope it helps. It can be change to show > 10
Here is the script
SELECT
BKAR_INVT_CODE, BKAR_INVT_DATE, BKAR_INVT_NUM,
BKAR_INVT_AMT, BKAR_INVT_TYPE, BKAR_INVT_AMTRM, BKAR_INVT_MCCOD,
IF(BKAR_INVT_TYPE = 'I',IF ((CURDATE ( ) - BKAR_INVT_DATE) <= 30, BKAR_INVT_AMTRM, 0 ), 0) 'Days_Current',
IF(BKAR_INVT_TYPE = 'I',IF ((CURDATE ( ) - BKAR_INVT_DATE) > 30 AND (CURDATE ( ) - BKAR_INVT_DATE) <= 60, BKAR_INVT_AMTRM, 0 ),0 ) 'Days_30',
IF(BKAR_INVT_TYPE = 'I',IF ((CURDATE ( ) - BKAR_INVT_DATE) > 60 AND (CURDATE ( ) - BKAR_INVT_DATE) <= 90, BKAR_INVT_AMTRM, 0 ),0 ) 'Days_60',
IF(BKAR_INVT_TYPE = 'I',IF ((CURDATE ( ) - BKAR_INVT_DATE) > 90 AND (CURDATE ( ) - BKAR_INVT_DATE) <= 120, BKAR_INVT_AMTRM, 0 ),0 ) 'Days_90',
IF(BKAR_INVT_TYPE = 'I',IF ((CURDATE ( ) - BKAR_INVT_DATE) > 120, BKAR_INVT_AMTRM, 0 ), 0 ) 'Days_120',
(CURDATE ( ) - BKAR_INVT_DATE) AS DD,
BKARHINV.BKAR_INV_CUSNME as CUSNME, BKARHINV.BKAR_INV_CUSORD as CUSORD
FROM BKARINVT LEFT JOIN BKARHINV ON BKARINVT.BKAR_INVT_NUM = BKARHINV.BKAR_INV_NUM
WHERE BKAR_INVT_AMTRM <> 0;
Kelloggs