(08-18-2016, 07:46 AM)agaluski Wrote: Dave,
The logic only runs if certain input conditions are met. Unfortunately I can't troubleshoot easily not being on your system .
Do you get any results if you run this query on the DB directly?
SELECT * from debtortrans WHERE ABS(debtortrans.ovamount+debtortrans.ovdiscount+debtortrans.ovfreight+debtortrans.ovgst-debtortrans.alloc)<0.009
Strange ran in DB directly and error
0 1 20:52:50 SELECT * from debtortrans WHERE ABS(debtortrans.ovamount+debtortrans.ovdiscount+debtortrans.ovfreight+debtortrans.ovgst-debtortrans.alloc)<0.009 Error Code: 1054. Unknown column 'debtortrans.ovgst' in 'where clause' 0.000 sec
Pasted in notepad and here is what it looks like
0 1 20:52:50 SELECT * from debtortrans WHERE ABS(debtortrans.ovamount+debtortrans.ovdiscount+debtortrans.ovfreight+debto?rtra?ns.ovgst-debtortrans.alloc)<0.009 Error Code: 1054. Unknown column 'debto?rtra?ns.ovgst' in 'where clause' 0.000 sec
re typed debtortrans.ovgst and returned
3 2 20:55:27 SELECT * from debtortrans WHERE ABS(debtortrans.ovamount+debtortrans.ovdiscount+debtortrans.ovfreight+debtortrans.ovgst-debtortrans.alloc)<0.009 12101 row(s) returned 0.000 sec / 0.141 sec