Table 18091201 EOS IPL Invoice Plan Header

Table 18091201 EOS IPL Invoice Plan Header

LanguageCaption
de-ATZahlplankopf
de-CHZahlplankopf
de-DEZahlplankopf
en-AUInvoice Plan Header
en-CAInvoice Plan Header
en-GBInvoice Plan Header
en-NZInvoice Plan Header
en-USInvoice Plan Header
it-CHTestata piano fatturazione
it-ITTestata piano fatturazione

Fields

No. (5)

Code[20]

LanguageCaption
de-ATNr.
de-CHNr.
de-DENr.
en-AUNo.
en-CANo.
en-GBNo.
en-NZNo.
en-USNo.
it-CHNr.
it-ITNr.

Job No. (7)

Code[20]

TableRelation: Job

LanguageCaption
de-ATProjektnr.
de-CHProjektnr.
de-DEProjektnr.
en-AUJob No.
en-CAJob No.
en-GBJob No.
en-NZJob No.
en-USJob No.
it-CHNr. commessa
it-ITNr. commessa

Invoice Plan Template Code (10)

Code[20]

TableRelation: "EOS IPL Template Header"

LanguageCaption
de-ATZahlplanvorlagencode
de-CHZahlplanvorlagencode
de-DEZahlplanvorlagencode
en-AUInvoice Plan Template Code
en-CAInvoice Plan Template Code
en-GBInvoice Plan Template Code
en-NZInvoice Plan Template Code
en-USInvoice Plan Template Code
it-CHCodice modello piano fatturazione
it-ITCodice modello piano fatturazione

Source Type (19)

Enum "EOS IPL Source Type"

LanguageCaption
de-ATHerkunftsart
de-CHHerkunftsart
de-DEHerkunftsart
en-AUSource Type
en-CASource Type
en-GBSource Type
en-NZSource Type
en-USSource Type
it-CHTipo origine
it-ITTipo origine

Source Document No. (20)

Code[20]

TableRelation: if ("Source Type" = const("Sales Order")) "Sales Header" where("Document Type" = const(Order))

LanguageCaption
de-ATHerkunftsbelegnr.
de-CHHerkunftsbelegnr.
de-DEHerkunftsbelegnr.
en-AUSource Document No.
en-CASource Document No.
en-GBSource Document No.
en-NZSource Document No.
en-USSource Document No.
it-CHNr. documento origine
it-ITNr. documento origine

Source No. (25)

Code[20]

TableRelation: if ("Source Type" = const("Sales Order")) "Customer"

LanguageCaption
de-ATHerkunftsnr.
de-CHHerkunftsnr.
de-DEHerkunftsnr.
en-AUSource No.
en-CASource No.
en-GBSource No.
en-NZSource No.
en-USSource No.
it-CHNr. origine
it-ITNr. origine

Name (35)

Text[100]

LanguageCaption
de-ATName
de-CHName
de-DEName
en-AUName
en-CAName
en-GBName
en-NZName
en-USName
it-CHNome
it-ITNome

Name 2 (40)

Text[100]

LanguageCaption
de-ATName 2
de-CHName 2
de-DEName 2
en-AUName 2
en-CAName 2
en-GBName 2
en-NZName 2
en-USName 2
it-CHNome 2
it-ITNome 2

Address (50)

Text[100]

LanguageCaption
de-ATAdresse
de-CHAdresse
de-DEAdresse
en-AUAddress
en-CAAddress
en-GBAddress
en-NZAddress
en-USAddress
it-CHIndirizzo
it-ITIndirizzo

Address 2 (55)

Text[100]

LanguageCaption
de-ATAdresse 2
de-CHAdresse 2
de-DEAdresse 2
en-AUAddress 2
en-CAAddress 2
en-GBAddress 2
en-NZAddress 2
en-USAddress 2
it-CHIndirizzo 2
it-ITIndirizzo 2

Country/Region Code (60)

Code[10]

TableRelation: "Country/Region"

LanguageCaption
de-ATLänder-/Regionscode
de-CHLänder-/Regionscode
de-DELänder-/Regionscode
en-AUCountry/Region Code
en-CACountry/Region Code
en-GBCountry/Region Code
en-NZCountry/Region Code
en-USCountry/Region Code
it-CHCod. paese
it-ITCod. paese

Post Code (65)

Code[20]

TableRelation: if ("Country/Region Code" = const('')) "Post Code" else if ("Country/Region Code" = filter(<> '')) "Post Code" where("Country/Region Code" = field("Country/Region Code"))

LanguageCaption
de-ATPLZ-Code
de-CHPLZ-Code
de-DEPLZ-Code
en-AUPost Code
en-CAPost Code
en-GBPost Code
en-NZPost Code
en-USPost Code
it-CHCAP
it-ITCAP

City (70)

Text[30]

TableRelation: if ("Country/Region Code" = const('')) "Post Code".City else if ("Country/Region Code" = filter(<> '')) "Post Code".City where("Country/Region Code" = field("Country/Region Code"))

LanguageCaption
de-ATOrt
de-CHOrt
de-DEOrt
en-AUCity
en-CACity
en-GBCity
en-NZCity
en-USCity
it-CHCittà
it-ITCittà

County (72)

Text[30]

LanguageCaption
de-ATBundesregion
de-CHBundesregion
de-DEBundesregion
en-AUCounty
en-CACounty
en-GBCounty
en-NZCounty
en-USCounty
it-CHProvincia
it-ITProvincia

Gen. Bus. Posting Group (75)

Code[20]

TableRelation: "Gen. Business Posting Group"

LanguageCaption
de-ATGeschäftsbuchungsgruppe
de-CHGeschäftsbuchungsgruppe
de-DEGeschäftsbuchungsgruppe
en-AUGen. Bus. Posting Group
en-CAGen. Bus. Posting Group
en-GBGen. Bus. Posting Group
en-NZGen. Bus. Posting Group
en-USGen. Bus. Posting Group
it-CHCat. reg. business
it-ITCat. reg. business

VAT Bus. Posting Group (76)

Code[20]

TableRelation: "VAT Business Posting Group"

LanguageCaption
de-ATMwSt.-Geschäftsbuchungsgruppe
de-CHMwSt.-Geschäftsbuchungsgruppe
de-DEMwSt.-Geschäftsbuchungsgruppe
en-AUVAT Bus. Posting Group
en-CAVAT Bus. Posting Group
en-GBVAT Bus. Posting Group
en-NZVAT Bus. Posting Group
en-USVAT Bus. Posting Group
it-CHCat. reg. business IVA
it-ITCat. reg. business IVA

Currency Code (80)

Code[10]

TableRelation: Currency

LanguageCaption
de-ATWährungscode
de-CHWährungscode
de-DEWährungscode
en-AUCurrency Code
en-CACurrency Code
en-GBCurrency Code
en-NZCurrency Code
en-USCurrency Code
it-CHCod. valuta
it-ITCod. valuta

Total Amount (90)

Decimal

LanguageCaption
de-ATGesamtbetrag
de-CHGesamtbetrag
de-DEGesamtbetrag
en-AUTotal Amount
en-CATotal Amount
en-GBTotal Amount
en-NZTotal Amount
en-USTotal Amount
it-CHImporto totale
it-ITImporto totale

Total Amount Including VAT (95)

Decimal

LanguageCaption
de-ATSumme Positionen (brutto)
de-CHSumme Positionen (brutto)
de-DESumme Positionen (brutto)
en-AUTotal Amount Including VAT
en-CATotal Amount Including VAT
en-GBTotal Amount Including VAT
en-NZTotal Amount Including VAT
en-USTotal Amount Including VAT
it-CHImporto totale (IVA incl.)
it-ITImporto totale (IVA incl.)

Order Amount (100)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS IPL Position Allocation".Amount where("Invoice Plan No." = field("No."), Assigned = const(true)))

LanguageCaption
de-AT%
de-CH%
de-DE%
en-AUOrder Amount
en-CAOrder Amount
en-GBOrder Amount
en-NZOrder Amount
en-USOrder Amount
it-CHImporto ordine
it-ITImporto ordine

Posted Amount (110)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS IPL Invoice Plan Line"."Net Amount" where("Invoice Plan No." = field("No."), "Posted Invoice" = const(true), "Invoice Type" = const("Anticipated Payment Invoice")))

LanguageCaption
de-ATAbgerechneter Betrag
de-CHAbgerechneter Betrag
de-DEAbgerechneter Betrag
en-AUPosted Anticipated Amount
en-CAPosted Anticipated Amount
en-GBPosted Anticipated Amount
en-NZPosted Anticipated Amount
en-USPosted Anticipated Amount
it-CHImporto anticipo registrato
it-ITImporto anticipo registrato

Open Amount (120)

Decimal

LanguageCaption
de-ATOffener Betrag
de-CHOffener Betrag
de-DEOffener Betrag
en-AUTotal Closing Amount
en-CATotal Closing Amount
en-GBTotal Closing Amount
en-NZTotal Closing Amount
en-USTotal Closing Amount
it-CHImporto a chiusura da fatturare
it-ITImporto a chiusura da fatturare

Invoice Plan Amount (130)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS IPL Invoice Plan Line"."Net Amount" where("Invoice Plan No." = field("No."), "Invoice Type" = const("Anticipated Payment Invoice")))

LanguageCaption
de-ATAufgeteilter Betrag
de-CHAufgeteilter Betrag
de-DEAufgeteilter Betrag
en-AUInvoice Plan Amount
en-CAInvoice Plan Amount
en-GBInvoice Plan Amount
en-NZInvoice Plan Amount
en-USInvoice Plan Amount
it-CHImporto totale anticipo
it-ITImporto totale anticipo

Invoice Plan Remaining Amount (140)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Detailed Cust. Ledg. Entry".Amount where("EOS IPL Invoice Plan No." = field("No."), "Document Type" = filter(Invoice | "Credit Memo"), "Entry Type" = filter("Initial Entry")))

LanguageCaption
de-ATGebuchter Gesamtbetrag
de-CHGebuchter Gesamtbetrag
de-DEGebuchter Gesamtbetrag
en-AUTotal Posted Amount
en-CATotal Posted Amount
en-GBTotal Posted Amount
en-NZTotal Posted Amount
en-USTotal Posted Amount
it-CHImporto totale fatturato
it-ITImporto totale fatturato

Completely Invoiced (200)

Boolean

LanguageCaption

Shortcut Dimension 1 Code (300)

Code[20]

TableRelation: "Dimension Value".Code where("Global Dimension No." = const(1))

LanguageCaption
de-ATShortcutdimensionscode 1
de-CHShortcutdimensionscode 1
de-DEShortcutdimensionscode 1
en-AUShortcut Dimension 1 Code
en-CAShortcut Dimension 1 Code
en-GBShortcut Dimension 1 Code
en-NZShortcut Dimension 1 Code
en-USShortcut Dimension 1 Code
it-CHCod. colleg. dimen. 1
it-ITCod. colleg. dimen. 1

Shortcut Dimension 2 Code (301)

Code[20]

TableRelation: "Dimension Value".Code where("Global Dimension No." = const(2))

LanguageCaption
de-ATShortcutdimensionscode 2
de-CHShortcutdimensionscode 2
de-DEShortcutdimensionscode 2
en-AUShortcut Dimension 2 Code
en-CAShortcut Dimension 2 Code
en-GBShortcut Dimension 2 Code
en-NZShortcut Dimension 2 Code
en-USShortcut Dimension 2 Code
it-CHCod. colleg. dimen. 2
it-ITCod. colleg. dimen. 2

Description (302)

Text[100]

LanguageCaption
de-ATBeschreibung
de-CHBeschreibung
de-DEBeschreibung
en-AUDescription
en-CADescription
en-GBDescription
en-NZDescription
en-USDescription
it-CHDescrizione
it-ITDescrizione

Description 2 (303)

Text[100]

LanguageCaption
de-ATBeschreibung 2
de-CHBeschreibung 2
de-DEBeschreibung 2
en-AUDescription 2
en-CADescription 2
en-GBDescription 2
en-NZDescription 2
en-USDescription 2
it-CHDescrizione 2
it-ITDescrizione 2

Closed (305)

Boolean

LanguageCaption
de-ATGeschlossen
de-CHGeschlossen
de-DEGeschlossen
en-AUClosed
en-CAClosed
en-GBClosed
en-NZClosed
en-USClosed
it-CHChiuso
it-ITChiuso

Closing Invoice corrected (307)

Boolean

LanguageCaption
de-ATSchlussrechnung storniert
de-CHSchlussrechnung storniert
de-DESchlussrechnung storniert
en-AUClosing Invoice corrected
en-CAClosing Invoice corrected
en-GBClosing Invoice corrected
en-NZClosing Invoice corrected
en-USClosing Invoice corrected
it-CHFattura Chiusura rettificata
it-ITFattura Chiusura rettificata

Gen. Prod. Posting Group (310)

Code[20]

TableRelation: "Gen. Product Posting Group"

LanguageCaption
de-ATProduktbuchungsgruppe
de-CHProduktbuchungsgruppe
de-DEProduktbuchungsgruppe
en-AUGen. Prod. Posting Group
en-CAGen. Prod. Posting Group
en-GBGen. Prod. Posting Group
en-NZGen. Prod. Posting Group
en-USGen. Prod. Posting Group
it-CHCat. reg. articolo/servizio
it-ITCat. reg. articolo/servizio

VAT Prod. Posting Group (311)

Code[20]

TableRelation: "VAT Product Posting Group"

LanguageCaption
de-ATMwSt.-Produktbuchungsgruppe
de-CHMwSt.-Produktbuchungsgruppe
de-DEMwSt.-Produktbuchungsgruppe
en-AUVAT Prod. Posting Group
en-CAVAT Prod. Posting Group
en-GBVAT Prod. Posting Group
en-NZVAT Prod. Posting Group
en-USVAT Prod. Posting Group
it-CHCat. reg. art./serv. IVA
it-ITCat. reg. art./serv. IVA

Account AP Invoice (320)

Code[20]

TableRelation: "G/L Account"

LanguageCaption
de-ATKonto Abschlagsrechnung
de-CHKonto Abschlagsrechnung
de-DEKonto Abschlagsrechnung
en-AUAnticipated Inv. Plan. Bal. Acc.
en-CAAnticipated Inv. Plan. Bal. Acc.
en-GBAnticipated Inv. Plan. Bal. Acc.
en-NZAnticipated Inv. Plan. Bal. Acc.
en-USAnticipated Inv. Plan. Bal. Acc.
it-CHFattura Conto AP
it-ITFattura Conto AP

Dimension Set ID (480)

Integer

TableRelation: "Dimension Set Entry"

LanguageCaption
de-ATDimensionssatz-ID
de-CHDimensionssatz-ID
de-DEDimensionssatz-ID
en-AUDimension Set ID
en-CADimension Set ID
en-GBDimension Set ID
en-NZDimension Set ID
en-USDimension Set ID
it-CHID set di dimensioni
it-ITID set di dimensioni

No. Series (500)

Code[20]

TableRelation: "No. Series"

LanguageCaption
de-ATNummernserie
de-CHNummernserie
de-DENummernserie
en-AUNo. Series
en-CANo. Series
en-GBNo. Series
en-NZNo. Series
en-USNo. Series
it-CHNr. serie
it-ITNr. serie

Date Filter (600)

Date

FieldClass: FlowFilter

LanguageCaption
de-ATDatumsfilter
de-CHDatumsfilter
de-DEDatumsfilter
en-AUDate Filter
en-CADate Filter
en-GBDate Filter
en-NZDate Filter
en-USDate Filter
it-CHFiltro data
it-ITFiltro data

Date of Closing Invoice Cust. (700)

Date

FieldClass: FlowField

CalcFormula: Min("Cust. Ledger Entry"."Posting Date" where("Document Type" = const(Invoice), "EOS IPL Document Type" = const("Closing Invoice"), "EOS IPL Invoice Plan No." = field("No.")))

LanguageCaption
de-ATSchlußrechnungsdatum Debitor
de-CHSchlußrechnungsdatum Debitor
de-DESchlußrechnungsdatum Debitor
en-AUClosing Invoice Data
en-CAClosing Invoice Data
en-GBClosing Invoice Data
en-NZClosing Invoice Data
en-USClosing Invoice Data
it-CHData di Cliente Fattura Chiusura
it-ITData di Cliente Fattura Chiusura

Cust. L. Entry No. Clos. Inv. (702)

Integer

FieldClass: FlowField

CalcFormula: Min("Cust. Ledger Entry"."Entry No." where("Document Type" = const(Invoice), "EOS IPL Document Type" = const("Closing Invoice"), "EOS IPL Invoice Plan No." = field("No."), "Posting Date" = field("Date Filter")))

LanguageCaption
de-ATDebitorenposten-Nr. Abschlussrechnung
de-CHDebitorenposten-Nr. Abschlussrechnung
de-DEDebitorenposten-Nr. Abschlussrechnung
en-AUClosing Invoice Ledger Entry No.
en-CAClosing Invoice Ledger Entry No.
en-GBClosing Invoice Ledger Entry No.
en-NZClosing Invoice Ledger Entry No.
en-USClosing Invoice Ledger Entry No.
it-CHNr. movimento contabile cliente Fattura di chiusura
it-ITNr. movimento contabile cliente Fattura di chiusura

Cust. Remaining Amt. (LCY) (707)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Detailed Cust. Ledg. Entry"."Amount (LCY)" where("EOS IPL Invoice Plan No." = field("No."), "Posting Date" = field("Date Filter")))

LanguageCaption
de-ATDeb. Restbetrag (MW)
de-CHDeb. Restbetrag (MW)
de-DEDeb. Restbetrag (MW)
en-AURemaining Amt. (LCY)
en-CARemaining Amt. (LCY)
en-GBRemaining Amt. (LCY)
en-NZRemaining Amt. (LCY)
en-USRemaining Amt. (LCY)
it-CHImporto Residuo Cliente (VL)
it-ITImporto Residuo Cliente (VL)

Methods

AssistEdit

procedure AssistEdit(): Boolean

Parameters / Return Value

  • Returns Boolean

TotalPositionNet

procedure TotalPositionNet(): Decimal

Parameters / Return Value

  • Returns Decimal

TotalPositionGross

procedure TotalPositionGross(): Decimal

Parameters / Return Value

  • Returns Decimal

CheckInvoicePlan

procedure CheckInvoicePlan()

CreateInvoice

procedure CreateInvoice()

CreateClosingInvoice

procedure CreateClosingInvoice()

CreateCrMemos

procedure CreateCrMemos()

CheckSalesOrder

procedure CheckSalesOrder()

UpdateDocumentHeader

procedure UpdateDocumentHeader()

CreateDim

procedure CreateDim(Type1: Integer; No1: Code[20]; Type2: Integer; No2: Code[20]; Type3: Integer; No3: Code[20]; Type4: Integer; No4: Code[20]; Type5: Integer; No5: Code[20])

Parameters / Return Value

  • Type1 Integer

  • No1 Code[20]

  • Type2 Integer

  • No2 Code[20]

  • Type3 Integer

  • No3 Code[20]

  • Type4 Integer

  • No4 Code[20]

  • Type5 Integer

  • No5 Code[20]

ValidateShortcutDimCode

procedure ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])

Parameters / Return Value

  • FieldNumber Integer

  • ShortcutDimCode Code[20]

ShowDocDim

procedure ShowDocDim()

ShowSourceDoc

procedure ShowSourceDoc()

ShowInvoices

procedure ShowInvoices()

ShowCreditMemos

procedure ShowCreditMemos()

ShowPostedInvoices

procedure ShowPostedInvoices()

ShowPostedCreditMemos

procedure ShowPostedCreditMemos()

SetReferToPosition

procedure SetReferToPosition()

SetDisableSourceHeaderUpdate

procedure SetDisableSourceHeaderUpdate(Value: Boolean)

Parameters / Return Value

  • Value Boolean

CalculateClosingAmount

procedure CalculateClosingAmount(): Decimal

Parameters / Return Value

  • Returns Decimal

CalculateOpenAmount

procedure CalculateOpenAmount(): Decimal

Parameters / Return Value

  • Returns Decimal

Events

OnAfterSetFiltersCollectedAmount

local procedure OnAfterSetFiltersCollectedAmount(var DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry")

Raised after setting filters on Detailed Customer Ledger Entry table to calculate Collected Amount field, suscribe to this event to add “Dishonored” document type to the document type filters on italian localizations

Parameters / Return Value

  • DetailedCustLedgEntry Record "Detailed Cust. Ledg. Entry"

    Detailed Customer Ledger Entry table that is begin filtered

OnAfterSetFiltersCollectedAmountLCY

local procedure OnAfterSetFiltersCollectedAmountLCY(var DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry")

Raised after setting filters on Detailed Customer Ledger Entry table to calculate Collected Amount (LCY) field, suscribe to this event to add “Dishonored” document type to the document type filters on italian localizations

Parameters / Return Value

  • DetailedCustLedgEntry Record "Detailed Cust. Ledg. Entry"

    Detailed Customer Ledger Entry table that is begin filtered

OnBeforeInsertIPLLinesFromIPLTemplate

local procedure OnBeforeInsertIPLLinesFromIPLTemplate(IPLHeader: Record "EOS IPL Invoice Plan Header"; IPLTemplateLine: Record "EOS IPL Template Line"; var IPLInvoicePlanLine: Record "EOS IPL Invoice Plan Line"; var isHandled: Boolean)

Raised before inserting IPL Lines when choosing an IPL Template in the “Invoice Template Template Code” field validation in IPL Header

Parameters / Return Value

  • IPLHeader Record "EOS IPL Invoice Plan Header"

    IPL Header of the IPL Lines about to be inserted

  • IPLTemplateLine Record "EOS IPL Template Line"

    IPL Template Lines being processed to create the new IPL Lines

  • IPLInvoicePlanLine Record "EOS IPL Invoice Plan Line"

    IPL Line being created

  • isHandled Boolean

    If set to true skips IPL Line insert

OnAfterInsertIPLLinesFromIPLTemplate

local procedure OnAfterInsertIPLLinesFromIPLTemplate(IPLHeader: Record "EOS IPL Invoice Plan Header"; IPLTemplateLine: Record "EOS IPL Template Line"; var IPLInvoicePlanLine: Record "EOS IPL Invoice Plan Line")

Raised after inserting IPL Lines when choosing an IPL Template in the “Invoice Template Template Code” field validation in IPL Header

Parameters / Return Value

  • IPLHeader Record "EOS IPL Invoice Plan Header"

    IPL Header of the IPL Lines just inserted

  • IPLTemplateLine Record "EOS IPL Template Line"

    IPL Template Lines being processed to create the new IPL Lines

  • IPLInvoicePlanLine Record "EOS IPL Invoice Plan Line"

    IPL Line just created

OnAfterGetInvoicePlanTemplate

local procedure OnAfterGetInvoicePlanTemplate(var IPLHeader: Record "EOS IPL Invoice Plan Header"; IPLTemplateHeader: Record "EOS IPL Template Header"; IPLTemplateLine: Record "EOS IPL Template Line")

Raised after the procedure that inserts the IPL Template Header and IPL Template Line fields from the template to the Invoicing Plan, right before it ends

Parameters / Return Value

  • IPLHeader Record "EOS IPL Invoice Plan Header"

    IPL Header being processed

  • IPLTemplateHeader Record "EOS IPL Template Header"

    IPL Template Header being used to process the Invoice Plan Header

  • IPLTemplateLine Record "EOS IPL Template Line"

    IPL Template Lines being used to process the Invoice Plan Lines


EOS Labs -