Versions Compared

Key

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

The New Delta Pre-Invoice Generation feature ensures that your invoicing process is accurate and up-to-date by comparing the latest invoiced amounts with new amounts and creating delta pre-invoice items for any differences. This feature handles various aspects of invoicing, including timesheet activities, flexible payment plans, packages, and invoice contacts, making your invoicing more efficient and reliable.

...

A new invoice item fields have been created to improve the handling of the Delta Invoicing:

Delta Change Reason

API Name: DeltaChangeReason__c

During the optimization, the reason for the change for every single Campaign item can be added and it is mapped to the invoice item .

API Name: DeltaChangeReason__c
Label: Delta Change Reason
Type: Long Text Area(1000)
Description/Help Text: This field indicates the reason for an adjustment made to an item

API Name: ReferencedInvoiceNumber__c
Label: Referenced Invoice Number
Type: Formula(Text)
Description/Help Text: This field indicates the invoice number that was modified
Formula:

...

to use it in the Invoice PDF to show the reason for the change.

Referenced Invoice Number

API Name: ReferencedInvoiceNumber__c

This field stores the original invoice number which was adjusted.

Position Reference

API Name: PositionReference__c

...

Type: Lookup(Invoice Item)

...

Child Relationship Name: PositionReferences

...

This is a reference to the previous version of the invoice item related to this campaign item

Invoice Item Creation Type

API Name: CreationType__c.

A new picklist field has been created to identify an invoice item creation type CreationType__c. This field is preset automatically and should not be changed by the user.

Following are the picklist values:

  • None - This creation type is the same as the related invoice item. Nothing will change when it comes to displaying this item

  • Flexible Payment plan Plan - Invoice items created based on the Flexible Payment Plan

  • Technical Reversal -This is the negative clone of the previous version

  • Delta Adjustment - This is a new version of the Invoice item after the change. This item would display the new Delta fields

The following new fields for delta invoicing are created which will calculate the outstanding amount based on changes done for Campaigns and what was already invoiced.

New API Name

New Label

Invoice Item API Name + Logic

GrossAmountB3Outstanding__c

Outstanding Gross Amount B3

GrossAmountB3delta__c

Additional Condition:
NonMedia__c == false

GrossAmountB2Outstanding__c

Outstanding Gross Amount B2

GrossAmountB2delta__c

Additional Condition:
NonMedia__c == false

GrossAmountB1Outstanding__c

Outstanding Gross Amount B1

GrossAmountB1delta__c

Additional Condition:
NonMedia__c == false

InvoicedAmountNet1Outstanding__c

Outstanding Invoiced Amount N1

InvoicedAmountNet1delta__c

Additional Condition:
NonMedia__c == false

InvoicedAmountNet2Outstanding__c

Outstanding Invoiced Amount N2

InvoicedAmountNet2delta__c

Additional Condition:
NonMedia__c == false

InvoicedAmountNet3Outstanding__c

Outstanding Invoiced Amount N3

InvoicedAmountNet3delta__c

Additional Condition:
NonMedia__c == false

NonMediaAmountOutstanding__c

Outstanding Non-Media Amount

InvoicedAmountNet3delta__c

Additional Condition:
NonMedia__c == true

DstAmountOutstanding__c

Outstanding DST Amount

DstAmountdelta__c

Additional Condition:
DstRelevant__c == true && DstExempt__c == false

NonTaxableAmountDstOutstanding__c

Outstanding Nontaxable Amount (DST)

Based on TaxableAmountType__c:
InvoicedAmountNet2delta__c
or
InvoicedAmountNet3delta__c

Additional Condition:
DstRelevant__c == false || DstExempt__c == true

TaxableAmountDstOutstanding__c

Outstanding Taxable Amount (DST)

Based on TaxableAmountType__c:
InvoicedAmountNet2delta__c
or
InvoicedAmountNet3delta__c

Additional Condition:
DstRelevant__c == true && DstExempt__c == false

VATAmount1Outstanding__c

Outstanding VAT Amount (Type 1 (A))

VATAmountdelta__c

Additional Condition:
VATExempt__c == false && VATType__c = '1'

VATAmount1BOutstanding__c

Outstanding VAT Amount (Type 1 (B))

VATAmountBdelta__c

Additional Condition:
VATExempt__c == false && VATType__c = '1'

VATAmount2Outstanding__c

Outstanding VAT Amount (Type 2 (A))

VATAmountdelta__c

Additional Condition:
VATExempt__c == false && VATType__c = '2'

VATAmount2BOutstanding__c

Outstanding VAT Amount (Type 2 (B))

VATAmountBdelta__c

Additional Condition:
VATExempt__c == false && VATType__c = '2'

TaxableAmountVatType1Outstanding__c

Outstanding Taxable Amount (VAT Type 1)

Based on TaxableAmountType__c:
InvoicedAmountNet2Delta__c + DstAmountDelta__c
or
InvoicedAmountNet3Delta__c + DstAmountDelta__c

Additional Condition:
VATExempt__c == false && VATType__c == '1'

TaxableAmountVatType2Outstanding__c

Outstanding Taxable Amount (VAT Type 2)

Based on TaxableAmountType__c:
InvoicedAmountNet2Delta__c + DstAmountDelta__c
or
InvoicedAmountNet3Delta__c + DstAmountDelta__c

Additional Condition:
VATExempt__c == false && VATType__c == '2'

NonTaxableAmountTotalOutstanding__c

Outstanding Nontaxable Amount (VAT Total)

Based on TaxableAmountType__c:
InvoicedAmountNet2delta__c + DstAmount__c
or
InvoicedAmountNet3delta__c + DstAmount__c

Additional Condition:
VATExempt__c == true or TaxableAmountType__c not supported or VATType__c not supported

(warning) QR code feature users should map the correct amount to the ESR reference.

For Non-delta

...

and Normal Items, the following fields are relevant

Those normal roll-up fields do not include the amounts of the technical reversal items.

...