VAT Posting Setup #325

Other table in Microsoft Dynamics 365 Business Central. 29 fields, 18 records in Cronus demo.

The VAT Posting Setup table (ID 325) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 29 fields, with a primary key of VAT Bus. Posting Group, VAT Prod. Posting Group. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: VAT Bus. Posting Group, VAT Prod. Posting Group.

All fields (29)

VAT Posting Setup — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	VAT Bus. Posting Group PK	Code	Normal	→ VAT Business Posting Group #323
2	VAT Prod. Posting Group PK	Code	Normal	→ VAT Product Posting Group #324
3	VAT Calculation Type	Option	Normal
4	VAT %	Decimal	Normal
5	Unrealized VAT Type	Option	Normal
6	Adjust for Payment Discount	Boolean	Normal
7	Sales VAT Account	Code	Normal	→ G/L Account #15
8	Sales VAT Unreal. Account	Code	Normal	→ G/L Account #15
9	Purchase VAT Account	Code	Normal	→ G/L Account #15
10	Purch. VAT Unreal. Account	Code	Normal	→ G/L Account #15
11	Reverse Chrg. VAT Acc.	Code	Normal	→ G/L Account #15
12	Reverse Chrg. VAT Unreal. Acc.	Code	Normal	→ G/L Account #15
13	VAT Identifier	Code	Normal
14	EU Service	Boolean	Normal
15	VAT Clause Code	Code	Normal	→ VAT Clause #560
16	Certificate of Supply Required	Boolean	Normal
17	Tax Category	Code	Normal
20	Description	Text	Normal
21	Blocked	Boolean	Normal
25	Sale VAT Reporting Code	Code	Normal	→ VAT Reporting Code #344
26	Purchase VAT Reporting Code	Code	Normal	→ VAT Reporting Code #344
6200	Non-Deductible VAT %	Decimal	Normal
6202	Non-Deductible Purchase VAT Account	Code	Normal	→ G/L Account #15
6203	Allow Non-Deductible VAT	Option	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (6)

Tables referenced by fields on the VAT Posting Setup table through TableRelation properties.

VAT Business Posting Group

#323 · Other · via VAT Bus. Posting Group

VAT Product Posting Group

#324 · Other · via VAT Prod. Posting Group

G/L Account

#15 · General Ledger · via Sales VAT Account, Sales VAT Unreal. Account, Purchase VAT Account, Purch. VAT Unreal. Account, Reverse Chrg. VAT Acc., Reverse Chrg. VAT Unreal. Acc., Non-Deductible Purchase VAT Account

VAT Clause

#560 · Other · via VAT Clause Code

VAT Reporting Code

#344 · Other · via Sale VAT Reporting Code, Purchase VAT Reporting Code