Something seems to be causing inconsistancy...
SELECT (Sum(PAYMENTS.AMT)/100) FROM INVOICES LEFT JOIN PAYMENTS ON
PAYMENTS.INVNUM = INVOICES.INVNUM WHERE INVOICES.INVNUM = 133674 GROUP BY
INVOICES.INVNUM;
This returns one row with 134.56
SELECT (((((10000+INVOICES.TAXPERC+IF(INVOICES.HNDTYPE=0, INVOICES.HNDVAL,
0))*INVOICES.SUBTOTAL/10000)+IF(INVOICES.HNDTYPE<>0, INVOICES.HNDVAL,
0)))/100) FROM INVOICES LEFT JOIN PAYMENTS ON PAYMENTS.INVNUM =
INVOICES.INVNUM WHERE INVOICES.INVNUM = 133674 GROUP BY INVOICES.INVNUM;
This returns one row with 134.56
SELECT (((((10000+INVOICES.TAXPERC+IF(INVOICES.HNDTYPE=0, INVOICES.HNDVAL,
0))*INVOICES.SUBTOTAL/10000)+IF(INVOICES.HNDTYPE<>0, INVOICES.HNDVAL,
0)))/100) - (Sum(PAYMENTS.AMT)/100) FROM INVOICES LEFT JOIN PAYMENTS ON
PAYMENTS.INVNUM = INVOICES.INVNUM WHERE INVOICES.INVNUM = 133674 GROUP BY
INVOICES.INVNUM;
This *should* return 0, I believe, but instead it returns -134.56 ??
Am I forgetting something?
Regards, Dave (paradox@stripped)
