Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Aged Debtor Analysis
08-18-2016, 12:16 PM,
#6
RE: Aged Debtor Analysis
(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 Smile.
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+debto​rtrans.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+debto​rtra​ns.ovgst-debtortrans.alloc)<0.009 Error Code: 1054. Unknown column 'debto​rtra​ns.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
Reply


Messages In This Thread
Aged Debtor Analysis - by daveparrish - 08-11-2016, 12:51 PM
RE: Aged Debtor Analysis - by agaluski - 08-12-2016, 11:03 PM
RE: Aged Debtor Analysis - by daveparrish - 08-13-2016, 01:52 AM
RE: Aged Debtor Analysis - by daveparrish - 08-13-2016, 12:00 PM
RE: Aged Debtor Analysis - by agaluski - 08-18-2016, 07:46 AM
RE: Aged Debtor Analysis - by daveparrish - 08-18-2016, 12:16 PM
RE: Aged Debtor Analysis - by agaluski - 08-19-2016, 12:16 AM
RE: Aged Debtor Analysis - by daveparrish - 08-23-2016, 12:33 AM
RE: Aged Debtor Analysis - by phil - 08-23-2016, 08:54 AM
RE: Aged Debtor Analysis - by daveparrish - 08-25-2016, 05:42 AM
RE: Aged Debtor Analysis - by agaluski - 08-26-2016, 01:08 AM
RE: Aged Debtor Analysis - by daveparrish - 08-26-2016, 02:06 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)