Run the following query to determine how widespread the issue is:
Please complete and run the following SQL
NOTE: Export the results to an .XLS file with column header names.
Be sure to fill out the date range of the transactions.
w.externaltransno, w.external_id, W.APPLYTO, W.TRANSNO,
W.SOURCEMODULE, W.EXTERNALBATCHID, W.TRANSTYPE,
W.TRANSDATE, W.ENTRYDATE, W.STATUS, W.QUANTITY, WV.BILLRATE,
WV.totalcost t_actualcost, WV.AMOUNT t_revenue, WV.PRICE, WV.AMOUNTREMAINING,
W.GLPOSTED, W.PROJECT_CODE, W.RESOURCE_CODE, W.TASK_ID, W.ROLE_CODE,
W.CHARGE_CODE, WV.CURRENCY_CODE, W.USER_LOV1
WHERE W.TRANSNO = WV.TRANSNO
and WV.CURRENCY_TYPE = 'HOME'
and W.TRANSDATE between TO_DATE('XX-MON-YYYY', 'DD-MON-YYYY') and TO_DATE('XX-MON-YYYY', 'DD-MON-YYYY')
order by w.transno
Please ZIP the file and contact the Support team to upload the files.
If there are confirmed duplicates, there is an 18-step procedure to have it corrected and the steps will be provided by the Support team for Oracle and MSSQL databases.