Table 461 "Prepayment Inv. Line Buffer"

Base Application · Microsoft.Finance.ReceivablesPayables · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Prepayment Inv. Line Buffer
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	G/L Account No.	Code[20]	—	TableRelation Table 15 “G/L Account” (G/L Account); DataClassification SystemMetadata
2	Line No.	Integer	—	DataClassification SystemMetadata
3	Amount Δ BC28	Decimal	—	DataClassification SystemMetadata
4	Description	Text[100]	—	DataClassification SystemMetadata
5	Gen. Bus. Posting Group	Code[20]	—	TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group); DataClassification SystemMetadata
6	Gen. Prod. Posting Group	Code[20]	—	TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group); DataClassification SystemMetadata
7	VAT Bus. Posting Group	Code[20]	—	TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group); DataClassification SystemMetadata
8	VAT Prod. Posting Group	Code[20]	—	TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group); DataClassification SystemMetadata
9	VAT Amount Δ BC28	Decimal	—	DataClassification SystemMetadata
10	VAT Calculation Type	Enum “Tax Calculation Type”	—	enum Enum 254 “Tax Calculation Type”; DataClassification SystemMetadata
11	VAT Base Amount Δ BC28	Decimal	—	DataClassification SystemMetadata
12	Amount (ACY) Δ BC27	Decimal	—	DataClassification SystemMetadata
13	VAT Amount (ACY) Δ BC27	Decimal	—	DataClassification SystemMetadata
14	VAT Base Amount (ACY) Δ BC27	Decimal	—	DataClassification SystemMetadata
15	VAT Difference Δ BC28	Decimal	—	DataClassification SystemMetadata
16	VAT % Δ BC28	Decimal	—	DataClassification SystemMetadata
17	VAT Identifier	Code[20]	—	not editable; DataClassification SystemMetadata
19	Global Dimension 1 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))); DataClassification SystemMetadata
20	Global Dimension 2 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))); DataClassification SystemMetadata
21	Job No. Δ BC24	Code[20]	Project No. caption	TableRelation Table 167 “Job”; DataClassification SystemMetadata
22	Amount Incl. VAT Δ BC28	Decimal	—	DataClassification SystemMetadata
24	Tax Area Code	Code[20]	—	TableRelation Table 318 “Tax Area” (Tax Area); DataClassification SystemMetadata
25	Tax Liable	Boolean	—	DataClassification SystemMetadata
26	Tax Group Code	Code[20]	—	TableRelation Table 321 “Tax Group” (Tax Group); DataClassification SystemMetadata
27	Invoice Rounding	Boolean	—	DataClassification SystemMetadata
28	Adjustment	Boolean	—	DataClassification SystemMetadata
29	VAT Base Before Pmt. Disc. Δ BC28	Decimal	—	DataClassification SystemMetadata
30	Orig. Pmt. Disc. Possible Δ BC28	Decimal	Original Pmt. Disc. Possible caption	DataClassification SystemMetadata
31	Location Code	Code[10]	—	DataClassification SystemMetadata
480	Dimension Set ID	Integer	—	TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable; DataClassification SystemMetadata
1001	Job Task No. Δ BC24	Code[20]	Project Task No. caption	TableRelation Table 1001 “Job Task” (Job Task); DataClassification SystemMetadata

Keys

Key1: G/L Account No., Job No., Tax Area Code, Tax Liable, Tax Group Code, Invoice Rounding, Adjustment, Line No., Dimension Set ID (clustered)
Key2: Adjustment

Events published

OnAfterCopyFromPurchLine(var PrepaymentInvLineBuffer: Record "Prepayment Inv. Line Buffer"; PurchaseLine: Record "Purchase Line") (integration): Integration event raised after copying data from a purchase line. Allows customization of purchase line data transfer to prepayment buffer.
OnAfterCopyFromSalesLine(var PrepaymentInvLineBuffer: Record "Prepayment Inv. Line Buffer"; SalesLine: Record "Sales Line") (integration): Integration event raised after copying data from a sales line. Allows customization of sales line data transfer to prepayment buffer.
OnAfterIncrAmounts(var PrepaymentInvLineBuffer: Record "Prepayment Inv. Line Buffer"; PrepmtInvLineBuf: Record "Prepayment Inv. Line Buffer") (integration): Integration event raised after incrementing amounts in the buffer. Allows custom amount processing during buffer consolidation.
OnAfterFillFromGLAcc(var PrepaymentInvLineBuffer: Record "Prepayment Inv. Line Buffer"; GLAccount: Record "G/L Account"; CompressPayment: Boolean) (integration): Integration event raised after filling buffer from G/L account. Allows customization of G/L account data transfer to prepayment buffer.
OnAfterFillAdjInvLineBuffer(PrepaymentInvLineBuffer: Record "Prepayment Inv. Line Buffer"; var PrepaymentInvLineBufferRec: Record "Prepayment Inv. Line Buffer") (integration): Integration event raised after filling adjustment invoice line buffer. Allows customization of adjustment line processing.
OnAfterReverseAmounts() (integration): Integration event raised after reversing amounts in the buffer. Allows custom processing after amount reversal operations.
OnBeforeCompressBuffer(var PrepaymentInvLineBuffer: Record "Prepayment Inv. Line Buffer"; var IsHandled: Boolean) (integration): Integration event raised before compressing the buffer. Allows custom buffer compression logic or skipping standard compression.
OnBeforeFillFromGLAcc(var PrepaymentInvLineBuffer: Record "Prepayment Inv. Line Buffer"; var IsHandled: Boolean) (integration): Integration event raised before filling buffer from G/L account. Allows custom G/L account processing or skipping standard fill logic.
OnAfterUpdateVATAmounts(var PrepaymentInvLineBuffer: Record "Prepayment Inv. Line Buffer"; Currency: Record Currency) (integration): Integration event raised after updating VAT amounts. Allows custom VAT amount processing after standard calculations.

Procedures

IncrAmounts(PrepmtInvLineBuf: Record "Prepayment Inv. Line Buffer"): Increments amounts in the current record with amounts from another prepayment invoice line buffer. Adds all financial amounts including VAT, base amounts, and discount amounts.
ReverseAmounts(): Reverses all amounts in the current record by changing signs. Used for creating credit memo entries or reversing prepayment entries.
SetAmounts(AmountLCY: Decimal; AmountInclVAT: Decimal; VATBaseAmount: Decimal; AmountACY: Decimal; VATBaseAmountACY: Decimal; VATDifference: Decimal): Sets the financial amounts for the prepayment invoice line buffer. Updates amount, VAT amounts, and base amounts in both LCY and ACY.
InsertInvLineBuffer(PrepmtInvLineBuf2: Record "Prepayment Inv. Line Buffer"): Inserts or updates a prepayment invoice line buffer record. If record exists, increments amounts; otherwise inserts new record.
CopyWithLineNo(PrepmtInvLineBuf: Record "Prepayment Inv. Line Buffer"; LineNo: Integer): Copies a prepayment invoice line buffer record with a new line number. Creates a new record with the specified line number.
CopyFromPurchLine(PurchLine: Record "Purchase Line"): Copies posting group information from a purchase line to the prepayment buffer. Transfers VAT and posting group settings for prepayment processing.
CopyFromSalesLine(SalesLine: Record "Sales Line"): Copies posting group information from a sales line to the prepayment buffer. Transfers VAT and posting group settings for prepayment processing.
SetFilterOnPKey(PrepmtInvLineBuf: Record "Prepayment Inv. Line Buffer"): Sets filters on the primary key fields of the prepayment invoice line buffer. Used for finding existing records with matching key values.
FillAdjInvLineBuffer(PrepmtInvLineBuf: Record "Prepayment Inv. Line Buffer"; GLAccountNo: Code[20]; CorrAmount: Decimal; CorrAmountACY: Decimal): Fills the buffer with adjustment invoice line data for amount corrections. Creates adjustment entries for prepayment amount differences.
FillFromGLAcc(CompressPrepayment: Boolean): Fills the buffer with G/L account information for prepayment processing. Copies posting group information from the specified G/L account.
AdjustVATBase(VATAdjustment: array[2] of Decimal): Adjusts VAT base amount and VAT amount based on provided adjustment values. Recalculates amount including VAT after adjustments.
AmountsToArray(var VATAmount: array[2] of Decimal): Converts buffer amounts to an array format for processing. Returns base amount and VAT amount in array elements.
CompressBuffer(): Compresses multiple buffer lines with same key into consolidated entries. Combines amounts for lines with identical posting group and dimension combinations.
UpdateVATAmounts(): Updates VAT amounts based on VAT posting setup and calculated percentages. Recalculates VAT amount in both local and additional reporting currency.
GetVATPct(): Decimal + BC26 (internal)

Plus 1 local procedures.

Relations

Job Task No.: TableRelation Table 1001 “Job Task”
G/L Account No.: TableRelation Table 15 “G/L Account”
Job No.: TableRelation Table 167 “Job”
Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
Tax Area Code: TableRelation Table 318 “Tax Area”
Tax Group Code: TableRelation Table 321 “Tax Group”
VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”

Countries that replace it

AU, ES, IT, NZ

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Prepayment Inv. Line Buffer"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.