Not able to make the Receivables Ageing report with Unapplied Cash to taken account
Hi,
The below mentioned query i am using calculate the AR Ageing, but in this query i am unable to take the Unapplied Receipts, please if anybody can find a solution please update.
SELECT CUSTOMER_NUMBER,NAME,CUST_ID,COLLECTOR_ID,COL_NAME,Company,Location,Department,Account,Future_1,gl_cc_concat_kff,Code_Comb_ID,
SUM (inv_curr_amount_original),sum(Inv_Cur_Days_1_to_3),sum(Inv_Cur_Days_4_to_7),sum(Inv_Cur_Days_8_to_15),
sum(Inv_Cur_Days_16_to_21),sum(Inv_Cur_Days_22_to_30),sum(Inv_Cur_Days_30_to_60),sum(Above_60_OverDue)
FROM ( SELECT rc.customer_number,
rc.CUSTOMER_NAME Name,
The below mentioned query i am using calculate the AR Ageing, but in this query i am unable to take the Unapplied Receipts, please if anybody can find a solution please update.
SELECT CUSTOMER_NUMBER,NAME,CUST_ID,COLLECTOR_ID,COL_NAME,Company,Location,Department,Account,Future_1,gl_cc_concat_kff,Code_Comb_ID,
SUM (inv_curr_amount_original),sum(Inv_Cur_Days_1_to_3),sum(Inv_Cur_Days_4_to_7),sum(Inv_Cur_Days_8_to_15),
sum(Inv_Cur_Days_16_to_21),sum(Inv_Cur_Days_22_to_30),sum(Inv_Cur_Days_30_to_60),sum(Above_60_OverDue)
FROM ( SELECT rc.customer_number,
rc.CUSTOMER_NAME Name,
0