Worksheet Buy Totals

The Worksheet Buy Totals columns display to the right of the Worksheet Buy Columns. These columns are display only and are calculated at the buy line level.

These totals columns are automatically updated when Insertion Rates, Insertion Rate Qualifiers, Columns, Unit Qty, Premium Amounts, Premium Qualifiers, Commission Percentages or Cash Discount Percentages are entered or changed:

Gross Ordered	Gross-CD Ordered	Net Ordered	Net-CD Ordered	Vendor Commission
Cash Discount	Gross Billed	Gross-CD Billed	Gross Billable	Gross-CD Billable
Net Billed	Net-CD Billed	Net Billable	Net-CD Billable	Net-CD Paid
Net-CD Payable	Client Billable	Billed Client Billable	Buylines	Cleared Amount
Matched Quantity	Matched Amount	Matched Amount CD	Matched Premium Amt	Matched Premium CD
Unit Quantity	Estimated Client Fee	Net Buy Rate	Gross Buy Rate
Client Bill Rate	Billed Quantity	Remaining Bill Qty

Remaining Bill Qty - Displays the remainder of the total Unit Quantity less the Billed Quantity amount. E.g., the Unit Quantity ordered was 800.000 direct mail pieces; Billed Quantity is 100,000. The Remaining Bill Qty is 700,000.

These totals columns are updated when billing or paying completes. If you are in the Buy Module during one of these procedures, then the columns will be updated when you exit the Module.

Buylines	Gross Ordered	Gross - CD Ordered	Net Ordered	Net - CD Ordered
Vendor Commission	Cash Discount	Gross Billed	Gross-CD Billed	Gross Billable
Net Billed	Net-CD Billed	Net-CD Billable	Net-CD Billed	Net-CD Paid-
Net - CD Payable	Client Billable	Billed Client Billable	Estimated Client Fee	Cleared Amount
Matched Quantity	Matched Amount	Matched CD	Matched Prem Amt	Matched Prem CD
Unit Quantity

The Buylines column is only used to count buylines for the Buylines column in the Summary section of the worksheet. It is not necessary to display this column in the Worksheet Buy Totals to include the buyline count in the Summary section.

Note: Totals are also updated when a trafficked buy is deleted. If a deleted item was billed or paid the resulting adjustment total displays. Trafficking cannot be done if the Buy Module is in use for the same Client, Product, and Estimate.