Answer Happy

Posted: **Mon May 02, 2022 12:10 pm**

: Use The Ap Database Use Both The General Ledger Accounts Table And The Invoice Line Items Table Figure What Fields I Use 1 (17.36 KiB) Viewed 27 times

output that i need:

: Use The Ap Database Use Both The General Ledger Accounts Table And The Invoice Line Items Table Figure What Fields I Use 2 (76.33 KiB) Viewed 27 times

Use the AP database Use both the general_ledger_accounts table and the invoice_line_items table Figure what fields I used from these tables Do a running total of the cost Do a percent of the running total to 2 decimals with the % sign right after the percent number The FROM is the invoice_line_items table do a JOIN to the other DO NOT include the ones where the GL description is 'Freight" or "Telephone' Order by cost descending There should be 51 records Column heading names MUST match mine, see printout below
589 Tests AZ 190 Limit to 1000 rows Result Grid Filter Rows: Export: Wrap Cel Content: A GL Description Expense Cost Running Total PctofunningTotal 400 Book Printing Costs CICS Desk Reference 37966.19 37966.19 100.00% 400 Book Printing Costs MUS JA 26881.40 64847.59 41.45% 400 Book Printing Costs DB2 book printing 23517.58 88365.17 26.61% 400 Book Printing Costs Book repro 21842.00 110207.17 19.82% 400 Book Printing Costs CICS book printing 20551.18 130758.35 15.72% 400 Book Printing Costs VSAM book printing 10976.06 141734.41 7.74% 589 Outside Services Web site design 7125.34 148859.75 4.79% 400 Book Printing Costs Os Utilities 6940.25 155800.00 4.45% Outside Services Office lease 4901.26 160701.26 3.05% 572 Books, Dues, and Subscriptions Card deck 2433.00 163134.26 1.49% 540 Direct Mail Advertising PC card deck 2184.50 165318.76 1.32% 520 Building Lease Warehouse lease 1750.00 167068.76 1.05% 507 UCI Income Tax 1600.00 168668.76 0.95% 572 Books, Dues, and Subscriptions Catalog ad 1575.00 170243.76 0.93% 589 Outside Services 401K Contributions 1367.50 171611.26 0.80% 403 Book Production Costs Cover design 1197.00 172808.26 0.69% 160 Computer Equipment MSON 1083.58 173891.84 0.62% 403 Book Production Costs Crash Course covers 1000.46 174892.30 0.57% 403 Book Production Costs Crash Course revision 953.10 175845.40 0.54% 160 Computer Equipment Quarterly Maintenance 936.93 176782.33 0.53% 403 Book Production Costs Cover design 904.14 177686.47 0.51% 574 Business Licenses and Taxes Property Taxes 856.92 178543.39 0.48% 540 Direct Mail Advertising Catalog design 765.13 179308.52 0.43% 403 Book Production Costs Card deck 639.77 179948.29 0.36% 403 Book Production Costs Cover design 601.95 180550.24 0.33% Result 1 x