Info

Important Information:

“Update delivery data” button has been removed from the Invoice object and this action of updating the delivered quantity is included in the PreInvoice generation and Pre-invoice update stage is included in the old billing run
When the pre invoices are generated for the media champaign with weekly payment interval when the Admin Setting “Enable calculation of Revenue Schedules Daily“ is disabled it will create Pre-Invoices with a 0 as invoice item InvoicedQuantity__c and QuantityDelivered__c. Kindly report if it give a null pointer error.
If the campaign item is changed/edited without optimizer the changes will not be reflected automatically in the pre invoices and the run pre invoices button has to be triggered to have the change reflected in pre-invoice. With optimizer the pre-invoice gets updated automatically

Threshold Feature

OUT OF SCOPE FOR DELTA VERSION I

The threshold feature allows users to define a minimum percentage change in the calculated amounts which triggers the creation of a delta invoice item.

Assigning Timesheet Activities

If your campaign item is supposed to be invoice-based on the timesheet activities, you need to ensure that your ADspec has a CPH billing category and that your campaign item should have Linear Distribution checked as false and Time Tracking should be true.

The change in the Delta release is that users do not need to press “Update delivered quantity” on the Invoice, since the revenue schedule data is updated automatically in the preinvoice generation.

When the timesheet activity-based campaign item is adjusted and with the delta invoicing, we can have multiple invoice items for the same campaign item with the same InvoiceItemStartDate__c and InvoiceItemEndDate__c. We assign the “latest“ invoice item to the timesheet activity. The latest invoice item is always the one that gets created or updated.

Flexible Payment Plans

With the enhancements in the last version, we enabled the possibility to edit or delete the Flexible payment plans that are not related to the Invoiced Invoice item. To achieve this we have a relationship between Flexible Payment Plan and PreInvoice/Invoice Item to be more transparent about which of those records belong to each other. One Flexible Payment Plan can only have one Preinvoice/Invoice Item related to it. This relation is generated by the Preinvoice generation and can not be set or changed manually.

When an Invoice/invoice item is canceled we do not remove the relation, however, next preinvoice generation will relate the new correct preInvoice item to the flexible payment plan. When the Campaign Item is canceled the relation stays.

The Pre-Invoice Generation validates if the total of all Flexible Payment Plans matches the amount of the Campaign Item. When the total amount or percentage does not match, Preinvoice generation will show the error.

Flexible Payment Plan invoice items will never create technical reversal or delta invoice items. If the campaign item amount changes for those campaign items, new flexible payment plans are created by the user to cover the remaining.

In the Beta I version Flexible payment plan-related pre-invoice items are merged with normal and/or delta pre-invoice items when those have matching accounting periods.

Preinvoice generation will not be automatically triggered by the optimizing version activation and should be called after the Flexible payment plan is adjusted.

We strongly suggest using the standard Salesforce features to track the change history of the Flexible Payment plans to see which users have performed the change.

A Flexible Payment Plan Invoice Items have always following (additional) field setting logic

Field	Value	Notes
`DistributionRatio__c`	See Notes	Is calculated based on related Flexible Payment Plan and related Campaign Item for `PercentageAmount__c != null` `PercentageAmount__c / 100` for `Amount__c != null` `Amount__c /` Campaign Item Amount Which “Campaign Item Amount” is used can be configured in the Admin Settings. Default is `Amount_net_net__c`
`FlexiblePaymentAmount__c`	A “Campaign Item Amount”	Which “Campaign Item Amount” is used can be configured in the Admin Settings. Default is `Amount_net_net__c`
`LinearDistribution__c`	`false`
`DeliveryAutoImport__c`	`false`
`DistributionUnit__c`	`Amount`
`InvoiceItemAccountingDate__c`	`InvoiceDate__c` of related Flexible Payment Plan
`InvoiceItemAccountingEndDate__c`	`Campaign_End_Date__c` of related Media Campaign
`InvoiceItemStartDate__c`	`from_Date__c` of related Campaign Item
`InvoiceItemEndDate__c`	`until_Date__c` of related Campaign Item
`CreationType__c`	`Flexible Payment Plan`

Amount-based Flexible Payment Plan

When the amount-based FPP-related campaign item is optimized or adjusted, the user needs to adjust the amounts in the NOT invoiced Flexible payment plan or add a new one to get the amount matching to the Campaign item.

Percentage-based Flexible Payment Plan

When Percentage based FPP related campaign item is optimized or adjusted, ADvendio will recalculate % of the existing Flexible Payment plan, to represent the ratio or invoiced, where the user needs to adjust the % in the NOT invoiced Flexible Payment plan or add a new one to get 100% of FPP.

We have adjusted the Flexible payment plan field PercentageAmount up to 5 numbers and 2 decimals

Publication Dates Additions

Flexible Payment Plans created by selected Publication Dates are created as percentage-based flexible payment plans.

In cases of adding more selected publication dates, it does not recalculate the % for invoiced or reviewed Flexible Payment Plans because the amount of the campaign item has not changed. Only adjust open Flexible Payment Plans linearly based on the outstanding %.

We also do not allow the deletion of Selected Publication Dates with a relationship to a Flexible Payment Plan where a related Invoice item is invoiced.

Info
Deleting a publication date related to a flexible payment plan that relates to a reviewed pre-invoice item, will delete the related flexible payment plan and the next pre-invoice generation will delete the reviewed pre-invoice.

Invoice at Start / End of Runtime Additions

...

Absolute Surcharges and Discount

A new rounding-off logic is in place for the calculation of absolute surcharges and discounts

Positive absolute surcharges make use of the rounding mode HALF_DOWN
Negative absolute surcharges make use of the rounding mode HALF_UP
Absolute discounts make use of the rounding mode FLOOR
Amounts based on actuals make use of the rounding mode HALF_UP

Due to the new rounding logic, the user may notice a cent difference between periods.

The updated logic ensures that when the total campaign item amount matches the invoice amount (indicating the campaign item was fully invoiced), no delta pre-invoice items are created.

In cases where the campaign item amounts do not match the invoice item amounts combined, delta invoice items will still be created.

The amounts of Absolute discounts and absolute surcharges in case of unlimited invoicing are capped at the amount of Sales Price

Info

The new logic in place would produce a one-cent difference in version 2.171 and 2.172

To avoid this difference in 2.171 users can limit MC where the pre-invoice generation is run (Setting on the admin settings)

The numbers in the table are just for an example

	Version 171 or lower	Version 172+
Surcharge B3 Abs used for amount calculation	`16.66499999999999999999999999999999560010000000`	`16.665`
Calculation used for Surcharge B3 Abs	`Campaign Surcharge B3 / Campaign Item Sales Price * (capped) invoice item sales price`	`Campaign Item Surcharge B3 * invoice item distribution ratio`
Amount B2 before rounding	`1683.33499999999999999999999999999999560010000000`	`1683.335`
Rounding Mode	`HALF_UP`	`HALF_UP`
Amount B2 rounded	`1683.33`	`1683.34`

Commitments

With delta invoicing enabled, the user can apply commitments / re-apply commitments to the campaign items that are partially or fully invoiced. That is, Media Campaign Action “Apply Commitments“ can be used to apply the new commitment conditions to the invoiced campaign items.

Apply commitment condition action button does not apply commitment if the “PreventFieldChanges” feature setting is enabled (This will be fixed in the next version).