Client Activity – $ Columns to Print

On the Client Activity Report Profiles window and on the Client Activity Inquiry prompt window, use these codes in the $ Columns on Detail and $ Columns on Summary fields to indicate the dollar columns to print on the report.

Note: Only the Unit Summary Report has fixed, hard-coded columns. These are: Vendor, Vendor Desc, Space DS/Unit Code, Count, Gross Ordered, Net Ordered, Estimated Billable, and Estimated Revenue. This report is subtotaled by vendor and type of measures, then summarized on the last page.

You may key a combination of up to four codes and/or spaces. Sometimes there may not be enough space to include all selected columns on the report. See the Note below.

CODE	DESCRIPTION
1	Gross
2	Net
3	Gross less Cash Discount
4	Net less Cash Discount
5	Vendor Commission (always at standard vendor rate).
6	Cash Discount
7	Gross - CD Billed
8	Net - CD Paid
A	Estimated Billable on a buy-by-buy basis. Prints the amount estimated to be billable for each insertion, using the billing formula from the Client Profile.
D	Premium Cost.
E	Rate.
F	Gross Billed.
G	Gross Billable.
H	Gross-CD Billable.
I	Net Billed.
J	Net-CD Billed.
K	Net Billable.
L	Net-CD Billable.
M	Net-CD Payable.
R	Estimated Revenue.

Note: Four options on the Client Activity Report Profiles window plus the Match Date and Ad Group settings on the main request window determine which columns print on the report. Since there is not room for all columns to print, some columns are omitted when you request too many. If you select Invoice for the Match Date, an invoice date column always prints. Ad Number and/or Ad Caption are next in priority, then the Date Columns. The $ Columns are last in priority and are eliminated, when necessary, starting with the leftmost column.