Table 18091201 EOS IPL Invoice Plan Header

Table 18091201 EOS IPL Invoice Plan Header

Language	Caption
de-DE	Rechnungsplankopf
en-US	Invoice Plan Header
it-IT	Testata piano fatturazione

Fields

No. (`5`)

Code[20]

Language	Caption
de-DE	Nr.
en-US	No.
it-IT	Nr.

Job No. (`7`)

Code[20]

TableRelation: Job

Language	Caption
de-DE	Projektnr.
en-US	Job No.
it-IT	Nr. commessa

Invoice Plan Template Code (`10`)

Code[20]

TableRelation: "EOS IPL Template Header"

Language	Caption
de-DE	Rechnungsplanvorlagencode
en-US	Invoice Plan Template Code
it-IT	Codice modello piano fatturazione

Source Type (`19`)

Enum "EOS IPL Source Type"

Language	Caption
de-DE	Herkunftsart
en-US	Source Type
it-IT	Tipo origine

Source Document No. (`20`)

Code[20]

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

Language	Caption
de-DE	Herkunftsbelegnr.
en-US	Source Document No.
it-IT	Nr. documento origine

Source No. (`25`)

Code[20]

TableRelation: if ("Source Type" = filter("Sales Order" | "Service Order")) "Customer" else if ("Source Type" = filter("Purchase Order")) "Vendor"

Language	Caption
de-DE	Herkunftsnr.
en-US	Source No.
it-IT	Nr. origine

Name (`35`)

Text[100]

Language	Caption
de-DE	Name
en-US	Name
it-IT	Nome

Name 2 (`40`)

Text[100]

Language	Caption
de-DE	Name 2
en-US	Name 2
it-IT	Nome 2

Address (`50`)

Text[100]

Language	Caption
de-DE	Adresse
en-US	Address
it-IT	Indirizzo

Address 2 (`55`)

Text[100]

Language	Caption
de-DE	Adresse 2
en-US	Address 2
it-IT	Indirizzo 2

Country/Region Code (`60`)

Code[10]

TableRelation: "Country/Region"

Language	Caption
de-DE	Länder-/Regionscode
en-US	Country/Region Code
it-IT	Cod. 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"))

Language	Caption
de-DE	PLZ-Code
en-US	Post Code
it-IT	CAP

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"))

Language	Caption
de-DE	Ort
en-US	City
it-IT	Città

County (`72`)

Text[30]

Language	Caption
de-DE	Bundesregion
en-US	County
it-IT	Provincia

Gen. Bus. Posting Group (`75`)

Code[20]

TableRelation: "Gen. Business Posting Group"

Language	Caption
de-DE	Geschäftsbuchungsgruppe
en-US	Gen. Bus. Posting Group
it-IT	Cat. reg. business

VAT Bus. Posting Group (`76`)

Code[20]

TableRelation: "VAT Business Posting Group"

Language	Caption
de-DE	MwSt.-Geschäftsbuchungsgruppe
en-US	VAT Bus. Posting Group
it-IT	Cat. reg. business IVA

Currency Code (`80`)

Code[10]

TableRelation: Currency

Language	Caption
de-DE	Währungscode
en-US	Currency Code
it-IT	Cod. valuta

Total Amount (`90`)

Decimal

Language	Caption
de-DE	Gesamtbetrag
en-US	Total Amount
it-IT	Importo totale

Total Amount Including VAT (`95`)

Decimal

Language	Caption
de-DE	Summe Positionen (brutto)
en-US	Total Amount Including VAT
it-IT	Importo 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)))

Language	Caption
de-DE	%
en-US	Order Amount
it-IT	Importo 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")))

Language	Caption
de-DE	Abgerechneter Betrag
en-US	Posted Anticipated Amount
it-IT	Importo anticipo registrato

Open Amount (`120`)

Decimal

Language	Caption
de-DE	Offener Betrag
en-US	Total Closing Amount
it-IT	Importo 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")))

Language	Caption
de-DE	Aufgeteilter Betrag
en-US	Invoice Plan Amount
it-IT	Importo 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")))

Language	Caption
de-DE	Gebuchter Gesamtbetrag
en-US	Total Posted Amount
it-IT	Importo totale fatturato

Inv. Plan Purch. Remaining Amt (`150`)

Decimal

FieldClass: FlowField

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

Language	Caption
de-DE	Gesamtbetrag Gebuchter Betrag
en-US	Total Posted Amount
it-IT	Importo totale fatturato

Completely Invoiced (`200`)

Boolean

Obsolete

Removed: Field is deprecated and will be removed in a future release. (20.0)

Language	Caption

Shortcut Dimension 1 Code (`300`)

Code[20]

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

Language	Caption
de-DE	Shortcutdimensionscode 1
en-US	Shortcut Dimension 1 Code
it-IT	Cod. colleg. dimen. 1

Shortcut Dimension 2 Code (`301`)

Code[20]

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

Language	Caption
de-DE	Shortcutdimensionscode 2
en-US	Shortcut Dimension 2 Code
it-IT	Cod. colleg. dimen. 2

Description (`302`)

Text[100]

Language	Caption
de-DE	Beschreibung
en-US	Description
it-IT	Descrizione

Description 2 (`303`)

Text[100]

Language	Caption
de-DE	Beschreibung 2
en-US	Description 2
it-IT	Descrizione 2

Closed (`305`)

Boolean

Language	Caption
de-DE	Geschlossen
en-US	Closed
it-IT	Chiuso

Closing Invoice corrected (`307`)

Boolean

Obsolete

Removed: Field is deprecated and will be removed in a future release. (20.0)

Language	Caption

Gen. Prod. Posting Group (`310`)

Code[20]

TableRelation: "Gen. Product Posting Group"

Language	Caption
de-DE	Produktbuchungsgruppe
en-US	Gen. Prod. Posting Group
it-IT	Cat. reg. articolo/servizio

VAT Prod. Posting Group (`311`)

Code[20]

TableRelation: "VAT Product Posting Group"

Language	Caption
de-DE	MwSt.-Produktbuchungsgruppe
en-US	VAT Prod. Posting Group
it-IT	Cat. reg. art./serv. IVA

Account AP Invoice (`320`)

Code[20]

TableRelation: "G/L Account"

Language	Caption
de-DE	Konto Abschlagsrechnung
en-US	Anticipated Inv. Plan. Bal. Acc.
it-IT	Fattura Conto AP

Dimension Set ID (`480`)

Integer

TableRelation: "Dimension Set Entry"

Language	Caption
de-DE	Dimensionssatz-ID
en-US	Dimension Set ID
it-IT	ID set di dimensioni

No. Series (`500`)

Code[20]

TableRelation: "No. Series"

Language	Caption
de-DE	Nummernserie
en-US	No. Series
it-IT	Nr. serie

Date Filter (`600`)

Date

FieldClass: FlowFilter

Language	Caption
de-DE	Datumsfilter
en-US	Date Filter
it-IT	Filtro 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.")))

Language	Caption
de-DE	Schlußrechnungsdatum Debitor
en-US	Closing Invoice Data
it-IT	Data 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")))

Language	Caption
de-DE	Debitorenposten-Nr. Abschlussrechnung
en-US	Closing Invoice Ledger Entry No.
it-IT	Nr. 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")))

Language	Caption
de-DE	Deb. Restbetrag (MW)
en-US	Remaining Amt. (LCY)
it-IT	Importo 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()

ShowServiceInvoices

procedure ShowServiceInvoices()

ShowCreditMemos

procedure ShowCreditMemos()

ShowServiceCreditMemos

procedure ShowServiceCreditMemos()

ShowPostedInvoices

procedure ShowPostedInvoices()

ShowPostedCreditMemos

procedure ShowPostedCreditMemos()

ShowPostedServiceCreditMemos

procedure ShowPostedServiceCreditMemos()

ShowPostedPurchaseCreditMemos

procedure ShowPostedPurchaseCreditMemos()

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

OnAfterSetFiltersPurchCollectedAmount

local procedure OnAfterSetFiltersPurchCollectedAmount(var VendorCustLedgEntry: Record "Detailed Vendor Ledg. Entry")

Raised after setting filters on Detailed Vendor 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

VendorCustLedgEntry Record "Detailed Vendor Ledg. Entry"
Detailed Vendor 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

OnAfterSetFiltersPurchCollectedAmountLCY

local procedure OnAfterSetFiltersPurchCollectedAmountLCY(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry")

Raised after setting filters on Detailed Vendor 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

DetailedVendorLedgEntry Record "Detailed Vendor Ledg. Entry"
Detailed Vendor 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

Feedback

Was this page helpful?

Glad to hear it! Please tell us how we can improve.

Sorry to hear that. Please tell us how we can improve.

EOS Labs - 27.02.2026

Table 18091201 EOS IPL Invoice Plan Header

Fields

No. (5)

Job No. (7)

Invoice Plan Template Code (10)

Source Type (19)

Source Document No. (20)

Source No. (25)

Name (35)

Name 2 (40)

Address (50)

Address 2 (55)

Country/Region Code (60)

Post Code (65)

City (70)

County (72)

Gen. Bus. Posting Group (75)

VAT Bus. Posting Group (76)

Currency Code (80)

Total Amount (90)

Total Amount Including VAT (95)

Order Amount (100)

Posted Amount (110)

Open Amount (120)

Invoice Plan Amount (130)

Invoice Plan Remaining Amount (140)

Inv. Plan Purch. Remaining Amt (150)

Completely Invoiced (200)

Obsolete

Shortcut Dimension 1 Code (300)

Shortcut Dimension 2 Code (301)

Description (302)

Description 2 (303)

Closed (305)

Closing Invoice corrected (307)

Obsolete

Gen. Prod. Posting Group (310)

VAT Prod. Posting Group (311)

Account AP Invoice (320)

Dimension Set ID (480)

No. Series (500)

Date Filter (600)

Date of Closing Invoice Cust. (700)

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

Cust. Remaining Amt. (LCY) (707)

Methods

AssistEdit

Parameters / Return Value

TotalPositionNet

Parameters / Return Value

TotalPositionGross

Parameters / Return Value

CheckInvoicePlan

CreateInvoice

CreateClosingInvoice

CreateCrMemos

CheckSalesOrder

UpdateDocumentHeader

CreateDim

Parameters / Return Value

ValidateShortcutDimCode

Parameters / Return Value

ShowDocDim

ShowSourceDoc

ShowInvoices

ShowServiceInvoices

ShowCreditMemos

ShowServiceCreditMemos

ShowPostedInvoices

ShowPostedCreditMemos

ShowPostedServiceCreditMemos

ShowPostedPurchaseCreditMemos

SetReferToPosition

SetDisableSourceHeaderUpdate

Parameters / Return Value

CalculateClosingAmount

Parameters / Return Value

CalculateOpenAmount

Parameters / Return Value

Events

No. (`5`)

Job No. (`7`)

Invoice Plan Template Code (`10`)

Source Type (`19`)

Source Document No. (`20`)

Source No. (`25`)

Name (`35`)

Name 2 (`40`)

Address (`50`)

Address 2 (`55`)

Country/Region Code (`60`)

Post Code (`65`)

City (`70`)

County (`72`)

Gen. Bus. Posting Group (`75`)

VAT Bus. Posting Group (`76`)

Currency Code (`80`)

Total Amount (`90`)

Total Amount Including VAT (`95`)

Order Amount (`100`)

Posted Amount (`110`)

Open Amount (`120`)

Invoice Plan Amount (`130`)

Invoice Plan Remaining Amount (`140`)

Inv. Plan Purch. Remaining Amt (`150`)

Completely Invoiced (`200`)

Shortcut Dimension 1 Code (`300`)

Shortcut Dimension 2 Code (`301`)

Description (`302`)

Description 2 (`303`)

Closed (`305`)

Closing Invoice corrected (`307`)

Gen. Prod. Posting Group (`310`)

VAT Prod. Posting Group (`311`)

Account AP Invoice (`320`)

Dimension Set ID (`480`)

No. Series (`500`)

Date Filter (`600`)

Date of Closing Invoice Cust. (`700`)

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

Cust. Remaining Amt. (LCY) (`707`)