Basic Assignments
|
Options & Settings
|
Main Time Information
|
||||||||||||||||||||||
|
|
|
|
|||
|
|||
|
Notes:
|
-Works but is intense – currently big query, no grouping. Outer loop about (150 records), inner loop (10-15 records). Problem = cf query timeouts -New idea – All-All -Grab 3 different queries for verified, pending, totals -Select SUM(line) as line-sum, chart of account id, store id -From, where, group by chart of account id & store id, order by -Deposit store amount date verified age – links -Expense vendor amount money check trans date verified age - links |