Home

Ch-09 Reports

Contents

1. Adjst __ FinCha General Sort Stations 0146 15t Hispanic Brdcstrs Awe 93 00 0 00 93 00 0 00 0 00 0112 Abx Cablevision Of Texas Inc 278 30 220 00 0002 American National Bank 593 75 625 25 0133 American National Bank spanis 80 00 80 00 0155 Anytown American Legion 31 50 0 00 0102 Anytown Filley Co 200 00 200 00 0004 Apache Chemical 136 69 0 00 Report Type 0005 Apache Tractor amp Implement 60 00 60 00 AR Reconciliation Summary 0006 Arnolds Jewelers 24 00 30 00 0007 Asap Paging 233 75 61 00 Report Format 0008 Baptist Bible Hour 80 00 80 00 Standard x 0011 Bette s Sewing Center 150 00 150 00 0012 Bommer Ford 417 00 275 00 0013 Bommer Tractor 167 50 174 25 Last Month 0015 Bordens Inc 120 00 120 00 0016 Brooks amp Lee Funeral Home 15 00 15 00 From October 01 2003 0017 Caraway Ford Mercury 293 25 292 50 0142 Charlie Bartoz Dozer Contractr 24 00 0 00 0019 City Utilities 406 25 426 75 tofOctober 31 2003 m 0020 Clothes Tree 100 00 10000 0152 Cooper Chev Olds Pontiac 105 00 0 00 0023 Cow Palace 115 50 0 00 0143 Daisy Mae s 42 00 0 00 0157 Davis And Logan Insurance 60 00 60 00 0026 Dewitt Poth amp Son 155 00 0 00 0153 Diversified Liquidators 144 00 207 00 0027 Donnie s Western Wear And 54 00 54 00 0029 Dragon Place 54 00 60 00 Natural Log User M anual Page 9 27 9 16 Report Type Transactions Report Description This report screen genera
2. add Invoices Detail Bepor View Tools Help EIE ude 51 Memorize Export Print Help Close le x Report Settings Filters Revenue AccRep Report Format Standard Report Type Invoices Detail hdd Report Period Custom Dates x From Sep 2003 x GES gt 2004 03090001 DEMO FM 0146 001 1St amp nr 0146 1St Ann Hispanic Brdcstrs 03090002 DEMO amp M 0112 001 Tci Cat 03090003 DEMO FM 0112 002 Tci Cat 0112 Abx Cablevision Of Texas 03090004 DEMO amp M 0001 003 Allen s 03100001 DEMO amp M 0001 005 Talent 0001 Allen s Body Tech 03090005 DEMO amp M 0002 001 amp meric 03090006 DEMO AM 0002 003 amp meric 03090007 DEMO amp M 0002 004 Americ 0002 American National Bank 03090008 DEMO AM 0133 001 Americ 0133 American National Bank spi Invoiced Sales Report Sample for the period 9 1 03 through 9 30 04 Groe Neil J Tax Discounts iw Invoices Summary Report View Tools Help vce coe fin fe 90 Report Settings 7 Filters Report Format Standard hdd Report Type Invoices Summary Report Period Last Month From Sep Pal gt 2003 x GE 2003 z Copies to Print fi x Sponsor 0146 1St Ann Hispanic Brdestrs Awd 0112 Abs Cablevision OF Texas Inc 0001 Allen s Body Tech 0002 American National Bank 0133 American National Bank spanish 0155 An
3. TaxDue Invoices m Report Period This Month gu sllo 2003 sl 2003 D Item s to Report 6 125 Sales Tax 361 25 425 00 General Tab Report Format Standard is default but you may also use this dropdown box to select another customized report format you have previously saved See saving customized report formats and restore default_report format in section 9 07 Continued on next page Page 9 34 Natural Log User M anual 9 17 Report Type Tax Due Report cono General Tab Report Type The Tax Reports screen has 2 types of reports Due Invoices Prints a report of tax due assuming taxes must be forwarded to the tax collector based on issued invoices q Tax Due Payments Prints a report of tax due assuming taxes must be forwarded to the tax collector based on payments received General Tab Tax Item s to Report The Transactions Report can be filtered to report on individual Tax Items in case you collect taxes for different agencies or at differing rates Natural Log User M anual Page 9 35 9 18 Report Type Sales Projections Report Description This report screen generates reports showing expected future billing to be issued within the report period based on orders entered in NL8 as of the date the report is generated Note This report does not show the amount of items on individual log dates it only shows the amount to b
4. 0102 Anytown Filley Co 0006 Arnolds Jewelers 0008 Baptist Bible Hour z z 0012 Bommer Ford ND National Direct 0013 Bommer Tractor N National Agency 0019 City Utilities NR National Rep 0157 Davis And Logan Insurance LD Local Direct 0026 Dewitt Poth amp Son L4 Local Agency 0027 Donnie s Wester Wear And OD Other Direct 0031 Dubose Insurance 0122 Farmer s Insurance 0158 Ferrell Gas Co 0040 First Baptist Church G 0043 First United Methodist Church et Report de Pee nk Stations Put a check next to the Station s to be included Revenue Puta check next to the Revenue Type s to be included AcctRep Put a check next to the Account Rep s to be included Custmr Put a check next to the Customer s to be included 2 You can use any combination of the checks on multiple tabs to create a complex array of filtering options for any given report For very complex filters for which these check boxes are insufficient you need to use advanced report filtering Natural Log User M anual Page 9 5 9 03 Advanced Report Filtering This section of Natural Log allows you to filter reports in very complex ways beyond the Basic Filtering describe in the previous section of this manual Most users will not need this advanced filtering Design Screen To set the Report advanced filtering also see basic report filtering and any filtering on a Browse screen you first need to display the Design screen by se
5. Report View Tools Help a uw Print 4 Help Close por Sp lL ye Customer Billing History Report Sample Net for the period 1 1 02 through 12 31 03 Report intended as sales management aid only is rounded to whole numbers and does NOT include effect of AR Adjstmts Sponsor Det Year 2002 Year 2003 0001 Allen s Body Tech Report Format Standard Report Type Billing History Monthly m Report Period Custom Dates From Jan ot 2002 Report Revenue Ne zl Year 2002 Year 2003 0002 American National Bank Year 2002 Year 2003 0133 American National Bank spi Year 2002 Year 2003 0155 Anytown American Legion Year 2002 Year 2003 0102 Anytown Filley Co Get Report General Tab Report Format Standard is default but you may also use this dropdown box to select another customized report format you have previously saved See saving customized report formats and restore default_report format in section 9 07 Continued on next page Page 9 14 Natural Log User M anual 9 09 Report Type Customer Billing Payment History cont General Tab Report Type The Customer History report screen has 6 types of reports Billing History Monthly Billing History Quarterly Billing History Annually Payment History Monthly Payment History Quarterly Payment History Annually 20 0 0 General Tab Report Period The Customer Histo
6. definition in glossary that was posted by the log generator for each customer during the report period 24 Sample Log Times Report iaf x View Tools Help com Memorize Export Print Help Close Report Settings Filters Log Times Report Sample Log Times for the Period 9 1 03 to 10 15 03 Sponso LegDate Length Time Lenath Time Length Time Lenath Time 0146 001 15t Ann Hispanic Brdestt Sat 9 6 03 00 60 08 17 PM 00 60 09 17 PM 00 60 11 17 PM 0146 001 15t Ann Hispanic Brdestr Sat 9 13 03 00 60 09 06 00 60 10 06 PM 00 60 11 06 PM 0146 001 15t Ann Hispanic Brdestr Sat 9 20 03 00 60 06 06 00 60 08 15 PM 00 60 10 06 PM 0146 001 15t Ann Hispanic Brdestr Sat 9 27 03 00 60 06 06 00 60 07 06 PM 00 60 11 06 PM 0146 1St Ann Hispanic Brdcs Report Format Standard Report Type Log Times Report Period Custom Dates x From Sep zjjn gt 2003 tof Oct 15 gt 2003 Get Report 0112 002 Cablevision Of Texas 0112 002 Abx Cablevision Of Texas 0112 002 Cablevision Of Texas 0112 002 Cablevision Of Texas 0112 002 Cablevision Of Texas 0112 002 Abs Cablevision Of Texas 0112 002 Abx Cablevision Of Texas 0112 002 Cablevision Of Texas 0112 002 Cablevision Of Texas 0112 002 Cablevision Of Texas 0112 002 Cablevision Of Texas 0112 002 amp bx Cablevision Of Texas 0112
7. 002 Abs Cablevision Of Texas 0112 002 Abx Cablevision Of Texas 0112 002 Abx Cablevision Of Texas 0112 Abx Cablevision Of 0001 003 Allen s Body Tech Allen AOA ONT Alt nd Teele A Alan Fri 9 12 03 00 30 08 45 4M 00 30 02 17 PM 00 30 03 16 PM Mon 3 15 03 00 30 12 13 PM 00 30 01 36 PM Tue 9 16 03 00 30 06 13 AM 00 30 08 45 AM 00 30 12 13 PM Wed 3 17 03 00 30 01 36 PM 00 30 02 17 PM 00 30 05 20 PM Thu 3 18 03 00 30 02 17 PM 00 30 03 16 PM Fri 9 19 03 00 30 08 45 00 30 11 17 00 30 05 10 PM Mon 9 22 03 00 30 09 17 00 30 02 17 PM Tue 3 23 03 00 30 08 45 AM 00 30 03 17 AM 00 30 02 17 PM Wed 9 24 03 00 30 08 22 AM 00 30 09 17 AM 00 30 05 20 PM Thu 3 25 03 00 30 06 13 AM 00 30 10 17 AM Fri 9 26 03 00 30 08 45 AM 00 30 12 13 PM 00 30 05 10 PM Mon 9 29 03 00 30 11 17 00 30 12 13 PM Tue 9 30 03 00 30 08 45 AM 00 30 09 17 AM 00 30 03 16 PM Wed 10 1 03 00 30 08 45 AM 00 30 12 13 PM 00 30 03 16 PM Thu 10 2 03 00 30 03 17 00 30 03 16 PM 00 30 05 20 PM Mon 9 8 03 00 30 08 22 AM On n2 nn n 100 52 Natural Log User M anual 9 15 Report Type Accounts Receivable Report Description This generates an Accounts Receivable Aging report an Accounts Receivable Reconciliation report and an UnApplied PrePayments report To get to these reports from the main NL menu select Reports Accounts Receivable q Onthe
8. 04 24 Sample Agency Account List Report Report View Tools Help id Memorize Export Print Help Close Report Settings 7 Filters Agency Account List Sample Sponsor Address Telephone n 0001 Allen s Body Tech Allen Line 2 Anywhere T 78000 210 555 5555 m 02 Allen s Ad Agency 0006 Amolds Jewelers Accounts Payable Anywhere TX 78000 210 555 5555 0126 Nutri system Accounts Payable Anywhere TX 78000 210 555 5555 Report Format 06 Bright Star Agency Standard x Report Type Agency Account List x 0130 Victory Bank And Trust Accounts Payable Anywhere T 78000 210 555 5555 09 Brown And Terry Adver 0112 Abx Cablevision Of Texas Accounts Payable Anywhere TX 78000 210 555 5555 0132 John Greer Chevrolet Accounts Payable Anywhere TX 78000 210 555 5555 10 C CX amp Y 0005 Apache Tractor amp Impleme Accounts Payable Anywhere TX 78000 210 555 5555 0124 xyz Food Store Accounts Payable Anywhere TX 78000 210 555 5555 04 Dave And Dave Advert mac em mm th Ze Fenaban A wm wen cre TUR EE A ses man THA mim ccc cccc S 4 General Tab Report Format Standard is default but you may also use this dropdown box to select another customized report format you have previously saved See saving customized report formats and restore default report format in section 9 07 General Tab Report Type The Agency report screen has 2 types of reports q Agency List Pr
9. 6 10A 10A 3P or 3 7P but would count the spot in the 6A 7P column in which it must run This method gives better results if you want to know the amount of non movable spots already sold within a specific daypart in cases in which a new order may be placed for a number of spots in a particular daypart This method is also useful when running a report for sponsorship avails using specific avail types Inventory Report Columns You can change the report daypart columns with the Inventory Report screen displayed using the Report Customize Report Format Columns menu choice on the report screen You can set specific start and end times or select time classes Inventory Report Column Settings 12 00 00 Mi 5 00 00 AM 16 00 00 gt 2 00 00 PM 7 00 00 PM Drive Times 12 00 00 to to to to to to 5 59 59 AM gt 55258 2 59 59 PM 6 59 59 PM 11 59 59 PM 11 59 59 PM Cancel Page 9 40 Natural Log U ser M anual
10. DEMO AM 0001 005 Talent 0001 Allen s Body Tech 03090005 DEMO AM 0002 001 Americ 03090006 DEMO AM 0002 003 Americ 03090007 DEMO AM 0002 004 Americ 0002 American National Bank 03090008 DEMO AM 0133 001 Americ 0133 American National Bank spi General Tab Report Format Standard is default but you may also use this dropdown box to select another customized report format you have previously saved See saving customized report formats and restore default report format in section 9 07 Page 9 28 Natural Log U ser M anual 9 16 Report Type Transactions cont General Tab Report Type The Transactions Report screen has 9 types of reports Invoices Summary Prints a summary 1 row for each customer of the invoices issued during the report period Report columns include Gross Discounts Agency Commission Net Tax AccountRep Commission and National Rep Commission WInvoices Detail Prints a detail 1 row per invoice of the invoices issued during the report period Report columns include Gross Discounts Agency Commission Net Tax AccountRep Commission and National Rep Commission q Payments Summary Prints a summary 1 row for each customer of the payments received during the report period Report columns include Payment Amount Tax Amount Net Amount Agency Commission AccountRep Commission and National Rep Commission Payments Detail Prints a detail 1 row per paymen
11. Erickson Standard zl Lasserre Bradley Report Type Customer Mail Labels Report Period All David Porter Bruce Epstein Bruce Epstein D W Brooks Labels Avery 5160 Mailing L Kim Caraway Tammy Lester Get Report Customer Mail Labels Allen s Ad Agency Another Debut Anytown American Legion Anytown Chamber Of Commerce Anytown Filley Co Anytown VM EW Apache Chemical Asap Paging Baptist Bible Hour Berans s Agri center Bert s Restaurant Bette s Sewing Center Bommer Ford Bommer Tractor Boone s Bakery Bordens Inc Bozo Advertising Bright Star Agency Bright Star Agency Brooks amp Lee Funeral Home Brown And Terry Advertising COREY C CX amp Y Caraway Ford Mercury Casa Porras Charlie Bartoz Dozer Contractr City Utilities Clothes Tree Sample BillingName Address1 Address2 a Allen Line 2 1421 E Court Street P O Box 2 P O Box 86 0 Box 932 Oil Patch Lane 103 South Texana C o Lasserre Bradley P O 435 Accounts Payable 106 North Austin Accounts Payable P O Box 1102 Rt 3 Box 400 C o Mike Cooper 123 N Jay Leno Suite 120 Accounts Payable Accounts Payable 127 Hwy 90 Accounts Payable Accounts Payable Accounts Payable P D Box 1950 110 St Joseph Street Rt 1 163 4 P D Box 547 612 St Joseph P O 711 P O 17037 P 0 Box 149 0 Box 14 123 Anywhere RD 4118 North 41St Pla 4118 Nort
12. General tab described below you can select the main settings for the report On the Sort tab you can control how the report is sorted and grouped See section 9 01 q Use the Stations AcctRep Revenue and Custmrs tabs to perform basic report filtering as described in section 9 02 Also see section 9 03 if you need advanced filtering to handle complex filtering q You may customize the report format to select which columns are displayed see section 9 05 the page layout see section 9 06 to select font paper margins and paper orientation and the report title and subtitle see section 9 04 P AR Aging Summary Report View Tools Help vel con Print IE Help Close E Accounts Receivable Aging Report Sample as of November 30 2003 General Sot Stations Ere e e De 20 Se 0112 Abx Cablevision Of Texas Inc 220 00 0 00 0 00 002 American National Bank 133 American National Bank spanis 102 Anytown Filley Co 005 Apache Tractor amp Implement 006 Arnolds Jewelers 007 Asap Paging 008 Baptist Bible Hour 011 Bette s Sewing Center 012 Bommer Ford 013 Bommer Tractor 015 Bordens Inc 016 Brooks amp Lee Funeral Home 017 Caraway Ford Mercury 142 Charlie Bartoz Dozer Contractr 019 City Utilities 020 Clothes Tree 023 Cow Palace 143 Daisy Mae s 157 Davis And Logan Insurance 025 Delta Armature 026 Dewitt Poth amp Son 153 Diversified Liquidators 027 Donnie s Western Wear An
13. Ordered Rate Report Sample 10 1 03 through 10 31 03 ordered pre tax GROSS rates General Sot Stations Report intended as a sales management aid only and may NOT comply with government political advertising rate rules 1200a 0600a 0600 1000 1000a 0300p 0300 0700 0700p 1159p 0600a 0700p 1200 4 MTWTFSS MTWTFSS MTWTFSS MTWTFSS MTWTFSS MTWTFSS M 0112 002 Pkg amp bx Cablevision 2 65 0002 001 American National Bank 0002 003 American National Bank 0002 004 Pkg American National 0133 001 American National Bank 0102 001 Pkg Anytown Filley Co 0005 001 Pkg Apache Tractor amp 0006 001 Arnolds Jewelers Spot 0007 003 Pkg Asap Paging Spc 0008 001 Baptist Bible Hour Spo 0011 001 Pkg Bette s Sewing Ce 0012 001 Bommer Ford Spot 0012 002 Pkg Bommer Ford Sp 0013 001 Bommer Tractor Spot 0013 002 Bommer Tractor Spot 0013 003 Bommer Tractor Spot 0015 001 Bordens Inc Spot 0016 001 Pkg Brooks amp Lee Fune 001 Caraway Ford Mercury 002 Caraway Ford Mercury 003 Caraway Ford Mercury 001 City Utilities Spot 0019 002 Pkg City Utilities Spot 0157 001 Pkg Davis And Logan 0153 001 Diversified Liquidators 0027 001 Donnie s Western Wear nnoao nn nre Dinan Ceu General Tab Report Format Standard is default but you may also use this dropdown box to select another customized report format you have previously saved See Saving customized report format
14. Rate Prints a report showing the average rate for all items logged in each selected daypart for each log q Inventory Total Cost Prints a report showing the total valuew logged of all items logged in each selected daypart for each log General Tab Report Basis q Units of commercial units or avails on Log Template q Units oftotal avails on Log Template q Minutes Minutes of commercial spots or avails on Log template Minutes of total available minutes on Log Template General Tab Include Avail Types You can restrict the report to include only specific avail types such as sponsorships General Tab Include Preemption Levels You can restrict the report to include only Order Lines with a preemption level superior to a specified level This is sometimes helpful to see the loading without the lower priority items like station promos trades etc to which you can assign an inferior preemption level and exclude from this report Continued on next page Natural Log User M anual Page 9 39 9 19 Report Type Inventory cont General Tab Distribute Non Fixed Spots Because NL8 is a dynamic scheduler the exact log positions of spots with wide time windows are not set until the final log is generated New orders may cause some of these spots to be moved to another time within their time window This can cause a problem for Inventory Reports Inventory Report Example Assume you have a spot to ordered to run 6AM 7PM As
15. Summary m Report Period Custom Dates D From Sep slle sllon tof Oct 15 gt 2003 Get Report General Tab Report Format Standard is default but you may also use this dropdown box to select another customized report format you have previously saved See saving customized report formats and restore default report format in section 9 07 Continued on next page Page 9 24 Natural Log User M anual 9 14 Report Type Log Reports cont General Tab Report Type The Log Reports screen has 3 types of reports q Log Summary Prints a summary 1 row for each customer of the items that ran on the logs during the report period The report includes columns for total items run total time scheduled and total cost Log Detail Prints a detail list of each item that ran for each customer of what ran on the logs during the report period This includes indiviudla times rates copyID etc Log Times Prints a detail list of the date and time only for each item that ran for each customer of what ran on the logs during the report period NonLog Charge Summary Prints a summary 1 row for each customer of the Non Log Charges see definition in glossary that have been posted by the log generator during the report period The report includes columns for total NLC items and total cost NonLog Charge Detail Prints a detail list of the date and amount of each Non Log Charge see
16. 3 382 4381 Report Period Custom Dates 0 6 03 Mon 5 185 30 161 17 188 33 147 7 150 80 436 94 7 879 10 7 03 Tue 13 187 356 155 17 189 30 150 1 1892 82 494 98 901 From October 01 2003 SW oe wea 13 187 37 153 19 186 29 151 7 176 85 490 109 989 base 7 10 9 03 Thu 15 185 30 160 227183 36 144 1 182 88 487 106 892 fey October 51 10 10 03 Fri 13 187 327158 21 185 36 144 1 139 89 488 105 851 DE M 10 11 03 Sat 3 209 212111 13 213 15 167 9 258 438 491 61 999 10 12 03 Sun 0 125 4 149 42138 11 134 1 126 192421 20 E97 Include Avail Types E Include Preemption Levels Week Total 62 1273 189 1047 113 1283 190 1037 27 7 1214 492 3367 594 6108 ef 1071303 Mon 19019 om 20 185 297151 7 150 82 494 104 869 10 14 03 Tue 13 187 327158 16 190 24 156 1 182 72 504 90 908 TE z 10 5 03Wed 14 186 30 160 16 189 26 154 7 176 72 503 98 900 EE M 10 16 03 Thu 13 187 25 154 20 185 27 153 12182 73 500 912907 10 17 03 Fri 14 186 31 159 19 188 27 153 1 182 77 500 94 906 10 18 03 Sat 3 207 19 113 10 2016 12 170 10 258 41 493 54 1006 10 19 03 Sun 0 125 2 151 4 138 11 134 0 127 17 423 17 70 Week Total 72 1263 173 1063 105 1291 156 1071 27 1257 434 3425 548 6197 Z Get Report The report can show units or minutes or sold unsold sold versus unsold sold versus total total average rate and total cost as described on the next pages General Tab Report Format Standard is default
17. Chapter 9 Reports amp Lists Natural Log has several standard Reports that are accessible from the Natural Log main screen under Reports All of these reports may be printed to paper sent to an Adobe Acrobat PDF file see section 11 05 if this manual or exported a text file for importing into any other program such as a spreadsheet Customizing Reports The following settings for each report may be customized by the user Title SubTitle See section 9 04 q Column Setting See section 9 05 q Filter Settings See sections 9 02 and 9 03 Sort Settings See section 9 02 Settings See section 9 06 Memorized Reports You can save the customized report settings described above for future use by clicking Memorize You can later recall them under the Reports Memorized Reports menu choice See manual section 9 07 Report Printing Export Reports initially appear on screen but may be printed to any Windows compatible printer using the Print button Any report may be exported using the Report Export Report Data menu choice on any report screen NL8 can export to a normal text file or to delimited files that can be easily imported into other programs such as Excel NL8 also includes a PDF output module see section 11 05 of this manual so any report can be printed to an Adobe Acrobat PDF file for easy transfer via e mail View Underlying Report Data On reports except inventory reports you can double cli
18. Format 0155 Anytown American Legion Standard Report Type Finance Chas Detail 04010004 02 DEMO AM Finance Charge 12 30 03 1 728 04 Avg Balance 200 on 0102 Anytown Filley Co Report Period Custom Dates x From Jan jl 01 e 2004 x 04010004 03 DEMO AM Finance Charge 12 30 03 1 28 04 Avg Balance 136 69 0004 Apache Chemical tof Feb s 2004 04010004 04 DEMO FM Finance Charge 12 30 03 1 28 04 Avg Balance 60 on Ir 0005 Apache Tractor amp Implement 04010004 05 DEMO AM Finance Charge 12 30 03 1 228 04 Avg Balance 24 on li 0006 Arnolds Jewelers a Payments Detail Report View Tools Help ee Memorize Export Print Help Close r Report Settings 7 Filters Finance Charge Report Sample for the period 1 1 04 through 2 29 04 0002 American National Bank 0155 Anytown American Legion 0102 Anytown Filley Co 0004 Apache Chemical 0005 Apache Tractor amp Implement 0006 Arnolds Jewelers Report Format 0007 Asap Paging Standard 0008 Baptist Bible Hour 0011 Bette s Sewing Center Report Type 0012 Bommer Ford Finance Chas Summary 0013 Bommer Tractor E 0015 Bordens Inc Report Period 0016 Brooks amp Lee Funeral Home Custom Dates Pe 0017 Caraway Ford Mercury Frem Jan v lI 0 e 2004 x tof Feb e i 29 e 2004 Get Report Natural Log User M anual Page 9 33 9 17 Report Type Tax Due Report Report Description This report screen generates report
19. Missing 30 00 Missing 30 Missing 15 00 0113 e gt 50 0114 e 30 Missing 60 0019 e General Tab Report Period The Orders List report screen has 4 types of report periods All Include all orders in the NL system q Running Include only orders that run during the specified period q Starting Include only orders starting their run within the specified period q Expiring Include only orders ending their run within the specified period Page 9 18 Natural Log U ser M anual 9 12 Report Type Order Rates WARNING Government regulations regarding lowest rate requirements for political advertising are very complex This report may be configured by the end user to suit the end users specific situation For this reason the developer and publisher of NL8 make no representation that this report complies with those political advertising rules This report should be configured and used only in accordance with the legal advice of a communications attorney familiar with the nuances of the political advertising rules Report Description This report screen generates a report of rates on orders To get to this report from the main NL menu select Reports Order Reports Order Rates Note On these reports rates are pre tax gross pre commission 24 Sample Order Rates Lowest Rate Report m x View Tools Help wel Memorize Export Print Help Close Finit Spi Order Rates Lowest
20. Products 150 00 00 House Accounts DEMO FM 150 00 00 House Accounts 150 00 r then Sort by Station E v Group Subtotals Group PageBreak 0001 Allen s Body Tech 0102 Anytown Filley Co 0006 Arnolds Jewelers 0008 Baptist Bible Hour 0012 Bommer Ford 0013 Bommer Tractor 0019 City Utilities 0157 Davis And Logan Insurance 0026 Dewitt Poth amp Son 0027 Donnie s Western Wear And 0031 Dubose Insurance 0122 Farmer s Insurance 0158 Ferrell Gas Co 0040 First Baptist Church 0043 First United Methodist Church then Sort by Sponsor eal v Group Subtotals E Group Pagebreak Get Report Sort Group By Use the first Sort dropdown box to select the data column to be used as the primary sort column for the list Any items with matching entries in the primary sort data column are then sorted by the column selected in the second Sort dropdown box Any items with matching entries in the primary and secondary sort data columns are then sorted by the column selected in the third sort dropdown box Ascending or Descending The buttons to right of the Sort boxes allow you to sort in Ascending or Descending order Continued on next page Natural Log User M anual Page 9 3 9 01 Sorting and Grouping Reports cont Sample Sales Projection Summary Report e x Report View Tools Help cal amp B Memorize Export Print Help Close Report Settings Filt
21. Reports Inventory On the General tab described below you can select the main settings for the report Use the Stations AcctRep Revenue and Custmrs tabs to perform basic report filtering as described in section 9 02 Also see section 9 03 if you need advanced filtering to handle complex filtering q You may customize the report format to select which columns are displayed as described on the 2nd following page in this section of the manual the page layout see section 9 06 to select font paper margins and paper orientation and the report title and subtitle see section 9 04 24 Sample Inventory Report m x Report View Tools Help i ex v Memorize Export Print Help Close Report Settings Filters Inventory Report Sample Units Sold VS Unsold for the Period 10 1 03 to 10 31 03 Future logs Non Fixed Position items randomly distributed within allowed times 0100a 0559a 0600 0959 10003 0259p 0300p 0653p Q700p 1153p 0600a 0659p 1200a 1159p 10 1 03 Wed 4 196 33 157 18 187 29 151 77176 80 495 957903 Report Type 10 2 03 Thu 4 196 230 160 26 179 34 146 1 182 90 485 100 898 10 3 03 Fri 8 1922 37 153 22 185 33 147 1 182 922495 101 899 Inventor old VS Unsold H 10 4 03 Sat 3 207 23 109 14 212 16 166 10 258 53 487 994 Report Format 10 5 03 Sun 0 125 2 151 5 137 12 133 1 126 18 421 20 597 Standard Week Total 19 7916 1257730 85 900 124 743 20 924 3347 237
22. al Tab Labels Only applies if Customer Mailing Labels report is selected This allows you to select the label type you want to print Supported label types are q Avery 5160 mailing labels 8 5 x 11 sheets 10 rows x 3 columns q Avery 5161 mailing labels 8 5 x 11 sheets 10 rows x 2 columns q Avery 5162 mailing labels 8 5x11 sheets 7 rows x 2 columns Most office supplies carry these or a type of label compatible with these Natural Log User M anual Page 9 13 9 09 Report Type Customer Billing Payment History Report Description This report prints customer payment or billing history by month quarter or annually It can go back as far as you save data in NL8 usually data is saved for 5 years To get to these reports from the main NL menu select Reports Customer Reports On the General tab described below you can select the main settings for the report On the Sort tab you can control how the report is sorted and grouped See section 9 01 Use the Stations AcctRep Revenue and Custmrs tabs to perform basic report filtering as described in section 9 02 Also see section 9 03 if you need advanced filtering to handle complex filtering q You may customize the report format to select which columns are displayed see section 9 05 the page layout see section 9 06 to select font paper margins and paper orientation and the report title and subtitle see section 9 04 4 S ample Billing History Monthly Report
23. ayout see section 9 06 to select font paper margins and paper orientation and the report title and subtitle see section 9 04 24 Sample Log Summary Report m x Report View Tools Help com SB AT Memorize Export Print Help Close Report Settings Filters Log Summary Report Sample Log Summary for the Period 9 1 03 to 10 15 03 Cost is Gross before any Discounts amp gency Commission or Tax 0146 1St Ann Hispanic Brdestrs Awd 00 12 00 0112 Cablevision Of Texas Inc 00 20 00 0001 Allen s Body Tech 00 02 30 0002 American National Bank 00 56 00 0133 American National Bank spanish 00 07 30 0155 Anytown American Legion 00 07 00 0102 Anytown Filley Co 00 15 00 0004 Apache Chemical 00 00 60 0005 Apache Tractor amp Implement 00 05 15 0006 Amolds Jewelers 00 02 30 0007 Asap Paging 00 34 30 0008 Baptist Bible Hour 02 00 00 0011 Bette s Sewing Center 00 14 30 0012 Bommer Ford 00 21 00 0013 Bommer Tractor 00 16 30 0015 Bordens Inc 02 00 00 0016 Brooks amp Lee Funeral Home 01 00 00 0017 Caraway Ford Mercury 00 30 00 0142 Charlie Bartoz Dozer Contractr 00 04 00 0019 City Utilities 00 28 30 0152 Cooper Chev Olds Pontiac 00 10 00 0023 Cow Palace 00 11 00 0143 Daisy Mae s 00 03 30 0157 Davis And Logan Insurance 00 06 00 0026 Dewitt Poth amp Son 00 20 00 0153 Diversified Liquidators 00 09 30 0027 Donnie s Western Wear And 00 05 00 nn nc on Report Format Standard Report Type Log
24. but you may also use this dropdown box to select another customized report format you have previously saved See saving customized report formats and restore default report format in section 9 07 Page 9 38 Natural Log U ser M anual 9 19 Report Type Inventory cont General Tab Report Type The Sales Projection Report screen has these types of reports Inventory Sold Prints a report showing how sold out each selected daypart is for each log Report columns show or of units or minutes sold depending on your selection for Report Basis q Inventory UnSold Prints a report showing how much is unsold in each selected daypart is for each log Report columns show or of units or minutes sold depending on your selection for Report Basis Inventory Total Prints a report showing total avails on your Log Template in each selected daypart for each log Report columns show of units or minutes depending on your selection for Report Basis q Inventory Sold vs UnSold Prints a report showing both sold and unsold avails in each selected daypart for each log Report columns show or of units or minutes sold and unsold depending on your selection for Report Basis q Inventory Sold vs Total Prints a report showing both sold and total Log Template avails in each selected daypart for each log Report columns show or of units or minutes sold and unsold depending on your selection for Report Basis q Inventory Avg
25. ck on any data line on the report to view the underlying data that created that line on the report If the report is a summary type report a window will open with the details of the summary report line Then you can double click the detail data line you want to display Note The user must have appropriate permission to view the underlying data or it won t display Example1 On an Order Rates Lowest Rate report double click on a data line to view that broadcast order Example2 On an Accounts Receivable Aging Summary report if you click on any data line of the report a window will open to display all transactions included in the line on the summary report In that detail window you can double click on any transaction to view that transaction Report Types The following Reports are available in Natural Log Click a report for a short description and information specific to that report The reports are accessed under the Reports menu from the main NL screen Customers Billing History Reports q Customer List See section 9 08 q Customer Mail Labels See section 9 08 q Customer Envelopes See section 9 08 Billing History Monthly Quarterly Annual section 9 09 q Payment History Monthly Quarterly Annual See section 9 09 Agency List See section 9 10 q Agency Account List See section 9 10 Continued on next page Natural Log User M anual Page 9 1 Chapter 9 Reports amp Lists cont Order Lists Reports Order Lis
26. ction Report may show amounts accrued when Invoiced or when Logged q When Invoiced default value will include per spot revenue in the correct column based on the date the invoice is going to be issued q When Logged will include per spot revenue in the correct column based on the date the item s are going to be logged For level package and variable package invoices all revenue is accrued on the Invoice Date regardless of this accrual setting General Tab Include Sales Goal 96 On Sales Projection reports if you check this box an extra line will be computed for each Account Rep and Station subtotal showing the 96 of sales goals for the report period These sales goals are established in Setting up Account Reps General Tab Include 0 Orders On Sales Projection reports if you check this box detail report lines for orders that run but are to be billed at no cost during the projections period will be printed on the report Natural Log User M anual Page 9 37 9 19 Report Type Inventory Report Description This report screen generates reports showing how much of you broadcast avail inventory is sold and or unsold based the Log Templates and Orders entered in NL8 as of the date the report is generated See General Tab Distribute Non Fixed Spots for important information regarding these reports and Inventory Report Columns to configure your daypart columns To get to these reports from the main NL menu select
27. d 029 Dragon Place 031 Dubose Insurance 154 E L Sanchez 133 F dwards Furniture Report Type Aging Summary m Report Format Standard Report Period Today he As of November 30 2003 Aging Columns Month Finance Charges Aged Include Prepaid Credit Vv 2ooogoooocoooooooooooooooosos 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a gt General Tab Report Format Standard is default but you may also use this dropdown box to select another customized report format you have saved See saving customized report formats and restore default report format in section 9 07 General Tab Aging Columns Finance Charges The AR Aging report may be displayed with columns defined as month such as Sep Oct etc or by days due such as 31 60 days 61 90 days etc You can also tell NL8 whether you want it to age the finance charges into the appropriate columns or show finance charges in a separate column Page 9 26 Natural Log User M anual 9 15 Report Accounts Receivable cont General Tab Report Type The Log Reports screen has 3 types of reports q AR Aging Summary Prints a summary 1 row for each customer of the Accounts Receivable balance as of the date specified on the report screen General tab Columns can be broken out by 30 60 90 days aging or by month q AR Aging Detail Prints each Acc
28. e report to include an item in a daypart column if it s schedule time falls within that daypart column If checked this causes the report to include an item in a daypart column only if it s schedule time exactly matches the daypart column Example Assume you have a spot scheduled at 8 10 AM q With Exact DayPart Matching unchecked this spot would be included in the 6 00AM 9 59AM column because its schedule time does falls completely within the daypart column settings q With Exact DayPart Matching checked this spot would not be included in the 6 00AM 9 59AM column because its schedule time does not exactly match the daypart column settings Warning Exact Daypart Matching has no effect when you use time classes in the report columns or on an order line Those items are only included in a column when the named time class on the order line exactly matches the named time class in the report column Page 9 20 Natural Log U ser M anual 9 12 Report Type Order Rates cont Order Rates Report Daypart Columns You can change the report daypart columns with the Order Rates Lowest Rate and Order Rates Average Rate report screens using the Report Customize Report Format DayPart Columns menu choice on the report screen You can set specific start and end times and days to be included in each column or select time classes 243 Order Rates Report Daypart Columns 12 00 00 4M v 6 00 00 AM 10 00 00 AM 20000 PM 7 00 00 PM 7 D
29. e 4 0001 003 Allen s Body Tech Spot Allen s Body Tech TFN 01 Eddy Mun C Ca 0001 Allen s Body Tech 0002 001 American National Bank Spot American National 02 Corey Wh C Ca 0002 003 American National Bank Spot American National 02 Corey Wh C Ca 0002 004 American National Bank Spot American National 02 Corey Wh C Ca 0002 American Hational Bank Report Format Standard Y Report Type Order List Summary 0133 001 American National Bank spanis American National 12 31 03 03 Delfino Gs C Ca 0133 American Hational Bank spanis Report Period Running From Oct yi is gt 2003 x to Oct 15 sl 0102 001 Anytown Filley Co Spot Anytown Filley Co 12 31 03 01 Eddy Mun C Ca 0102 Anytown Filley Co 0005 001 Apache Tractor amp Implement Apache Tractor amp 06 Albert Doc C Ca 0005 Apache Tractor amp Implement Get Report General Tab Report Format Standard is default but you may also use this dropdown box to select another customized report format you have previously saved See saving customized report formats and restore default report format in section 9 07 Continued on next page Natural Log User M anual Page 9 17 9 11 Report Type Order Lists Missing Copy Report Sponsorship Report cont General Tab Report Type The Order List report screen has 3 types of reports Order List Summary Prints a summary of each order such a
30. e 9 8 Natural Log U ser M anual 9 05 Report Column Selection Design Screen To set the columns to be included in a Browser screen or a Report you first need to display the Design screen selecting Report Customize Report Format on any report screen the Browser Settings button on any Browser screen or the Log Editor Settings on the Log Editor screen Only certain columns can be removed from a report Numeric columns that are an integral part of the report may not be removed After making changes click the View Print button to refresh the report You do not need to save the report settings changes unless you want to save them for future use with this report format See Saving customized report formats Also see Restore default report format i Standard Sales Projection Summary Report Design oy x x View Print Help Cancel Columns To Add or Remove a Column from the List Highlight the Column then click Add or Remove DR Drag Drop Columns from box to box Available Columns Include Columns AccountRepCust Sponsor Add gt BillCycleCust BillingN ame CityState lt Remove Contact CreditLimit CustEntryD ateT ime Selecting Columns You will see 2 boxes on the column selection screen Available Columns and the other is Included Columns q You may drag and drop the columns back and forth between these boxes to either include or exclude a column from the repor
31. e billed when it is scheduled to be billed not when it is logged Example If you run the report for the specified period July 1 through July 30 and you use Calendar Month billing on your orders you will see no projected billing since Calendar Month billing is not issued until July 31 Billing amounts are included only if the date the invoice is scheduled to be issued based on the order Billing Cycle is included in the report period To report the amounts of items on an individual log date or range of dates use the Log Reports To get to the Sales projection reports from the main NL menu select Reports Sales Projections On the General tab described below you can select the main settings for the report Sort tab you can control how the report is sorted and grouped See section 9 01 q Use the Stations AcctRep Revenue and Custmrs tabs to perform basic report filtering as described in section 9 02 Also see section 9 03 if you need advanced filtering to handle complex filtering q You may customize the report format to select which columns are displayed see section 9 05 the page layout see section 9 06 to select font paper margins and paper orientation and the report title and subtitle see section 9 04 4 Sample Sales Projection Summary Report View Tools Help Q4 2 Print Es Export Fe EMail Help Close Report Settings Filters Sales Projection Report AccRep Sample for the pe
32. e you enter the value for the filtering AND or OR Only if you want to add another filter restriction click the AND or OR selection on the next line and repeat the above entries for the second filter line Continue for as many filter lines as you need Natural Log User M anual Page 9 7 9 04 Report Title and SubTitle Setup Design Screen To set the Title and SubTitle to be printed you first need to display the Design screen by selecting Report Customize Report Format on any report screen After making changes click the Get Report button to refresh the report You do not need to save the report settings changes unless you want to save them for future use with this report format See Saving customized report formats Also see Restore default report format iw Standard Sales Projection Summary Report Design C x wh View Print Help Cancel Report Type 5 ales Projection Summary Report Name Standard Report Title ales Projection Report Report Sub Title for the period Report Name For customized Reports this is the unique name by which you may recall a customized report design Report Title This is the main title heading to be printed at the top of the printed page in large print Report SubTitle This is a sub heading to be printed as the second line of the page header in medium print See Saving customized report formats See Restore default report format Pag
33. ed TradeChl__BadDebl 03100003 TCR Trade Credit Applied 0001 Allen s Body Tech 03100006 APRE Apply PrePayment DA Report Format 0133 American National Bank spi Standard Report Type Adiustments Detail x 03100005 BAD Bad Debt writeOff _ 0102 Anytown Filley Co Report Period This Month From Oct a gt 2003 x tof Oct E gt 2003 24 Adjustments Summary Report View Tools Help een Memorize Export Print Help Close Report Settings 7 Filters Adjustments Report AccRep Sample forthe period 10 1 03 through 10 31 03 pono Debi redi TradeCH BadDebi AgcCom 0001 Allen s Body Tech 0133 American National Bank spanish 0102 Anytown Filley Co 0 00 180 70 Report Format Standard Report Type Adiustments 5 ummary Ge Report Period This Month From Oct xj 2003 x tof Oct ej 2003 Page 9 32 Natural Log U ser M anual 9 16 Report Type Transactions cont 24 Payments Detail e d xc Report View Tools Help 8 Gel Als Memorize Export Print Help Close Finance Charge Report AccRep Sample forthe period 1 1 04 through 2 29 04 Report Settings Filters 04010004 00 DEMO 4M DEMO FM Finance Charge 12 30 03 1 28 04 Avg Bal 0002 American National Bank 04010004 01 DEMO AM Finance Charge 12 30 03 1 28 04 Avg Balance 31 5 or Report
34. ee Fune 9 1 03 12 31 03 Brooks amp Lee Fune 9 1 03 12 31 03 0017 002 Caraway Ford Mercury Caraway Ford Mer 9 2 03 12 31 03 _ 0026 001 Dewitt Poth amp Son Dewitt Poth amp Son 9 10 03 11 23 03 MTWTFSS E L Sanchez 941 103 1 2 31 103 5 Report Format Standard hd Report Type Order List Missing Copy Report Period Running From Oct zj 5 2003 x to Oct yfis sl 0006 001 Arnolds Jewelers 0007 002 Asap Paging 0007 003 Asap Paging 0012 001 Bommer Ford 0013 001 Bommer Tractor 0015 001 Bordens Inc Missing Copy Order Report Sample Customers Running 10 15 03 to 10 15 03 Only Orders with Copy problems are included in this list RunDates RunDays 08 45 08 47 AM 05 20 PM 05 22 PM 07 00 PM 08 00 PM 06 00 06 00 PM 07 00 08 00 08 20 08 40 12 35 12 40 06 00 07 00 12 00 11 59 08 45 08 50 05 20 05 25 07 00 08 00 06 00 06 00 07 00 PM 08 00 PM 12 43 PM 12 45 PM 06 00 07 00 PM 12 28 PM 12 30 PM 06 00 07 00 05 00 05 30 06 00 07 00 10 00 10 15 06 00 07 00 06 50 07 00 12 00 12 00 05 00 07 00 30 Missing 30 Missing 30 Missing 15 0011 e 115 0011 es 60 0011 e 60 0049 e 30 0049 e 30 0049 e 30 0049 e 30 0049 e 30 0048 e 30 Missing 30 Missing 30 Missing 50
35. ers Sales Projection Report Sample for the period Oct 2003 through Mar 2004 General Sort Stations This report is based on Net BOOKED ORDERS and may vary from actual invoices if some items not aired as ordered Sponsor et 2003 2003 2003 Jan 2004 Feb 2004 2004 4 0144 Emergency Brdcst System Test 0 00 0 00 0 00 0 00 0 00 00 House Accounts DEMO Ak 0 00 Sort Group by Account ep Aj v Group Subtotals 0110 Steelman Office Products 150 00 Group PageBreak 00 House Accounts DEMO FM 150 00 00 House Accounts H 150 00 m then Sort by Station E v Group Subtotals 0001 Allen s Body Tech Group PageBreak 0102 Anytown Filley Co 0006 Arnolds Jewelers 0008 Baptist Bible Hour 0012 Bommer Ford then Sort by 0013 Bommer Tractor Sponsor 0019 City Utilities Sponsor z 0157 Davis nd Logan Insurance M Group Subtotals 0026 Dewitt Poth amp Son E Group Pagebreak 0027 Donnie s Wester Wear And 0031 Dubose Insurance 0122 Farmer s Insurance 0158 Ferrell Gas Co 0040 First Baptist Church Group Subtotals If checked the report will include subtotals for every group of items with the same sort value Example If you check Group Subtotals every time the Account Rep changes in the report a subtotal line will be printed Group PageBreak If checked the report will send a fomrfeed to the printer after the subtotal line for every group
36. h 415t Pla 234 Post Rd Suite 3 525 N Loop Suite amp 525 N Loop Suite amp General Tab Report Format Standard is default but you may also use this dropdown box to select another customized report format you have previously saved See saving customized report formats and restore default report format in section 9 07 Page 9 12 Natural Log U ser M anual 9 08 Report Type Customer List Mailing Labels Envelopes Mail Merge cont General Tab Report Type The Customer List report screen has 3 types of reports Customer List Summary q Customer Mail Labels q Customer Mail Merge creates tab delimited Mail Merge data file for MS Word documents q Customer Envelopes General Tab Report Period The Customer List Mailing Labels Envelopes report screen has 3 types of report periods All Include all customers whether they have or have not had activity Active Since Include only customers that have been active since the date you specify in the date boxes displayed when you select this report period Not Active Since Include only customers that have not have been active since the date you specify in the date boxes displayed when you select this report period Note For purposes of this report active date is defined as the LATER of 1 The last date a transaction was posted to the account or 2 The end date of the latest running broadcast order on the account Gener
37. i 04020024 Payment Check 3427 on Inv 04020027 2 C Cash Spots 0112 Abx Cablevision Of Texas 04010001 2 DEMO AM C Cash Spots 0133 American National Bank spi 04020004 2 C Cash Spots 0003 Another Debut 04020028 Payment Check 1 on Inv 0155 Anytown American Legion 04020025 Payment Check 3412 on Inv 04020025 Payment Check 3412 on Inv 0012 Bommer Ford 1 116 30 1 116 30 24 Payments Detail Report View Tools Help 8 enor A ce Memorize Export Print Help Close Report Settings Filters Report Format Standard Report Type Payments Summary Ge Report Period Custom Dates From Jan en gt 2004 tof Feb gt 23 gt 2004 Get Report Payments Report Sample for the period 1 1 04 through 2 29 04 Ser 0112 Cablevision OF Texas Inc 58 30 0133 amp merican National Bank spanish 800 00 0003 Another Debut 0 00 0155 Anytown American Legion 1 00 0012 Bommer Ford 257 00 1 116 30 0 00 0 00 0 00 0 00 0 00 0 00 58 30 800 00 0 00 1 00 257 00 1 116 30 Natural Log User M anual Page 9 31 9 16 Report Type Transactions cont 24 Adjustments Summary e d xc Report View Tools Help com RR ax Memorize Export Print Help Close Report Settings Filters Adjustments Report AccRep Sample for the period 10 1 03 through 10 31 03 Sot Stations ee Debi Cr
38. il J BillingNan ame CityState Contact CreditLimit CustEntryD ateT ime CustlD Clear Filter Comparison Use the comparison dropdown box to select the field to be filtered B Most of the comparison operators are common arithmetic operators like for equal gt for greater than and lt for less than lt gt means not equal to IN means that the filtered field must be INCLUDED in the list you print in the Filter Value box for the item to be included in the list Example You set up a filter of AccountRep IN 1 2 5 This would list all items for AccountReps 1 2 and 5 only Be sure to include commas between the values in the Filter Value box if you use the IN comparison NOT IN means items would be included only if their filter field is NOT IN the Filter Value box See Above LIKE means the filtered field must be like the Filter Value Example If you select Sponsor LIKE Wal you will get a list including all items for Sponsors starting with Wal followed by any other characters e g WallyMart Walls R Us Walts Place etc Be sure to put the at the end of the Filter Value BETWEEN means the data field must be like the between 2 values in the Filter value box Be sure to put AND between the values in the Filter Value Box Example If you select Sponsor BETWEEN A AND C you will get a list including all items with Sponsor names starting with the letters A B or C Filter Text This text box is wher
39. ings On any Report screen if you make changes to the report settings such as sorting and grouping columns title or filtering If you want to restore the default report format for that report click Report Restore Default Format Natural Log User M anual Page 9 11 9 08 Report Type Customer List Mailing Labels Envelopes Mail Merge Report Description This report prints a list of customers From this same report screen you may also print Customer Mailing Labels and Customer Envelopes as well as export a Mail Merge file for MS Word documents To get to these reports from the main NL menu select Reports Customer Reports On the General tab described below you can select the main settings for the report On the Sort tab you can control how the report is sorted and grouped See section 9 01 q Use the AcctRep Revenue and Custmrs tabs to perform basic report filtering as described in section 9 02 Also see section 9 03 if you need advanced filtering to handle complex filtering q You may customize the report format to select which columns are displayed see section 9 05 the page layout see section 9 06 to select font paper margins and paper orientation and the report title and subtitle see section 9 04 24 Sample Customer Mail Labels Report Report View Tools Help i v Memorize Export Print Help Close Report Settings Filters accep Can Report Format Bob
40. ints a list of agencies q Agency Account List Prints a list of the customer accounts belonging to each agency Page 9 16 N atural Log U ser M anual 9 11 Report Type Order Lists Missing Copy Report Sponsorship Report Report Description This report screen generates a summary list of orders You may also print Order Confirmations for a group of selected orders You can also get an order list including only those orders with Missing Copy To get to these reports from the main NL menu select Reports Order Reports Missing Copy Report General tab described below you can select the main settings for the report On the Sort tab you can control how the report is sorted and grouped See section 9 01 q Use the Stations AcctRep Revenue and Custmrs tabs to perform basic report filtering as described in section 9 02 Also see section 9 03 if you need advanced filtering to handle complex filtering q You may customize the report format to select which columns are displayed see section 9 05 the page layout see section 9 06 to select font paper margins and paper orientation and the report title and subtitle see section 9 04 24 Sample Order List Summary Report Report View Tools Help B SE Print Ir Help Close Report Settings 7 Filters Order List Sample Customers Running 10 15 03 to 10 15 03 Sort Stations Produet Stmions SteDete EndDete Accountep Rev
41. lecting Report Customize Report Format Advance Filtering on any report screen After making changes click the View Print button to refresh the report You do not need to save the report settings changes unless you want to save them for future use with this report format See Saving customized report formats Also see Restore default report format Filter Field iw Standard Sales Projection Summary Report Design SE Fiter Sot PageSeUp Create and edit SongList Filters Select Up to 4 Filter Columns for each select a Filter Type and then set The Filter Value Only songs which meet ALL filter requirements will be included Filter Field Comparison Filter Value ZipCode m Y 78003 AND BilCycleCust j fe BillCycleCust BillingN ame CityState Contact CreditLimit CustEntryD ateT ime CustlD E Clear Filter Use this dropdown box to select the data field to be filtered Page 9 6 Continued on next page Natural Log U ser M anual 9 03 Advanced Report Filtering cont i Standard Sales Projection Summary Report Design SE Ra E eal Create and edit SongList Filters Select Up to 4 Filter Columns for each select a Filter Type and then set The Filter Value Only songs which meet ALL filter requirements will be included Filter Field Comparison Filter Value ZipCode m m 78003 JE z
42. mmission percent q Order Rates Lowest Rate For each order running within the report period creates a list of the lowest ordered rate broken out by daypart You can change the report daypart columns used with the Orders Rates Lowest Rate and Order Rates Average Rates reports using the Report Customize Report Format Daypart Columns menu choice on the report screen You can set specific start and end times and days to be included in each column or select time classes q Order Rates Average Rate For each order running within the report period creates a list of the average ordered rate broken out by daypart You can change the report daypart columns with the Inventory Report screen displayed using the Report Customize Report Format Daypart Columns menu choice on the report screen You can set specific start and end times and days to be included in each column or select time classes General Tab Report Period The Orders Rate report screen allows you to select the specific period to be reported as a date range or a specific period such as Next Month Next Quarter etc General Tab Spot Pqm Length You can restrict the spot length or program length to be considered in the report General Tab Avail Types You can restrict the report to include only specific avail types such as sponsorships General Tab Exact DayPart Matching This does not apply to the Order rates Summary report The default value is unchecked which causes th
43. n 9 16 See section 9 16 See section 9 16 See section 9 16 See section 9 16 See section 9 16 See section 9 16 See section 9 16 See section 9 17 See section 9 17 See section 9 18 See section 9 18 See section 9 18 See section 9 19 See section 9 19 See section 9 19 See section 9 19 See section 9 19 See section 9 19 See section 9 19 Natural Log U ser M anual 9 01 Sorting and Grouping Reports From the NL main menu open any report under Reports and you can click on the Sort tab to change the sorting and grouping options for that report After making changes click the Get Report button to refresh the report You do not need to save the report settings changes unless you want to save them for future use with this report format See Saving customized report formats Also see Restore default report format i Sample Sales Projection Summary Report Efx Repot View Tools Help AT Memorize Export Print Help Close Report Settings 7 Filters Sales Projection Report Sample for the period Oct 2003 through Mar 2004 This report is based on Net BOOKED ORDERS and may vary from actual invoices if some items not aired as ordered Sponsor ct 2003 Nov 2003 Dec 2003 Jan 2004 Feb 2004 Mar 2004 4 0144 Emergency Brdcst System Test 0 00 0 00 0 00 0 00 0 00 0 00 00 House Accounts DEMO Ak 0 00 Sort Group by Account ep m Aj v Group Subtotals Group PageBreak 0110 Steelman Office
44. of items with the same sort value Example If you check Group PageBreak every time the Account Rep changes in the report a subtotal line will be printed and a new page will be started Page 9 4 Natural Log User M anual 9 02 Basic Report Filtering From the NL main menu open any report under Reports and you can click on the following tabs to do basic report filtering On any tab you can quickly select and un select many items at once using the None and All buttons After making changes click the Get Report button to refresh the report You do not need to save the report settings changes unless you want to save them for future use with this report format See Saving customized report formats Also see Restore default report format Sample Sales Projection Summary Report Report View Tools Help SB be x Memorize Export Print Help Close Report Settings 7 Filters Sales Projection Report Sample for the period Oct 2003 through Mar 2004 z This report is based on Net BOOKED ORDERS and may vary from actual invoices if zone tems not aired as ordered 7 EENEG Nov 2003 2003 Feb 2004 weier 0144 Emergency Brd n Tes 0 0 0 00 0 00 a 0 00 Revenue 00 House Accounts 7 DEMO Ak 0 00 wi C Cash Spots F Finance Charges T Trade 0110 Steelman Office Products 0 00 150 00 00 House Accounts Z DEMO FM 0 00 150 00 00 House Accounts 0 00 150 00 0001 Allen s Body Tech
45. ou may select any font that has been installed for your printer You may select any available font size for the printout WARNING Font sizes above 12 are not recommended because larger font sizes allow very little information to be printed in columns Margins You may select the desired margins in inches for top bottom left and right Copies When NL displays the printer selection screen when you print this report this is the number that will appear in the Number of Copies box on the print selection screen Page 9 10 Natural Log U ser M anual 9 07 Saving Customized Report Settings Saving Report Format Settings On any Report screen if you make changes to the report settings such as sorting and grouping columns title or filtering you can save the changes to the report format for future use by clicking Report Memorize Report Format You can then instantly recall that modified report format from the Report Name dropdown box when that report type screen is displayed or from the Reports Memorized Reports selection from the main menu iw Sample Memorized Reports oj E Show Report Type s All Memorized Reports lRepottType EE DEMO AM AR Aging Summary DEMO FM AR Aging Summary DEMO AM Projection Summary Report DEMO FM Projection Summary Report AR Aging Summary AR Aging Summary Sales Projection Summary Sales Projection Summary Open x Delete Restoring Default Report Format Sett
46. ounts Receivable transaction open unpaid as of the date specified on the report screen General tab Columns can be broken out by 30 60 90 days aging or by month q AR Reconciliation Summary Prints a summary 1 row for each customer showing the Accounts Receivable activity for the specified period Columns show beginning balance invoices issued payments received adjustments posted finance charges posted and ending period balance AR Reconciliation Detail Prints a detail entry 1 row for each transaction for each customer showing the Accounts Receivable activity for the specified period Columns show beginning balance invoices issued payments received adjustments posted finance charges posted and ending period balance UnApplied PrePayments Report Prints a detail entry 1 row for each transaction for each PrePayment that still has a credit or debit balance as of the specified report date A credit balance means the PrePayment amount has not yet been completely applied to pay invoices A debit balance means the PrePayment was over applied against more invoices than it can zero out Columns can be broken out by 30 60 90 days aging or by month 24 Sample AR Reconciliation Report Report View Tools Help toa SB AT ce Memorize Export Print Help Close pie Mu Accounts Receivable Reconciliation Report Sample for the period October 01 2003 through October 31 2003 Sponsor 11071703 Invoices
47. port View Tools Help i ex v Memorize Export Print Help Close Report Settings 7 Filters accep Genera Sot Contract Fulfillment Report Sample Bulk Contracts Running 10 15 03 to 10 15 03 Report is based on Orders Placed through 3 3 04 Contract Description RunDates Broadcasts Amount 0002 American National Bank 00002 American National Bank Bulk Cc 1 1 03 12 31 03 1000 Order 0002 001 American National B Spot 9 1 03 TFN 104 Order 0002 003 American National B Spot 91 03 12 31 03 104 Order 0002 004 American National B Spot 9 6 03 5 30 04 176 Balance Remaining 00002 American National Bank Bulk Cc 616 Report Format 0002 American National Bank Standard Report Type Contract Fulfillment hd Report Period Running From Oct JIE gt 2003 to Oct 15 2003 Basis Orders Placed sl Get Report Continued on next page Page 9 22 Natural Log U ser M anual 9 13 Report Bulk Contract Fulfillment cont General Tab Report Format Standard is default but you may also use this dropdown box to select another customized report format you have previously saved See saving customized report formats and restore default report format in section 9 07 General Tab Report Period The Bulk Contract Fulfillment report screen has 4 types of report periods All Include all bulk contrac
48. riod Nov 2003 through Apr 2004 eport based Net BOOKED ORDERS when Invoiced and may vary trom actual invoices if some items not aired as ordered Sponsor Noy 2003 Dec 2003 _Jan 2004 2004 Mar 2004 20041 4 0001 Allen s Body Tech 0 00 0 00 0 00 0 00 0 00 0 00 0144 Emergency Brdest System Te 0162 PSA s 0162 PSA s 0110 Steelman Office Products 00 House Accounts Sales Goal of Sales Goal Report Type Sales Projection Summary Report Format Standard Report Period Next 6 Months From Nov 2003 apr 2004 Revenue Net Accrue when Invoiced Include Sales Goal Include 0 Orders Bet Report 001 Allen s Body Tech 155 Anytown American Legion 102 Anytown Filley Co 008 Baptist Bible Hour 012 Bommer Ford 013 Bommer Tractor 017 Caraway Ford Mercury 019 City Utilities 157 Davis And Logan Insurance 027 Donnie s Western Wear And 031 Dubose Insurance 035 Ehrig Bros Ag Products 158 Ferrell Gas Co 043 First United Methodist Churct 057 Gordens Auto Parts 059 Gray Valley Electric Coop 0123 Grav Valley Electric Coop m e e eOoocooooooosroooooo nm e 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 9 36 Natural Log U ser M anual 9 18 Report Type Sales Projections General Tab Report Format Standard is default but you may also use this dropdown box to select a customized report format
49. rive Times gt 12 00 00 AM to to to to to to 5 00 00 AM 10 00 00 AM 2 00 00 PM 7 00 00 DI 11 59 59 11 59 59 DI WeekDays WeekDays WeekDays WeekDays WeekDays WeekDays jurwrFss urwrrss gt urwrrss gt urwrrss D Cancel Natural Log User M anual Page 9 21 9 13 Report Bulk Contract Fulfillment Report Description This report screen generates a report of showing bulk contracts for a selected period all orders applied to those bulk contracts and the number of spots and cost still pending on the bulk contract To get to this report from the main NL menu select Reports Order Reports Bulk Contract Fullfilment See Bulk Contracts in section 3 11 of this manual for a description of bulk contracts q Onthe General tab described below you can select the main settings for the report On the Sort tab you can control how the report is sorted and grouped See section 9 01 q Use the AcctRep Revenue and Custmrs tabs to perform basic report filtering as described in section 9 02 Also see section 9 03 if you need advanced filtering to handle complex filtering q You may customize the report format to select which columns are displayed see section 9 05 the page layout see section 9 06 to select font paper margins and paper orientation and the report title and subtitle see section 9 04 24 Sample Contract Fulfillment Report Re
50. ry report screen has these report periods q Custom Dates You can use the dropdown date boxes to select the date range for the report q This Year Last Year Includes only the current or previous year based on the date in your computer q Last 2 Years Last 3 Years Last 4 Years Last 5 Years Includes the selected number of years On quarterly and monthly reports each year will be on one row and the month or quarter will be columns General Tab Report Revenue You can select to report on gross before agency commission or net after agency commission figures Either way tax is not included in the figures All numbers are rounded to the nearest whole currency value whole dollars in US Natural Log User M anual Page 9 15 9 10 Report Type Agency List Agency Account List Report Description The Agency List report prints a list of agencies The Agency Account List report prints a list of the NL customer accounts belonging to each agency To get to these reports from the main NL menu select Reports Customer Reports Agencies q Onthe General tab described below you can select the main settings for the report Sort tab you can control how the report is sorted and grouped See section 9 01 q You may customize the report format to select which columns are displayed see section 9 05 the page layout see section 9 06 to select font paper margins and paper orientation and the report title and subtitle see section 9
51. s Also see Restore default report format Report Format Standard Report Type Order Rates Lowest Rate Report Period This Month D From Oct sl 2003 tof Oct EL 2003 Spot Pgm Length Avail Types at be Exact Daypart Matching Get Report On the Sort tab you can control how the report is sorted and grouped See section 9 01 Use the Stations AcctRep Revenue and Custmrs tabs to perform basic report filtering as described in section 9 02 Also see section 9 03 if you need advanced filtering to handle complex filtering q You may customize the report format to select which columns are displayed see section 9 05 the page layout see section 9 06 to select font paper margins and paper orientation and the report title and subtitle see section 9 04 Natural Log User M anual Page 9 19 9 12 Report Type Order Rates cont General Tab Report Type The Order Rates report screen has 3 types of reports Note On these reports all rates listed are pre tax gross pre commission NOTE On package rate orders for the purposes of these reports NL8 shows the per broadcast rate computed by dividing the package amount billed in the report period by the number of items running in the report period q Order Rates Summary Prints a summary of each order s low average and high rate along with if applicable the discount percent and agency co
52. s run dates etc B Order List Confirmations Print a confirmation for each order This is useful to print confirmations for quite a few Orders and it would inconvenient to do each individually from the Order entry screen Order List Sponsorships Prints a summary for each order line containing the specified Avail Type Order List Missing Copy Scans all orders running in the specified period and reports only those with CopyID missing or with other copy problems such as hold status wrong length copy or expired copy 24 Sample Order List Missing Report Report View Tools Help sel com 6 Memorize Export Print Help Close Report Settings Filters General Sot Stations 0112 002 Abx Cablevision Of Tex Abx Cablevision O 10 1 03 10 31 03 Cablevision 10 1 03 10 31 03 Cablevision 10 1 03 10 31 03 Abx Cablevision O 10 1 03 10 31 03 Cablevision 10 1 03 10 31 03 Arnolds Jewelers 9 2 03 12 31 03 Arnolds Jewelers 9 2 03 12 31 03 Arnolds Jewelers 9 2 03 12 31 03 Asap Paging Dn 03 11 30 03 Asap Paging 104 103 10 31 403 Asap Paging 10A7 03 10 31 03 Asap Paging 104 103 10 31 03 Asap Paging 10 4 03 1 0 31 403 Asap Paging 104 03 10 31 103 Bommer Ford 972103 1 2 31 103 Bommer Ford 9 2103 1 2 31 103 Bommer Tractor 9 2 03 12 31 03 Bommer Tractor 9 2 03 12 31 03 Bordens Inc 9 1 03 12 31 03 Bordens Inc 9 1 03 12 31 03 0016 001 Brooks amp Lee Funeral Brooks amp L
53. s showing the tax you have collected during the report period based on either invoices issued or payments received To get to these reports from the main NL menu select Reports Transactions Tax Reports General tab described below you can select the main settings for the report Sort tab you can control how the report is sorted and grouped See section 9 01 Use the Stations AcctRep Revenue and Custmrs tabs to perform basic report filtering as described in section 9 02 Also see section 9 03 if you need advanced filtering to handle complex filtering q You may customize the report format to select which columns are displayed see section 9 05 the page layout see section 9 06 to select font paper margins and paper orientation and the report title and subtitle see section 9 04 24 Sample TaxDue Invoices Report Report View Tools Help i ex v Memorize Export Print Help Close Report Settings Filters Tax Liability Report Sample for the Period 1 1 03 to 12 31 03 Sot Stations Taxttem 6 125 Sales Tax This report shows Taxes Due assuming Taxes must be submitted to the tax collector upon Invoice being issued 03090011 DEMO FM 0004 001 Apache 9 30 03 150 00 127 50 150 00 6 1200 9 19 03090014 DEMO AM 0007 002 amp sap P 3 30 03 275 00 233 75 275 00 6 12002 16 94 6 1254 Sales 425 00 361 25 425 00 6 12504 26 03 Report Format Standard et Report Type
54. sume you have your Inventory Report daypart columns set up as 6 10A 10 3P 3 7P 7P 12MID and 6A 7P In this case NL8 must count the spot as running in the 6A 7P daypart but should it also count it as running in any of the 6 10A 10A 3P or 3 7P columns You select how you want NL8 to handle these wide time window spots when generating the Inventory Report Distribute Non Fixed Spots IS checked NL8 will pick an approximate time for a wide time window spot and include it in any daypart columns in which the assumed time falls This means a proportional share of wide time window spots are included in the daypart column because we know at least some will be run in that daypart even though they could be moved out to another daypart column within the spot time window In the example above NL8 would randomly select one of the 3 narrower dayparts 6 10A 10A 3P or 3 7P to count the spot in addition to the 6A 7P column This method gives better results if you want to know the overall expected inventory usage levels you will see after the final log is generated Distribute Non Fixed Spots IS NOT checked NL8 will include in a daypart column only those items that must be logged within that daypart column Any items with a wide time window could be moved out of that daypart column so the avail slots within the narrower daypart are technically still available to be sold In the example above NL8 would not count the spot in any of the 3 narrower dayparts
55. t Summary Detail Order List Sponsorships Missing Copy Report Order Rates Bulk Contract Fulfillment QQ 2 2 2 Log Reports Log Summary Report Log Detail Report Log Times Report NonLog Charge Summary Report NonLog Charge Detail Report Q22Q2 2 2 2 Accounts Receivable Reports AR Aging Summary Report AR Aging Detail Report AR Reconciliation Summary AR Reconciliation Detail Report UnApplied PrePayments Report 2 2 Transactions Reports Invoices Summary Report Invoices Detail Report Payments Summary Report Payments Detail Report Aged Collections Report Adjustments Summary Report Adjustments Detail Report Finance Charges Summary Report Finance Charges Detail Report TaxDue Invoices TaxDue Payments Q2aQQ2202 2222 2 2 2 Projection Reports Sales Projection Summary Report Sales Projection Detail Report Sales Projection Comparative Inventory Reports Inventory Sold Report Inventory Unsold Report Inventory Total Avails Report Inventory Sold VS Unsold Report Inventory Sold VS UnTotal Report Inventory Avg Rate Report Inventory Total Cost Report 2 2 9 2 See section 9 11 See section 9 11 See section 9 11 See section 9 12 See section 9 13 See section 9 14 See section 9 14 See section 9 14 See section 9 14 See section 9 14 See section 9 15 See section 9 15 See section 9 15 See section 9 15 See section 9 15 See section 9 16 See sectio
56. t of the payments received during the report period Report columns include Payment Amount Tax Amount Net Amount Agency Commission AccountRep Commission and National Rep Commission Aged Collections Report Prints a detail 1 row per invoice of the payments received during the report period The amounts are shown in columns based on the number of days outstanding the balance was when collected Adjustments Summary Prints a summary 1 row for each customer of the adjusting entries posted during the report period Items are listed in columns based on the type of adjustment Report columns include Debit Credit Trade Credit Bad debt Agency Commission Tax Adjustments Detail Prints a detail 1 row per transaction of the adjusting entries posted during the report period Items are listed in columns based on the type of adjustment Report columns include Debit Credit Trade Credit Bad debt Agency Commission Tax q Finance Charges Summary Prints a summary 1 row for each customer of the finance charges added during the report period Report columns include Amount Tax and Total q Finance Charges Detail Prints a detail 1 row per invoice of the finance charges added during the report period Report columns include Amount Tax and Total Examples of transaction reports are shown on the next pages Also see TaxDue Reports in section 9 17 Natural Log User M anual Page 9 29 9 16 Report Type Transactions
57. t or Browser list Setting Column Widths When you preview a report or a Log printout or on a Browser screen you may drag the column separators left or right to adjust the column widths Natural Log will remember the most recent column settings for each report and the Browser screen Natural Log User M anual Page 9 9 9 06 Report Printer Page Setup Design Screen To set the page layout you first need to display the Design screen you first need to display the Design screen by selecting Report Customize Report Format on any report screen the Browser Settings button on any Browser screen or the Print LogPage Setup on the Log Editor screen After making changes click the View Print button to refresh the report You do not need to save the report settings changes unless you want to save them for future use with this report format See Saving customized report formats Standard Sales Projection Summary Report Design 9 x View Print Help Cancel Page SetUp m Paper Orientation m Printer Font Portrait Font rial C LandScape Sie SetFont Margins Copies Top Margin pe Bottom Margin ps H z Left Margin pe lt z Right Margin 057 Orientation If your printer permits you may select Portrait or Landscape paper orientation Landscape will rotate the paper 90 degrees and allow more width for printing data on each line Font amp FontSize Y
58. tes reports showing transactions posted during the report period To get to these reports from the main NL menu select Reports Transactions General tab described below you can select the main settings for the report On the Sort tab you can control how the report is sorted and grouped See section 9 01 q Use the Stations AcctRep Revenue and Custmrs tabs to perform basic report filtering as described in section 9 02 Also see section 9 03 if you need advanced filtering to handle complex filtering q You may customize the report format to select which columns are displayed see section 9 05 the page layout see section 9 06 to select font paper margins and paper orientation and the report title and subtitle see section 9 04 add Invoices Detail la x Report View Tools Help w l com SR od ce Memorize Export Print Help Close Report Settings Filters Invoiced Sales Report Sample for the period 9 1 03 through 9 30 04 Gross Discount Agency Sponsor 03090001 DEMO FM 0146 001 15t Anr 93 00 0 00 0 00 93 00 0 00 0146 1St Ann Hispanic Brdcstrs 93 00 0 00 0 00 93 00 0 00 03090002 DEMO AM 0112 001 Tci Cat 03090003 DEMO FM 0112 002 Tci Cat 0112 Abx Cablevision Of Texas Report Format Standard Report Type Invoices Detail Report Period Custom Dates From s ep zjjn 2003 tol Sep 2004 03090004 DEMO AM 0001 003 Allen s 03100001
59. ts in the NL system Running Include only bulk contracts that run during the specified period Starting Include only bulk contracts starting their run within the specified period Expiring Include only bulk contracts ending their run within the specified period 2 General Tab Basis The Bulk Contract Fulfillment report may apply spots and cost based on Orders Entered All orders entered and applied to the contract are assumed to run to as ordered q Invoices Issued Only actual Invoices are counted against the contract totals This may make it appear a customer has not fulfilled his bulk contract if there are still pending orders not yet invoiced Natural Log User M anual Page 9 23 9 14 Report Type Log Reports Report Description This report screen generates reports of log activity for one or more days To get to these reports from the main NL menu select Reports Log Reports You can also access this report form the Log Editor screen General tab described below you can select the main settings for the report Sort tab you can control how the report is sorted and grouped See section 9 01 Use the Stations AcctRep Revenue and Custmrs tabs to perform basic report filtering as described in section 9 02 Also see section 9 03 if you need advanced filtering to handle complex filtering q You may customize the report format to select which columns are displayed see section 9 05 the page l
60. you have previously saved See saving customized report formats and restore default report format in section 9 07 General Tab Report Type The Sales Projection Report screen has 3 types of reports q Sales Projection Summary Prints a summary 1 row for each customer of the expected invoice totals issued during the report period Report columns show totals for individual periods within the total report period depending on the report period selected q Sales Projection Detail Prints a detail 1 row per broadcast order of the invoices projected to be issued during the report period Report columns show totals for individual periods within the total report period depending on the report period selected q Sales Projection Comparative Prints a comparison between the selected report period projected billing and the projected billing for the same period in the previous year Report columns show totals for individual periods within the total report period depending on the report period selected General Tab Report Period The Sales Projection Report may be based on these Report periods Custom Dates Next Month Next 3 Months Next 6 Months Next 12 Months Next Quarter Next 4 Quarters Next Year This Month This Quarter This Year This Year to Date General Tab Revenue The Sales Projection Report may show amounts based on Gross billing Net after agency commission Gross Tax or Broadcasts General Tab Accrue The Sales Proje
61. ytown American Legion 0102 Anytown Filley Co 0004 Apache Chemical 0005 Apache Tractor amp Implement 0006 Arnolds Jewelers 0007 Asap Paging 0008 Baptist Bible Hour 0011 Bette s Sewing Center 0012 Bommer Ford 0013 Bommer Tractor 0015 Bordens Inc 0016 Brooks amp Lee Funeral Home 0017 Caraway Ford Mercury 0142 Charlie Bartoz Dozer Contractr 0019 City Utilities 0020 Clothes Tree 0152 Cooper Chev Olds Pontiac 0023 Cow Palace 0143 Daisy Mae s 0157 Davis And Logan Insurance 0026 Dewitt Poth amp Son 0153 Diversified Liquidators 0027 Donnie s Western Wear nd Invoiced Sales Report Sample for the period 9 1 03 through 9 30 03 Gross Discounts Agency Nei 278 30 0 00 593 75 80 00 31 50 200 00 150 00 60 00 24 00 275 00 80 00 150 00 417 00 167 50 120 00 15 00 293 25 24 00 406 25 100 00 105 00 115 50 42 00 60 00 155 00 144 00 54 00 conn BE AcctHep 4 Page 9 30 Natural Log U ser M anual 9 16 Report Type Transactions cont 2 4 Payments Detail Report View Tools Help PEE ude 51 Memorize Export Print Help Close Report Settings Filters Revenue AccRep Report Format Standard Report Type Payments D etail bd Report Period Custom Dates Frem Jan 2004 x tof Feb s 2004 Payments Report Sample for the period 1 1 04 through 2 29 04 Payment Ted He

Download Pdf Manuals

Related Search

Related Contents

USER`S MANUAL 170-543-0004 - Bison Gear and Engineering  Boutique PDF.qxp    KitchenAid KFIS25XVMS9 Refrigerator User Manual  Toro 345 Speaker User Manual  20i-T/30i-T 20i-TB / 30i-TB Manuale  

Copyright © All rights reserved. Failed to retrieve file