Use this report to print what A/R balances are currently outstanding for advertisers only associated with agencies without printing any direct advertisers.
The report looks at the A/R Statement of each advertiser associated with an agency and prints the balances that are currently outstanding. The report will print the total net balance owed for each advertiser and then age the balances out based on the Aging Type setting for the Statement Group. When aging Monthly Calendar, each column represents a literal calendar month and is pulling invoices and transactions that are dated within the calendar period of each month. For Monthly Media, each column represents a literal media month and is pulling invoices and transactions that are dated within the media month of each aging column. The Daily Aging Type is based on the number of days you select as being the current period. This setting is used to customize the number of days of each billing period. Each column in this case would represent a particular number of days i.e. Current, 31-60, 61-90, etc. if 30 days were entered as the number of days for the current period.
There are two main versions of this report: Summary and Detail. Summary will summarize the total net balance and each aging column to the total amount that is owed. The Detail version will print each current or open transaction that makes up the balance in addition to the totals so you can see transaction level detail for invoices, payments, adjustments, etc. If invoices for the current period have not been committed to history, you can run the report to include official invoices. If included, those invoices will have an asterisk (*) next to them to signify they are official. In addition, you can include or exclude advertisers with a zero balance and group the report by the Default Salesperson of each advertiser or the Salesperson that is coded to each transaction.
| Grouping Options | Filter Options | Other Options |
|---|---|---|
| A/R Account Name Agency Default Salesperson Receivables Group Salesperson Statement Group |
A/R Account Advertiser Agency Default Salesperson Receivables Group Salesperson Statement Group |
A/R or Holding Document Group Include/Exclude Official Invoices Salesrep Group for Sep Stmnt Grps Summary or Detail Suppress Zero Balance Advertisers 1st Summary Page 2nd Summary Page 3rd Summary Page |
