Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

It is possible to customize the filter fields for all of the finance wizards, which means for PreInvoice, Invoice and Cancellation Wizard. Furthermore, also the table columns can be customized. The following guide will create the standard records, that can be customized.

Table of Contents
maxLevel1

1. Feature Settings - fields, filters and table

To customize the finance wizards navigate to the Overview tab and click on Feature Settings at the section Setup & Settings.

    

...

    

Please click the button New Feature Setting to create a new record with the following data:

Info

It is important to note that the following fields are added by defaults so do not add these:

  • Legal Entity

  • Campaign Runtime Start and End i.e. Campaign_Start_Date__c; Campaign_End_Date__c

Finance Wizard

Feature Setting Name

Feature Name

Template Name

Value

PreInvoice Wizard

FilterFields

Finance

GenerateInvoiceWizard

Account__c;Agency__c

TableFields

Finance

GenerateInvoiceWizard

Account__c;Agency__c

Invoice Wizard

FilterFields

Finance

CreateInvoicesPdfWizard

ADvendio__MediaCampaign__r.PaymentInterval__c;ADvendio__MediaCampaign__r.PaymentStart__c;ADvendio__MediaCampaign__r.PaymentDueDate__c;ADvendio__MediaCampaign__r.Account__c;ADvendio__MediaCampaign__r.Agency__c;ADvendio__MediaCampaign__r.PostalRecipient__c;ADvendio__MediaCampaign__r.invoice_recipient__c

TableFields

Finance

CreateInvoicesPdfWizard

ADvendio__AdvertiserName__c;ADvendio__AgencyName__c;ADvendio__PostalRecipientName__c;ADvendio__RecipientName__c;ADvendio__CampaignName__c;ADvendio__InvoiceDate__c;ADvendio__InvoicedAmountNet3__c

SettingFields

Finance

CreateInvoicesPdfWizard

ADvendio__InvoiceDate__c

Invoice Wizard (Lightning)

Tablefields

Finance

InvoiceWizard

ADvendio__AdvertiserName__c;ADvendio__AgencyName__c;ADvendio__PostalRecipientName__c;ADvendio__RecipientName__c;ADvendio__CampaignName__c;ADvendio__InvoiceDate__c;ADvendio__InvoicedAmountNet3__c;Name

Filterfields

Finance

CreateInvoicesPdfWizard

Same as Invoice Wizard Value

Cancellation Wizard

FilterFields

Finance

InvoiceCancelationItemsWizard

Account__c;Agency__c;PostalRecipient__c;invoice_recipient__c

TableFieldsMasters

Finance

InvoiceCancelationItemsWizard

Name;MediaCampaignFullNumber__c;Account__c;Agency__c;PostalRecipient__c;invoice_recipient__c;OwnerId

TableFieldsItems

Finance

InvoiceCancelationItemsWizard

Name;from_Date__c;until_Date__c;Quantity__c;ADvendio__ad_price__r.ADvendio__ad_spec__r.ADvendio__placement__r.ADvendio__site__c;ADvendio__ad_price__r.ADvendio__ad_spec__r.ADvendio__ad_type__c;ADvendio__ad_price__r.ADvendio__ad_spec__r.ADvendio__placement__c;ADvendio__SelectedContentInformation__c;ADvendio__SelectedPublicationDateInformation__c

Warning

Make sure that you use NO BLANKS between the fields and separate by semicolon.

Example:

...

This table displays the ADvendio Standard for every finance wizard. If those records are not available, the wizards use the ADvendio Standard coming with the source code. Some wizards show additional fields like for instance Runtime Start or Runtime End in

...

the PreInvoice Wizard. Those fields have special logic behind it and can not be changed or removed.

Note

To customize those wizards, please make sure to use the right start object for your field path:

Finance Wizard

Start Object

PreInvoice Wizard

ADvendio__Media Campaign__c

Invoice Wizard

ADvendio__Invoice__c

Cancellation Wizard

ADvendio__Media Campaign__c

Note

Special Logic

Lookup vs Text Fields

If you want to add the start object as a filter, you can use the field API called Name. The result by adding the name is a search field, where you can enter a text string. If you prefer to use the start object as a lookup filter, please use Id instead of Name. The result by adding the id is a lookup field, where you can also filter for records.

Multi-select Picklist: Site

...

Add "Order Number" to the Invoice Wizard

To add a field to the filter section you have to expand the comma separated value field in the above mentioned FilterFields feature setting record using the path of the required object. Start object is the invoice itself. Using the Order number example your value string would look like this:

ADvendio__MediaCampaign__r.PaymentInterval__c;ADvendio__MediaCampaign__r.PaymentStart__c;ADvendio__MediaCampaign__r.PaymentDueDate__c;ADvendio__MediaCampaign__r.Account__c;ADvendio__MediaCampaign__r.Agency__c;ADvendio__MediaCampaign__r.PostalRecipient__c;ADvendio__MediaCampaign__r.invoice_recipient__c;ADvendio__OrderNumber__c;

Your Invoice Wizard filters area will look like this:Image Removed

...

To add a column to the result table you have to expand the comma separated value field in the above mentioned TableFields feature setting record using the path of the required object. Start object is the invoice itself. Using the Order number example your value string would look like this:

ADvendio__AdvertiserName__c;ADvendio__AgencyName__c;ADvendio__PostalRecipientName__c;ADvendio__RecipientName__c;ADvendio__CampaignName__c;ADvendio__InvoiceDate__c;ADvendio__InvoicedAmountNet3__c; ADvendio__OrderNumber__c

Your Invoice Wizard search results will look like this:Image Removed

...

You are able to add other fields as filters or columns for any of the finance wizards.

...

To configure which options are available to your ADvendio users, you can use the ModeAvailability Feature Setting. Navigate to Feature Settings and create or modify* the following record:

  1. Feature Name = Finance

  2. Feature Setting Name = ModeAvailability

  3. TemplateName: InvoiceCancelation

  4. Value: {"CancelationPerPeriod": true, "CancelationMergePeriod": true, "CancelationMergeAll": true}
    Change value to true or false depending on need

* This Feature Setting can also be created by running the postinstall script for Version 2.115.

ADvendio.PostInstall.runMethod('insertFeatureSettingsForInvoiceCancelationModeAvailabilityByVersion2_115',

...

null);Image Removed

...