Cancelations

New fields for cancelation:

The following new fields have been created for cancelations functionality

1. Field Details:

• Object: Campaign_Item__c

• Field API Name: Status__c

• Field Label: Status

• Field Type: Picklist

• Picklist Values (No additional values should be added manually by users):

  • “Blank”

  • "Canceled"

• Permissions: ADvendio Super User will have permission set with both "Read" and "Write" access.

2. Field Details:

• Object: InvoiceItem__c

• Field API Name: CreationType__c

• Field Type: Picklist (existing field)

• Addition to Picklist Value:

  • "Cancelation"

• Permissions: New picklist value "Cancelation" is available to all users who currently have access to the CreationType__c field.

Campaign Item Cancelations

Campaign items cancelation during the Optimizing Version Activation (Proactive, Reactive & Delta) now includes adjustments to references, status updates, and alignment with delta pre-invoice generation rules

Adjustments to Cancelation Processing

• Cancelation pre-invoice items now reference the original campaign item instead of the cancellation campaign item.

• The Status__c of the canceled campaign item is updated to "Canceled". Once Status__c field has been set to "Canceled” this cannot be changed or altered manually through UI or through API.

• The CreationType__c of cancellation pre-invoice items is also set to "Cancellation".

Following updates apply universally to Invoice Cancellations, Invoice Item Cancellations, and Campaign Item Cancellations:

• Cancellation pre-invoice items must adhere to the same rules as general pre-invoice generation.

• For closed accounting periods, cancelation pre-invoice items are assigned to the next open accounting period. If no pre-invoice exists, one is created.

• For open accounting periods, cancelation pre-invoice items are assigned to a matching pre-invoice. If none exists, a new pre-invoice is created.

• Pre-invoice items for periods with a later closed accounting period behave as though the period is closed.

• Payment-related fields are ignored for calculating the invoiced date in delta-enabled scenarios.

Invoice and Invoice Item Cancelation

Standard Invoice Cancellation

When an invoice is canceled, the system creates a negative clone called a cancelation invoice. The original invoice status is updated to Canceled.

Invoice Items Cancelation: Previously, the status of related invoice items was left empty. Now, these items will also have their status updated to Canceled, ensuring consistency for customers who require this information at the invoice item level.

Standard Rules for Invoice item cancelations:

1. Negative Multiplier:
   When canceling an invoice item, the system multiplies the relevant fields by -1 to generate the cancellation invoice item values. The following fields are affected:

   • InvoicedQuantity__c

   • InvoiceAmount__c

   • GrossAmountB1__c, GrossAmountB2__c, GrossAmountB3__c

   • InvoicedAmountNet1__c, InvoicedAmountNet2__c, InvoicedAmountNet3__c

   • RateDiscount1Abs__c, RateDiscount2Abs__c, etc.

   • VATAmount__c, DstAmount__c

2. References:
   The cancellation invoice item includes a reference to the original invoice item in the Connected Item field.

3. Status Update:

   • The status of the original invoice item is set to Canceled.

   • The invoice's status is updated to Canceled only if the entire invoice is canceled.

Delta Invoice Item Cancellation

Delta invoice items follow an extended cancellation process, as they introduce additional logic:

1. Automatic Cancelation of Technical Reversal Items:
   If a delta invoice item is canceled, the related technical reversal item is automatically canceled.

2. Negative Multiplier:
   Similar to standard invoice items, the delta invoice item fields are multiplied by -1. This applies to:

   • DeltaGrossAmountB1__c, DeltaGrossAmountB2__c, DeltaGrossAmountB3__c

   • DeltaInvoicedAmountNet1__c, DeltaInvoicedAmountNet2__c, etc.

   • DeltaVATAmount__c, DeltaDstAmount__c

3. Formulas for Delta Amounts:

   • Delta Cancellation Invoice Item Amount:
     (Delta cancellation invoice item amount + technical reversal cancellation item amount)
     Example: -90 + 50 = -40

   • Delta Invoice Item Amount:
     (Delta invoice item amount + technical reversal invoice item amount)
     Example: 90 + -50 = 40

4. References:

   • The Connected Item field references the original delta invoice item.

   • The Position Reference is set to null.

5. Status Update:
   The status of the original delta invoice item and related technical reversal is set to Canceled.

Technical Reversal Cancelation Logic

A technical reversal item cannot be canceled alone. It is automatically canceled when its related delta invoice item is canceled.

1. Negative Multiplier:
   All relevant fields of the technical reversal item are multiplied by -1 to calculate the values for the cancellation.

2. References:
   The Connected Item field references the original technical reversal item, with the Position Reference set to null.

3. Status Update:
   The status of the original technical reversal item is set to Canceled.