...
Functionality of Status “Reviewed”:
Reviewed pre-invoices are not updated, similar to invoiced invoices.
Draft pre-invoices can be updated or reassigned as needed.
Resetting Status to Draft:
If any amounts (B3 → N3) change or new pre-invoice items match a reviewed pre-invoice, the status is reset to Draft.
Prevents creation of unnecessary additional delta pre-invoices.
Invoice Assignment Rules:
Ensures that pre-invoice assignments are managed efficiently without creating duplicate pre-invoices.
Rounding during delta preinvoice generation
...
Validations relevant to Pre-
...
invoice Generation
...
InvoiceAmount__c
GrossAmountB3__c
GrossAmountB2__c
GrossAmountB1__c
InvoicedAmountNet1__c
InvoicedAmountNet2__c
InvoicedAmountNet3__c
InvoiceSurchargeB3Abs__c
InvoiceSurchargeB2Abs__c
RateDiscount1AbsCustom__c
RateDiscount2AbsCustom__c
RateDiscount3AbsCustom__c
RateDiscount4AbsCustom__c
InvoicedQuantity__c
SalesPrice__c
Validations relevant to Pre-invoice Generation
Following validations are in place for Media campaign and Campaign items for when the pre-invoice generation is triggered
...
Media Champaign Conditions
...
Error Message
...
MediaCampaign__c.PaymentInterval__c is not filled
...
Missing fields: Payment Interval, Payment Start, ...
...
MediaCampaign__c.PaymentStart__c is not filled
...
MediaCampaign__c.PaymentDueDate__c is not filled
...
MediaCampaign__c.Campaign_Start_Date__c is not filled
...
MediaCampaign__c.Campaign_End_Date__c is not filled
...
MediaCampaign__c.PaymentInterval__c
is weekly in combination with Custom Fiscal Period enabled on Admin Settings
...
A payment interval weekly (1 week) is not supported when fiscal periods are activated.
...
Champaign Item Condition
...
Error Message
...
Campaign_Item__c.BillMe__c
is not set
...
items without bill me set will be ignored
...
/
...
PacketItem__r.BillMe__c
is not set
...
package components with bill me set will be ignored if the related package header doesn’t have bill me set
Note |
---|
Packages are not supported yet in the delta pre-invoice generation. |
...
/
...
MediaCampaign__c.PaymentInterval__c is weekly and the Billing category is Budget
...
The first encountered budget item related to a weekly media campaign will throw an error
...
Pre-invoice generation is not supported for the Budget billing category with a weekly payment interval.
Info |
---|
Using the media campaign button with standard pre-invoice generation: |
Customers can change unlimited invoicing
to true/false when the campaign items are partially or fully invoiced for delta invoicing.
...
The “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 the Pre-invoice update stage is included in the old billing run. We strongly advise removing all the custom flows or actions related to this button.
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 gives 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 the pre-invoice. With optimizer, the pre-invoice gets updated automatically
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
...
Following validations are in place for Media campaign and Campaign items for when the pre-invoice generation is triggered
Media Champaign Conditions | Error Message |
---|---|
|
|
| |
| |
| |
| |
|
|
Champaign Item Condition | Error Message | |||
---|---|---|---|---|
| items without bill me set will be ignored | / | ||
| package components with bill me set will be ignored if the related package header doesn’t have bill me set
| / | ||
| The first encountered budget item related to a weekly media campaign will throw an error | Pre-invoice generation is not supported for the Budget billing category with a weekly payment interval.
|
Customers can change unlimited invoicing
to true/false when the campaign items are partially or fully invoiced for delta invoicing.
Info |
---|
The “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 the Pre-invoice update stage is included in the old billing run. We strongly advise removing all the custom flows or actions related to this button. 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 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 the pre-invoice. With optimizer, the pre-invoice gets updated automatically |
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 |
|
|
Calculation used for Surcharge B3 Abs |
|
|
Amount B2 before rounding |
|
|
Rounding Mode |
|
|
Amount B2 rounded |
|
|
Rounding during delta preinvoice generation
All the following values during the Pre-Invoice Generation are rounded off before the invoice items are saved to the database.
InvoiceAmount__c
GrossAmountB3__c
GrossAmountB2__c
GrossAmountB1__c
InvoicedAmountNet1__c
InvoicedAmountNet2__c
InvoicedAmountNet3__c
InvoiceSurchargeB3Abs__c
InvoiceSurchargeB2Abs__c
RateDiscount1AbsCustom__c
RateDiscount2AbsCustom__c
RateDiscount3AbsCustom__c
RateDiscount4AbsCustom__c
InvoicedQuantity__c
SalesPrice__c
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.
...