AP Aging Detail Report - Works for the the 10.0 Web Client!
Many of you have seen the new SAP Business One web client. However, it is still under development and missing both an AR Aging and AP Aging Detail reports. This report will work in both the Fiori Client as well as the Web Client.
Simply copy and past this query into your Query Manager and save the Query. Next, in the Web Client, add the Query as a new tile. And Wala! AP Aging in the Web Client!
SELECT
T0."DocNum" "AP",
T0."DocDueDate" "Due_Date",
T0."CardCode" "BP_Code",
T0."CardName" "Supplier",
T0."PaidToDate" "Paid_To_Date",
CASE
WHEN T0."DocDueDate" < CURRENT_DATE THEN T0."DocTotal"
ELSE '0'
END "Past_Due",
CASE
WHEN T0."DocDueDate" >=CURRENT_DATE AND T0."DocDueDate" <=ADD_DAYS(CURRENT_DATE,30) THEN T0."DocTotal"
ELSE '0'
END "0_30_Days",
CASE
WHEN T0."DocDueDate" > ADD_DAYS(CURRENT_DATE,30) AND T0."DocDueDate" <=ADD_DAYS(CURRENT_DATE,60) THEN T0."DocTotal"
ELSE '0'
END "31_60_Days",
CASE
WHEN T0."DocDueDate" > ADD_DAYS(CURRENT_DATE,60) AND T0."DocDueDate" <=ADD_DAYS(CURRENT_DATE,90) THEN T0."DocTotal"
ELSE '0'
END "61_90_Days",
CASE
WHEN T0."DocDueDate" > ADD_DAYS(CURRENT_DATE,90) THEN T0."DocTotal"
ELSE '0'
END "Future_Remet",
T0."Comments" "Comments"
FROM OPCH T0
WHERE T0."DocStatus" = 'O'