Report "VAT Statement"

ID 12
Namespace: Microsoft.Finance.VAT.Reporting

The VAT Statement report provides a structured summary of VAT amounts based on your custom VAT Statement setup, including input and output VAT and totals. Use it for preparing official VAT filings by consolidating VAT posting data into a format suitable for submission to tax authorities.

Properties

Name Value
DefaultLayout RDLC
RDLCLayout ./Finance/VAT/Reporting/VATStatement.rdlc
ApplicationArea #Basic,#Suite
Caption VAT Statement
UsageCategory ReportsAndAnalysis
WordMergeDataItem VAT Statement Name

Methods

CalcLineTotal

procedure CalcLineTotal(VATStmtLine2: Record "VAT Statement Line", var TotalAmount: Decimal, Level: Integer): Boolean

Parameters

Name Type Description
VATStmtLine2 Table Microsoft.Finance.VAT.Reporting."VAT Statement Line"
TotalAmount Decimal
Level Integer

Returns

Type Description
Boolean

CalcLineTotalWithBase

procedure CalcLineTotalWithBase(VATStmtLine2: Record "VAT Statement Line", var TotalAmount: Decimal, var TotalBase: Decimal, Level: Integer): Boolean

Parameters

Name Type Description
VATStmtLine2 Table Microsoft.Finance.VAT.Reporting."VAT Statement Line"
TotalAmount Decimal
TotalBase Decimal
Level Integer

Returns

Type Description
Boolean

InitializeRequest

procedure InitializeRequest(var NewVATStmtName: Record "VAT Statement Name", var NewVATStatementLine: Record "VAT Statement Line", NewSelection: Enum "VAT Statement Report Selection", NewPeriodSelection: Enum "VAT Statement Report Period Selection", NewPrintInIntegers: Boolean, NewUseAmtsInAddCurr: Boolean)

Parameters

Name Type Description
NewVATStmtName Table Microsoft.Finance.VAT.Reporting."VAT Statement Name"
NewVATStatementLine Table Microsoft.Finance.VAT.Reporting."VAT Statement Line"
NewSelection Enum Microsoft.Finance.VAT.Reporting."VAT Statement Report Selection"
NewPeriodSelection Enum Microsoft.Finance.VAT.Reporting."VAT Statement Report Period Selection"
NewPrintInIntegers Boolean
NewUseAmtsInAddCurr Boolean

InitializeRequest

procedure InitializeRequest(var NewVATStmtName: Record "VAT Statement Name", var NewVATStatementLine: Record "VAT Statement Line", NewSelection: Enum "VAT Statement Report Selection", NewPeriodSelection: Enum "VAT Statement Report Period Selection", NewPrintInIntegers: Boolean, NewUseAmtsInAddCurr: Boolean, NewCountryRegionFilter: Text)

Parameters

Name Type Description
NewVATStmtName Table Microsoft.Finance.VAT.Reporting."VAT Statement Name"
NewVATStatementLine Table Microsoft.Finance.VAT.Reporting."VAT Statement Line"
NewSelection Enum Microsoft.Finance.VAT.Reporting."VAT Statement Report Selection"
NewPeriodSelection Enum Microsoft.Finance.VAT.Reporting."VAT Statement Report Period Selection"
NewPrintInIntegers Boolean
NewUseAmtsInAddCurr Boolean
NewCountryRegionFilter Text

Events

OnCalcLineTotalOnBeforeCalcTotalAmountVATEntryTotaling

[IntegrationEvent(False,False)]
local procedure OnCalcLineTotalOnBeforeCalcTotalAmountVATEntryTotaling(VATStmtLine: Record "VAT Statement Line", var VATEntry: Record "VAT Entry", var Amount: Decimal, UseAmtsInAddCurr: Boolean)

Parameters

Name Type Description
VATStmtLine Table Microsoft.Finance.VAT.Reporting."VAT Statement Line"
VATEntry Table Microsoft.Finance.VAT.Ledger."VAT Entry"
Amount Decimal
UseAmtsInAddCurr Boolean

OnCalcLineTotalOnBeforeCalcTotalAmountAccountTotaling

[IntegrationEvent(False,False)]
local procedure OnCalcLineTotalOnBeforeCalcTotalAmountAccountTotaling(VATStmtLine: Record "VAT Statement Line", var VATEntry: Record "VAT Entry", var Amount: Decimal, UseAmtsInAddCurr: Boolean)

Parameters

Name Type Description
VATStmtLine Table Microsoft.Finance.VAT.Reporting."VAT Statement Line"
VATEntry Table Microsoft.Finance.VAT.Ledger."VAT Entry"
Amount Decimal
UseAmtsInAddCurr Boolean

OnCalcLineTotalOnVATEntryTotalingOnAfterVATEntrySetFilters

[IntegrationEvent(False,False)]
local procedure OnCalcLineTotalOnVATEntryTotalingOnAfterVATEntrySetFilters(VATStmtLine: Record "VAT Statement Line", var VATEntry: Record "VAT Entry", Selection: Enum "VAT Statement Report Selection")

Parameters

Name Type Description
VATStmtLine Table Microsoft.Finance.VAT.Reporting."VAT Statement Line"
VATEntry Table Microsoft.Finance.VAT.Ledger."VAT Entry"
Selection Enum Microsoft.Finance.VAT.Reporting."VAT Statement Report Selection"

OnCalcLineTotalWithBaseOnCaseElse

[IntegrationEvent(False,False)]
local procedure OnCalcLineTotalWithBaseOnCaseElse(var VATStmtLine2: Record "VAT Statement Line", var Amount: Decimal, var TotalAmount: Decimal, Level: Integer, PeriodSelection: Enum "VAT Statement Report Period Selection", StartDate: Date, EndDate: Date, EndDateReq: Date, PrintInIntegers: Boolean, UseAmtsInAddCurr: Boolean, var TotalBase: Decimal)

Parameters

Name Type Description
VATStmtLine2 Table Microsoft.Finance.VAT.Reporting."VAT Statement Line"
Amount Decimal
TotalAmount Decimal
Level Integer
PeriodSelection Enum Microsoft.Finance.VAT.Reporting."VAT Statement Report Period Selection"
StartDate Date
EndDate Date
EndDateReq Date
PrintInIntegers Boolean
UseAmtsInAddCurr Boolean
TotalBase Decimal

OnCalcLineTotalWithBaseOnAfterGLAccSetFilters

[IntegrationEvent(False,False)]
local procedure OnCalcLineTotalWithBaseOnAfterGLAccSetFilters(var GLAccount: Record "G/L Account", VATStatementLine2: Record "VAT Statement Line")

Parameters

Name Type Description
GLAccount Table Microsoft.Finance.GeneralLedger.Account."G/L Account"
VATStatementLine2 Table Microsoft.Finance.VAT.Reporting."VAT Statement Line"

OnAfterGetAmtRoundingDirection

[IntegrationEvent(False,False)]
local procedure OnAfterGetAmtRoundingDirection(var Direction: Text[1])

Parameters

Name Type Description
Direction Text[1]

OnBeforeCalcLineTotalWithBase

[IntegrationEvent(True,False)]
local procedure OnBeforeCalcLineTotalWithBase(VATStmtLine2: Record "VAT Statement Line", var TotalAmount: Decimal, var TotalBase: Decimal, Level: Integer, var RowNo: array[6] of Code[10], var ErrorText: Text[80], var Result: Boolean, var IsHandled: Boolean)

Parameters

Name Type Description
VATStmtLine2 Table Microsoft.Finance.VAT.Reporting."VAT Statement Line"
TotalAmount Decimal
TotalBase Decimal
Level Integer
RowNo array[6] of Code[10]
ErrorText Text[80]
Result Boolean
IsHandled Boolean

See also