Collected amount (Payments) in Contract Workbench & Contract Summary
edited Jun 22, 2020 4:58PM in Enterprise Service Automation (ESA) - PSFT (MOSC) 6 commentsAnswered ✓
Hi,
Can you please provide a reasoning on the following logic disparity between Contract Workbench & Contract Summary page related to the code that pulls/ populate the value in Collected amount?
I see that the code behind the page for retrieving collected amount from receivables in Contract Workbench is 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') AND
(ENTRY_TYPE IN ('PY','OA') OR (ENTRY_TYPE = 'MT' AND DOCUMENT IN (' ',
0