This problem occurs when the EXTDCST, OREXTCST column in the SOP10100 table for this transaction does not match the actual originating and functional total for the line items for this transaction.
Update this field to the value shown in the distribution window to resolve the issue.
SELECT SUM(EXTDCOST) AS LineExtdCost, SUM(OREXTCST) AS LineOrigCost
FROM SOP10200
WHERE (SOPNUMBE = 'RTN000530')
select EXTDCOST, orextcst from sop10100 where SOPNUMBE='RTN000530'
update sop10100 set EXTDCOST = 33522.45
--, orextcst = 5157.30
where SOPNUMBE='RTN000530'
No comments:
Post a Comment