Versions Compared

Old Version 27

changes.mady.by.user Tobias Tillack

Saved on

compared with

New Version 28

changes.mady.by.user Liga Bandere

Saved on

Key

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

...

Invoice API Name

Invoice Field Label

Invoice Item API Name + Logic

GrossAmountB3Outstanding__c

Outstanding Gross Amount B3

GrossAmountB3delta__c

Additional Condition:
NonMedia__c == falseis not set

GrossAmountB2Outstanding__c

Outstanding Gross Amount B2

GrossAmountB2delta__c

Additional Condition:
NonMedia__c == is false

GrossAmountB1Outstanding__c

Outstanding Gross Amount B1

GrossAmountB1delta__c

Additional Condition:
NonMedia__c == is false

InvoicedAmountNet1Outstanding__c

Outstanding Invoiced Amount N1

InvoicedAmountNet1delta__c

Additional Condition:
NonMedia__c == is false

InvoicedAmountNet2Outstanding__c

Outstanding Invoiced Amount N2

InvoicedAmountNet2delta__c

Additional Condition:
NonMedia__c == is false

InvoicedAmountNet3Outstanding__c

Outstanding Invoiced Amount N3

InvoicedAmountNet3delta__c

Additional Condition:
NonMedia__c == is false

NonMediaAmountOutstanding__c

Outstanding Non-Media Amount

InvoicedAmountNet3delta__c

Additional Condition:
NonMedia__c == is true

DstAmountOutstanding__c

Outstanding DST Amount

DstAmountdelta__c

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

NonTaxableAmountDstOutstanding__c

Outstanding Nontaxable Amount (DST)

Based on TaxableAmountType__c:
InvoicedAmountNet2delta__c
or
InvoicedAmountNet3delta__c

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

TaxableAmountDstOutstanding__c

Outstanding Taxable Amount (DST)

Based on TaxableAmountType__c:
InvoicedAmountNet2delta__c
or
InvoicedAmountNet3delta__c

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

VATAmount1Outstanding__c

Outstanding VAT Amount (Type 1 (A))

VATAmountdelta__c

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

VATAmount1BOutstanding__c

Outstanding VAT Amount (Type 1 (B))

VATAmountBdelta__c

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

VATAmount2Outstanding__c

Outstanding VAT Amount (Type 2 (A))

VATAmountdelta__c

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

VATAmount2BOutstanding__c

Outstanding VAT Amount (Type 2 (B))

VATAmountBdelta__c

Additional Condition:
VATExempt__c == is false && VATType__c = is '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 == is false && VATType__c == is '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 == is false && VATType__c == is '2'

NonTaxableAmountTotalOutstanding__c

Outstanding Nontaxable Amount (VAT Total)

Based on TaxableAmountType__c:
InvoicedAmountNet2delta__c + DstAmountDelta__c
or
InvoicedAmountNet3delta__c + DstAmountDelta__c

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

...

Invoice Field API Name

Invoice Field Label

Invoice Item API Name + Logic

GrossAmountB3__c

Gross Amount B3

GrossAmountB3__c

Additional Condition:
NonMedia__c == is false

GrossAmountB2__c

Gross Amount B2

GrossAmountB2__c

Additional Condition:
NonMedia__c == is false

GrossAmountB1__c

Gross Amount B1

GrossAmountB1__c

Additional Condition:
NonMedia__c == is false

InvoicedAmountNet1__c

Invoiced Amount N1

InvoicedAmountNet1__c

Additional Condition:
NonMedia__c == is false

InvoicedAmountNet2__c

Invoiced Amount N2

InvoicedAmountNet2__c

Additional Condition:
NonMedia__c == is false

InvoicedAmountNet3__c

Invoiced Amount N3

InvoicedAmountNet3__c

Additional Condition:
NonMedia__c == is false

NonMediaAmount__c

Non-Media Amount

InvoicedAmountNet3__c

Additional Condition:
NonMedia__c == is true

DstAmount__c

DST Amount

DstAmount__c

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

NonTaxableAmountDst__c

Nontaxable Amount (DST)

Based on TaxableAmountType__c:
InvoicedAmountNet2__c
or
InvoicedAmountNet3__c

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

TaxableAmountDst__c

Taxable Amount (DST)

Based on TaxableAmountType__c:
InvoicedAmountNet2__c
or
InvoicedAmountNet3__c

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

VATAmount1__c

VAT Amount (Type 1 (A))

VATAmount__c

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

VATAmount1B__c

VAT Amount (Type 1 (B))

VATAmountB__c

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

VATAmount2__c

VAT Amount (Type 2 (A))

VATAmount__c

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

VATAmount2B__c

VAT Amount (Type 2 (B))

VATAmountB__c

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

TaxableAmountVatType1__c

Taxable Amount (VAT Type 1)

Based on TaxableAmountType__c:
InvoicedAmountNet2__c + DstAmount__c
or
InvoicedAmountNet3__c + DstAmount__c

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

TaxableAmountVatType2__c

Taxable Amount (VAT Type 2)

Based on TaxableAmountType__c:
InvoicedAmountNet2__c + DstAmount__c
or
InvoicedAmountNet3__c + DstAmount__c

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

NonTaxableAmountTotal__c

Nontaxable Amount (VAT Total)

Based on TaxableAmountType__c:
InvoicedAmountNet2__c + DstAmount__c
or
InvoicedAmountNet3__c + DstAmount__c

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

...

Formula

Delta API Name

Delta Label

Normal Formula API Name (can be taken as reference)

NonTaxableAmountDstDelta__c + TaxableAmountDstOutstanding__c + DstAmountOutstanding__c

InvoicedAmountDstOutstanding__c

Outstanding Invoiced Amount Gross (DST)

InvoicedAmountDst__c

VATAmount1Outstanding__c + VATAmount1BOutstanding__c

VatTotalType1Outstanding__c

Outstanding VAT Total (Type 1)

VatTotalType1__c

VATAmount2Outstanding__c + VATAmount2BOutstanding__c

VatTotalType2Outstanding__c

Outstanding VAT Total (Type 2)

VatTotalType2__c

TaxableAmountVatType1Outstanding__c + TaxableAmountVatType2Outstanding__c

TaxableAmountTotalOutstanding__c

Outstanding Taxable Amount (VAT Total)

TaxableAmountTotal__c

VatTotalType1Outstanding__c + VatTotalType2Outstanding__c

VatTotalOutstanding__c

Outstanding VAT Total

VatTotal__c

TaxableAmountTotalOutstanding__c + VatTotalOutstanding__c + NonTaxableAmountTotalOutstanding__c

InvoicedAmountTotalOutstanding__c

Outstanding Invoiced Amount Gross (Total)

InvoicedAmountTotal__c

ROUND(InvoicedAmountTotalOutstanding__c * Early_Payment_Discount__c,2)

EarlyPaymentDiscountAbsOutstanding__c

Outstanding Early Payment Discount abs.

EarlyPaymentDiscountAbs__c

InvoicedAmountTotaOutstanding__c - EarlyPaymentDiscountAbsOutstanding__c

InvoicedAmountGrossInclEpdOutstanding__c

Outstanding Invoiced Amount Gross (incl. EPD)

InvoicedAmountGrossInclEpd__c

Assigning Accounting Periods

...

  1. Functionality of Status “Reviewed”:

    • Reviewed pre-invoices are not updated, similar to invoiced invoices.

    • Draft pre-invoices can be updated or reassigned as needed.

  2. Resetting Status to Draft:

    • If any amounts (B3 → N3) change or new pre-invoice items match a reviewed pre-invoice or pre-invoice item get deleted, the status is reset to Draft and the pre-invoice and pre-invoice items will be updated.

    • Prevents creation of unnecessary additional delta pre-invoices.

  3. Invoice Assignment Rules:

    • Ensures that pre-invoice assignments are managed efficiently without creating duplicate pre-invoices.

...

Media Champaign Conditions

 Error Message

MediaCampaign__c.PaymentInterval__c is not filledset

Missing fields: Payment Interval, Payment Start, ...

MediaCampaign__c.PaymentStart__c is not filledset

MediaCampaign__c.PaymentDueDate__c is not filledset

MediaCampaign__c.Campaign_Start_Date__c is not filledset

MediaCampaign__c.Campaign_End_Date__c is not filledset

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.

...