I suspect that your error message tells you all you need to know, doesn't it? Just in case it doesn't, what does this return?

SELECT SUM(AMOUNT) FROM XACCD GROUP BY PORDER

John