Review Contract Summary - issue with payments placed on account (OA)

Hi,

Review Contract Summary page is missing payments that are placed on account for a specific contract. Sometimes, payments are placed on account and linked with contract num but for different reasons they are not applied yet against the invoice(s). However, payments are collected but we observe that they are not counted in the Total Collected. Looking at the code we see the following:

SELECT %DecMult(SUM(ENTRY_AMT_BASE), -1), CURRENCY_CD, %DateOut(ACCOUNTING_DT) FROM PS_ITEM_ACTIVITY WHERE CONTRACT_NUM = :1 AND ENTRY_USE_ID IN ('WS-01','WS-08','WS-09','DM-01','DM-06','DM-07','MT-01','MT-03') GROUP BY CURRENCY_CD , ACCOUNTING_DT