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.
...
The following new fields for delta invoicing are created which will calculate the outstanding amount on those 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:
InvoicedAmountNet2deltaInvoicedAmountNet2Delta__c + DstAmountDstAmountDelta__c
or
InvoicedAmountNet3deltaInvoicedAmountNet3Delta__c + DstAmountDstAmountDelta__c
Additional Condition:
VATExempt__c == false && VATType__c == '1'
|
TaxableAmountVatType2Outstanding__c
| Outstanding Taxable Amount (VAT Type 2) | Based on TaxableAmountType__c:
InvoicedAmountNet2PdeltaInvoicedAmountNet2Delta__c + DstAmountDstAmountDelta__c
or
InvoicedAmountNet3deltaInvoicedAmountNet3Delta__c + DstAmountDstAmountDelta__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
|
...
Formula fields will not be created for Delta, however, we need to document the formula so that (if needed) customers can create their own custom fields.
Formula | Delta API Name | Delta Label | Normal API Name |
|---|
NonTaxableAmountDstDelta__c + TaxableAmountDstDeltaTaxableAmountDstOutstanding__c + DstAmountDeltaDstAmountOutstanding__c
| InvoicedAmountDstDeltaInvoicedAmountDstOutstanding__c
| Delta Invoiced Amount Gross (DST) | InvoicedAmountDst__c
|
VATAmount1DeltaVATAmount1Outstanding__c + VATAmount1BDeltaVATAmount1BOutstanding__c
| VatTotalType1DeltaVatTotalType1Outstanding__c
| Delta VAT Total (Type 1) | VatTotalType1__c
|
VATAmount2DeltaVATAmount2Outstanding__c + VATAmount2BDeltaVATAmount2BOutstanding__c
| VatTotalType2DeltaVatTotalType2Outstanding__c
| Delta VAT Total (Type 2) | VatTotalType2__c
|
TaxableAmountVatType1DeltaTaxableAmountVatType1Outstanding__c + TaxableAmountVatType2DeltaTaxableAmountVatType2Outstanding__c
| TaxableAmountTotalDeltaTaxableAmountTotalOutstanding__c
| Delta Taxable Amount (VAT Total) | TaxableAmountTotal__c
|
VatTotalType1DeltaVatTotalType1Outstanding__c + VatTotalType2DeltaVatTotalType2Outstanding__c
| VatTotalDeltaVatTotalOutstanding__c
| Delta VAT Total | VatTotal__c
|
TaxableAmountTotalDeltaTaxableAmountTotalOutstanding__c + VatTotalDeltaVatTotalOutstanding__c + NonTaxableAmountTotalDeltaNonTaxableAmountTotalOutstanding__c
| InvoicedAmountTotalDeltaInvoicedAmountTotalOutstanding__c
| Delta Invoiced Amount Gross (Total) | InvoicedAmountTotal__c
|
ROUND(InvoicedAmountTotalDeltaInvoicedAmountTotalOutstanding__c * Early_Payment_Discount__c,2)
| EarlyPaymentDiscountAbsDeltaEarlyPaymentDiscountAbsOutstanding__c
| Delta Early Payment Discount abs. | EarlyPaymentDiscountAbs__c
|
InvoicedAmountTotalDeltaInvoicedAmountTotaOutstanding__c - EarlyPaymentDiscountAbsDeltaEarlyPaymentDiscountAbsOutstanding__c
| InvoicedAmountGrossInclEpdDeltaInvoicedAmountGrossInclEpdOutstanding__c
| Delta Invoiced Amount Gross (incl. EPD) | InvoicedAmountGrossInclEpd__c
|
...