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.
...
Invoice Item Amount Comparison:
comparison of invoice item amounts already invoiced with those that would be calculated by the next pre-invoice generation, for each specified payment interval (total, yearly, half-yearly, quarterly, monthly, weekly).
This comparison is done at the invoice item level, considering amounts B3, B2, B1, N1, N2, and N3
Invoicing Based on Linear Distribution vs. Actual Delivery
There are two types of invoicing: based on the linear distribution and based on actual delivery data (utilizing actual delivery from Revenue Schedules).
For linear distribution, amounts are calculated based on the runtime of the campaign item across payment intervals.
For actual delivery, amounts are calculated based on delivery data in the Revenue Schedule, for billing categories such as CPM, CPC, vCPM, CPCV and Budget
Weekly payment interval is using Revenue Schedules Daily and has to be enabled through the admin setting
New Invoice and invoice item fields
A new invoice item fields have been created to improve the handling of the Delta Invoicing:
...
This field is preset automatically and can should not be changed by the user.
...
None - This creation type is the same as the related invoice item. Nothing will change when it comes to displaying this item
Technical Flexible Payment 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 on those based on changes done for Campaigns and what was already invoiced.
New API Name |
|---|
New Label | Invoice Item API Name + Logic |
|---|
|
Outstanding Gross Amount B3 |
Additional Condition: |
|
Outstanding Gross Amount B2 |
Additional Condition: |
|
Outstanding Gross Amount B1 |
Additional Condition: |
|
Outstanding Invoiced Amount N1 |
Additional Condition: |
|
Outstanding Invoiced Amount N2 |
Additional Condition: |
|
Outstanding Invoiced Amount N3 |
Additional Condition: |
|
Outstanding Non-Media Amount |
Additional Condition: |
|
Outstanding DST Amount |
Additional Condition: |
|
Outstanding Nontaxable Amount (DST) | Based on
|
|
Outstanding Taxable Amount (DST) | Based on
|
|
Outstanding VAT Amount (Type 1 (A)) |
|
|
Outstanding VAT Amount (Type 1 (B)) |
|
|
Outstanding VAT Amount (Type 2 (A)) |
|
|
Outstanding VAT Amount (Type 2 (B)) |
|
|
Outstanding Taxable Amount (VAT Type 1) | Based on
|
|
Outstanding Taxable Amount (VAT Type 2) | Based on
|
|
Outstanding Nontaxable Amount (VAT Total) | Based on
|
QR code feature users should map the correct amount to the ESR reference.
...
The general amount calculation is described here: 4.2.6.2 Amount Calculation and Discounts
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 |
|---|---|---|---|
|
| Delta Invoiced Amount Gross (DST) |
|
|
| Delta VAT Total (Type 1) |
|
|
| Delta VAT Total (Type 2) |
|
|
| Delta Taxable Amount (VAT Total) |
|
|
| Delta VAT Total |
|
|
| Delta Invoiced Amount Gross (Total) |
|
|
| Delta Early Payment Discount abs. |
|
|
| Delta Invoiced Amount Gross (incl. EPD) |
|
Linked issues
Link an issue
blocks
relates to
Analyze, refactor and implement Invoice Item field mapping logic for Delta
IN MERGE
New Fields on the Invoice, Invoice item and campaign item for delta
BACKLOG
Delta: Calculate Invoice Item Delta Amounts
IN MERGE
Pre-Invoice Delta Amount Roll-Ups
IN MERGE
Rename the "Delta" amount fields on the Invoice to "Outstanding"
IN MERGE
Confluence content
Link a Confluence Page
Activity
Show:
AllCommentsHistoryWorklogs
Newest first
...
Assigning Accounting Periods
...