Thursday, January 23, 2014

Dynamics GP - This Cost of goods sold distribution amount is incorrect and will not be posted

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