6.4.4 Cancellation Campaign Item, Invoice and Invoice Item Creation

Important note: A cancellation wizard should not be used. We highly recommend using the Optimization wizard (Optimizer) to cancel invoices and campaign items.

When canceling items through the Cancellation Wizard, the Optimizer or individually, the cancellation items are cloned from the original items. When creating new records, certain fields are cloned, reset or changed/set by certain logic. An overview of this per field, per Object, can be found i the tables below:

Invoice Item

Label

Changed to

Reset

Clone

Label

Changed to

Reset

Clone

AC





x

AdDayOfWeek





x

AdHourOfDay





x

AdKeyValues





x

AdOperatingSystems





x

Ad Type External





x

Ad Type





x

Ad Spec Description on PDF





x

Ad Spec Distribution





x

Ad Spec External Name





x

Ad Spec





x

Placement External





x

Placement





x

Site External





x

Site





x

Ad Spec Use External Name on PDF





x

Sales Representative Country Code





x

AdWebBrowsers





x

Agency Earnings





x

Agency Earnings Amount





x

Amount Net





x

Billing Category





x

Billing Period End Date





x

Billing Period Start Date





x

Booked Quantity





x

Campaign Item





x

Quantity Discount Abs. Custom





x

Customer Discount Abs. Custom





x

Agency Discount Abs. Custom





x

Special Discount Abs. Custom





x

Connected Item

Lookup to cancelled item





Days This InvoiceItem





x

Days This Item





x

Day Time Targeting





x

Delivery AutoImport





x

Description (deprecated)





x

Distribution (Note)





x

Distribution (Period)





x

Distribution (Ratio)





x

Distribution (Unit)





x

eCPM





x

FC AdServed Every





x

FC Period





x

FC Quantity





x

Flexible Payment Amount





x

Frequency





x

Frequency Capping





x

Start Date





x

Gross Amount B1





x

Gross Amount B2





x

Gross Amount B3





x

Guaranteed AI





x

Hide Brands/Products On PDF





x

Hide Content Targeting On PDF





x

Hide FC On PDF





x

Hide Geo/Device Targeting on PDF





x

Hide Geo Targeting On PDF





x

Hide Key Value Targeting On PDF





x

Hide Package Header Details on PDF





x

Hide Publication Date Targeting On PDF





x

Hide Technical Targeting On PDF





x

Hide Time Targeting On PDF





x

Installment





x

Interval End Date





x

Interval Start Date





x

Invoice

Lookup to new pre-invoice





Invoice Accounting Date





x

Invoice Accounting End Date





x

Invoice Amount





x

Invoice Creation Type

Merge per period:

  • Cancellation Invoice

Merge all:

  • Cancellation and Merge all Invoice



x

Cloned for standard cancellation (value of zero)

Invoiced Amount N1





x

Invoiced Amount N2





x

Invoiced Amount N3





x

Invoice Date

Set by logic





InvoicedQuantity





x

Invoiced Quantity Multiplier





x

Invoice Item End Date





x

Invoice Item Start Date





x

Invoice Surcharge B2 (Abs.)





x

Invoice Surcharge B3 (Abs.)





x

Is CPM Price





x

Item Id





x

Item Record Type





x

Linear Distribution





x

Line Description





x

Non-Media





x

Package





x

Packet Item Id





x

Packet Item Package





x

Payment Status





x

Position Number





x

Position Number Appendix

Set by logic





Prorated





x

Delivered Quantity





x

Quantity Delivered Sum





x

Rate Criterion





x

Quantity Discount





x

Quantity Discount Abs.





x

Invoice Quantity Discount Abs. Custom





x

Customer Discount





x

Customer Discount Abs.





x

Invoice Customer Discount Abs. Custom





x

Customer Discount (Name)





x

Agency Discount





x

Agency Discount Abs.





x

Invoice Agency Discount Abs. Custom





x

Special Discount





x

Special Discount Abs.





x

Invoice Special Discount Abs. Custom





x

Special Discount (Name)





x

Salesprice





x

Selected AdServer ID Information





x

Selected Brands/Products Information





x

Selected City Information





x

Selected Content Information





x

Selected Country Information





x

Selected Publication Date Information





x

Selected Region Information





x

Show on PDF





x

Show Packet Component On PDF





x

Show Third Party Commission (deprecated)





x

Sort Order





x

Status



x

Both Merge Cancellations

x

Cloned for standard cancellation (value of zero)

Surcharge B2 (%)





x

Surcharge B2 (Abs.)





x

Surcharge B3 (%)





x

Surcharge B3 (Abs.)





x

Surcharge Sales Price





x

Surcharge Sales Price %





x

Taxable Amount Type





x

Third Party Commission





x

Third Party Commission Abs.





x

Total Discount (abs.)





x

TPC Campaign Item



x



Unique Key

Set by logic

Merge: zero in original invoice item





End Date





x

VAT Amount





x

VAT-Exempt





x

VAT External Name





x

VAT Rate %





x

VAT Total





x

VAT Type





x

Created By ID





x

Created Date





x

Currency ISO Code





x

Record ID





x

Deleted





x

Last Activity Date





x

Last Modified By ID





x

Last Modified Date





x

Invoice Item





x

System Modstamp





x

Invoice

Label

Changed to

Reset



Clone

Label

Changed to

Reset



Clone

Accounting Date





x

Accounting End Date





x

Accounting Period



x

Both Merge Cancellations

x

Cloned for standard cancellation (value of zero)

Advertised Brand Name





x

Advertiser Billing City





x

Advertiser Billing Country





x

Advertiser Billing Postal Code





x

Advertiser Billing State





x

Advertiser Billing Street





x

Advertiser Billing Streets





x

Advertiser Contact Name





x

Advertiser Contact Email





x

Advertiser Contact Fax





x

Advertiser Contact Phone





x

Advertiser Debtor Id





x

Advertiser Id





x

Advertiser Name





x

Advertiser Number





x

Advertiser VAT Id





x

Agency Billing City





x

Agency Billing Country





x

Agency Billing Postal Code





x

Agency Billing State





x

Agency Billing Street





x

Agency Billing Streets





x

Agency Contact Name





x

Agency Contact Email





x

Agency Contact Fax





x

Agency Contact Phone





x

Agency Debtor Id





x

Agency Id







Agency Name





x

Agency Number





x

Agency VAT Id





x

Beneficiary Billing City





x

Beneficiary Billing Country





x

Beneficiary Billing Postal Code





x

Beneficiary Billing State





x

Beneficiary Billing Street





x

Beneficiary Billing Streets





x

Beneficiary Debtor Id





x

Beneficiary Id





x

Beneficiary Name





x

Beneficiary Number





x

Beneficiary VAT Id





x

Billing Period End Date





x

Billing Period Start Date





x

Billing Run



x



Campaign Name





x

Creation Type

Merge per period:

  • Cancellation invoice

Merge all:

  • Cancellation and Merge all Invoice



x

Cloned for standard cancellation (value of zero)

Payment Due Date





x

Days Early Payment Discount





x

Description





x

Invoice Dispatch Type

When no value: changed to Print

x

When there is a value



Early Payment Discount





x

Early Payment Discount abs.





x

eCPM





x

End Date





x

ESR Amount





x

ESR Code





x

ESR Id





x

ESR Number





x

ESR Reference Number





x

ESR Type





x

External Media Campaign Name





x

Gross Amount B1





x

Gross Amount B2





x

Gross Amount B3





x

Hide components of adhoc packages on PDF





x

Intermediary Billing City





x

Intermediary Billing Country





x

Intermediary Billing Postal Code





x

Intermediary Billing State





x

Intermediary Billing Street





x

Intermediary Billing Streets





x

Intermediary Debtor Id





x

Intermediary Id





x

Intermediary Name





x

Intermediary Number





x

Intermediary VAT Id





x

Invoice





x

Invoiced Amount Gross (deprecated)





x

Invoiced Amount Gross (incl. EPD)





x

Invoiced Amount Gross (N2)(deprecated)





x

Invoiced Amount gross normal(deprecated)





x

Invoiced Amount Gross reduced deprecated





x

Invoiced Amount N1





x

Invoiced Amount N2





x

Invoiced Amount N3





x

Invoiced Amount Gross (Total)





x

Invoiced Amount Gross (VAT Type 1)





x

Invoiced Amount Gross (VAT Type 2)





x

Invoice Date

recalculated





Invoice Date (Manual)



x



Invoice Email





x

Invoice Full Number

Set by logic





Invoice Generation Setting





x

Invoice Legal Entity Number



x



Invoice Number



x



Invoice Number Prefix





x

Invoice Number Suffix





x

Invoice Type

Standard Cancellation:

  • Credit note cancellation

Cancellation wizard merge periods and merge all:

  • Invoice

Cancellation optimizer merge periods and merge all:

  • Credit note

With version 2.167 “Merge All Cancelation” type Invoice and invoice items can be canceled unless those are cancelation invoice items. So even when you try to cancel full Merge All Cancelation type invoice only invoice items that have no connected items as a reference (Cancelation items) will be canceled.





Debtor





x

Invoiced?





x

Items on PDF





x

KeyExtension





x

Legal Entity





x

Legal Entity Country





x

Media Campaign





x

N3





x

New VAT Calculation





x

Non-Media Amount





x

Nontaxable Amount (Total)





x

External Order No.





x

Order No.





x

Payment Due to





x

Payment Interval





x

Payment Start





x

Payment Status





x

Payment Terms





x

Postal-Recipient Billing City





x

Postal-Recipient Billing Country





x

Postal-Recipient Billing Postal Code





x

Postal-Recipient Billing State





x

Postal-Recipient Billing Street





x

Postal Recipient Billing Streets





x

Postal-Recipient Debtor Id





x

Postal-Recipient Id





x

Postal-Recipient Name





x

Postal-Recipient Number





x

Postal-Recipient VAT Id





x

Pre-Invoice Number





x

QuoteLanguage





x

QuoteLocale





x

Quantity Discount





x

Quantity Discount Abs.





x

Customer Discount





x

Customer Discount Abs.





x

Agency Discount





x

Agency Discount Abs.





x

Special Discount Abs.





x

Debtor Billing City





x

Debtor Billing Country





x

Debtor Billing Postal Code





x

Debtor Billing State





x

Debtor Billing Street





x

Debtor Billing Streets





x

Debtor Contact Name





x

Debtor Contact Email





x

Debtor Contact Fax





x

Debtor Contact Phone





x

Debtor Debtor Id





x

Debtor Id





x

Debtor Name





x

Debtor Number





x

Debtor VAT Id





x

Reverse-Charge Mechanism





x

Sales Representative





x

Sales Tax Id





x

Show Third Party Commission





x

Start Date





x

Status

Created



x

Sum of Agency Commission





x

Taxable Amount (Total)





x

Taxable Amount (VAT Type 1)





x

Taxable Amount (VAT Type 2)





x

Terms of Payment Days Net





x

Terms of Payment Text





x

Third Party Commission





x

Third Party Commission Abs.





x

Total Amount Due (deprecated)





x

Total Discount Abs.





x

Transaction Type





x

Unique Key





x

VAT Amount (Type 1)





x

VAT Amount (Type 2)





x

VAT Exempt





x

VAT External Name (Type 1)





x

VAT External Name (Type 2)





x

VAT External Name (VAT Exempt)





x

VAT Rate % (Type 1)





x

VAT Rate % (Type 2)





x

VAT Total





x

Reference Number





x

Created By ID





x

Created Date





x

Currency ISO Code





x

Record ID





x

Deleted





x

Last Activity Date





x

Last Modified By ID





x

Last Modified Date





x

Invoice





x

Owner ID





x

System Modstamp





x



Campaign Item

Label

Changed to

Reset

Clone

Label

Changed to

Reset

Clone

AC





x

Ad Id





x

Ad Price





x

Ad Spec





x

AdAreaCodes





x

AdBrowsersMajor Version





x

AdBrowsersMinor Version





x

AdDayOfWeek





x

Additional Ad Ids





x

AdHourOfDay





x

Internet Service Providers





x

AdKeyValues





x

AdKeyWords





x

Ad Manager Status





x

AdOperatingSystems





x

AdPostalCodes





x

Adserver Adv. (Advertiser ID)





x

Adserver ID Order ID





x

Adserver Name





x

Adserver Price





x

AdServer Proposal ID





x

AdServer Proposal Line Item ID





x

Adserver Status





x

AdServer Targeting





x

AdStatesRegions





x

Ad Type





x

AdWebBrowsers





x

Agency Commission (%)





x

Agency Earnings





x

Agency Earnings Condition







Alternate ID





x

Amount





x

Amount (B2)





x

Amount (B2) (apex)





x

Amount (B3)





x

Amount (B3) (apex)





x

Amount net3





x

Amount net3 (apex)





x

Amount net





x

Amount net/net





x

Amount_net_net (apex)





x

Amount net (apex)





x

Amount (apex)





x

Availability (planned)





x

Availability (running)





x

Available





x

AV AS Eligible AI





x

AV AS Measurable AI





x

AV AS Measurable AI Rate





x

AV AS Viewable AI





x

AV AS Viewable AI (Manual)





x

AV AS Viewable AI Rate





x

AV Total Eligible AI