Go to main content
1/54
Contents
List of Figures
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Information
Conventions
Part I Overview
1
Value Added Taxes (VAT)
1.1
Tax Categories
1.2
Tax Calculation Example
2
United States Tax Structure
2.1
Company Classifications
2.1.1
Taxable Companies
2.1.2
Tax Exempt Companies
2.2
Remitting Sales Taxes
2.2.1
Sales (Seller-Assessed) Tax
2.2.2
Use (Self-Assessed) Tax
3
Canadian Tax Structure
3.1
Types of Taxes
3.1.1
Goods and Services Tax (GST)
3.1.2
Provincial Sales Tax (PST)
3.2
Tax Calculation Examples
3.3
Remitting PST
3.3.1
Self-Assessed PST
3.3.2
Seller-Assessed PST
4
European Union Tax Structure
4.1
Overview
5
Italian Tax Structure
5.1
Overview
Part II Setup
6
Overview to Setup
6.1
Chapter Summaries
7
Tax Authorities
7.1
Tax Authorities (P01051)
7.2
Procedures
7.3
Guidelines
8
Tax Rates and Areas
8.1
About Tax Rates and Areas
8.1.1
Definition of a Tax Area
8.1.2
Guidelines
8.2
Adding Tax Rates & Areas (P4008)
8.2.1
Processing Options
8.3
Changing Expiration Dates
8.3.1
Changes to Tax Rate Area with No Overlap
8.3.2
Changes to Tax Rate Area with an Overlap
8.4
Creating Memos for Tax/Rate Areas
8.5
Canadian Considerations
8.6
United States (Sales and Use Tax) Considerations
8.6.1
A/P and A/R Processing
8.6.2
Purchase and Sales Order Management
9
Tax Explanation Codes
9.1
Tax Explanation Codes
9.1.1
Working with Tax Explanation Codes
9.1.2
Tax Codes
9.1.3
Systems and Tax Explanation Codes
9.1.4
Products and Tax Explanation Codes
9.1.5
What You Should Know About
10
Automatic Accounting Instructions (AAIs)
10.1
AAIs for A/P, AR, and Journal Entries
10.2
AAIs for Accounts Payable
10.2.1
Accounts Payable AAI Naming Conventions
10.2.2
A/P AAIs for Tax Explanation Codes
10.2.3
Using Default AAIs
10.3
AAIs for Accounts Receivable
10.3.1
A/R AAI Naming Conventions
10.3.2
A/R AAIs for Tax Explanation Codes
10.3.3
Using Default AAIs
10.4
AAIs for Journal Entries
10.4.1
Journal Entry AAI Naming Convention
10.4.2
Using Default AAIs
10.5
AAIs for Purchase Orders and Sales Orders
10.5.1
Automatic Accounting Instructions (P40901)
10.5.2
Distribution AAI Record Types (P40900)
10.5.3
Distribution Automatic Account (P40950)
10.5.4
AAIs for Purchase Orders
10.5.5
AAIs for Sales Orders
10.5.6
Examples
10.6
Procedures
10.7
What You Should Know About
11
Tax Rules by Company
11.1
About Tax Rules by Company
11.2
Tax Rules by Company (P0022)
11.3
Tax Rules and Systems
11.3.1
VAT and Canadian Considerations
11.3.2
United States (Sales and Use Tax) Considerations
11.4
System Calculation Examples
11.4.1
Examples for Accounts Receivable
11.4.2
Examples for Accounts Payable
11.4.3
Examples for Sales Orders and Purchase Orders
11.4.4
Journal Entries
11.5
Guidelines
12
Default Values
12.1
About Default Values
12.2
Default Values for A/P
12.2.1
Supplier Master Information (P01054)
12.3
Default Values for A/R
12.3.1
Customer Master Information (P01053)
12.4
Defaults Values for Purchase Orders
12.4.1
Tax Default Override
12.5
Defaults Values for Sales Orders
12.5.1
Tax Default Override
12.6
What You Should Know About
13
European Union Setup
13.1
Assign VAT Registration Numbers
13.2
Set Up Tax Rate/Areas
13.3
Modify Commodity Codes for EU
13.4
Determine Nature of Transaction Codes
13.5
Assign Commodity Codes and Nature of Transaction Codes to Items
13.6
Modify Freight Handling Codes (Add Conditions of Transport)
13.7
Modify Freight Handling Codes (Add Modes of Transport)
13.8
Example for Conditions of Transport and Modes of Transport
13.9
Set Up User Defined Codes for EU
14
Italian Setup
14.1
User Defined Codes
14.2
Mid-Year Setup
Part III Daily/Periodic Activity
15
Overview to Daily/Periodic Activity
15.1
Chapter Summaries
16
A/P Voucher Entry
16.1
About A/P Voucher Entry
16.2
Speed Voucher Entry (P041015)
16.2.1
Processing Options
16.3
Standard Voucher Entry
16.3.1
Standard Voucher Entry (P04105)
16.3.2
Processing Options
16.3.3
What You Should Know About
17
A/R Invoice Entry
17.1
About Invoice Entry
17.2
Speed Invoice Entry (P031015)
17.2.1
Entry with Tax Defaults
17.2.2
Processing Options
17.3
Standard Invoice Entry (P03105)
17.3.1
Standard Invoice Entry (P03105)
17.3.2
Toggling Between Formats/Fold Area
17.3.3
Entry with Tax Defaults
17.3.4
What You Should Know About
17.3.5
Processing Options
18
Purchase Order Entry
18.1
About Purchase Order Entry
18.2
Entering Purchase Orders
18.2.1
Entry with Tax Defaults
18.2.2
Automatic Loading of Header Values to Detail Lines
18.2.3
Processing Option
18.3
Match Voucher to Open Receipt (P4314)
18.3.1
What You Should Know About
19
Sales Order Entry
19.1
About Tax During Sales Order Entry
19.2
Enter Orders (Page Mode) (P4210)
19.2.1
Entry with Tax Defaults Values
19.2.2
What You Should Know About
20
Journal Entry with VAT Tax
20.1
About Journal Entries with VAT Taxes
20.1.1
Journal Entry with VAT Tax (P09106)
20.1.2
Processing Options
20.1.3
Comparison with Regular Journal Entry Screen
20.2
Working with Journal Entry with VAT Tax (P09106)
20.2.1
Adding Journal Entries
20.2.2
Changing an Unposted Journal Entry
20.2.3
Reversing an Unposted Journal Entry
20.2.4
Changing a Posted Journal Entry
20.2.5
Voiding a Posted Journal Entry
20.2.6
What You Should Know About
21
Posting for A/P, A/R, Purchase Orders, and Sales Orders
21.1
About Posting
21.2
Posting A/P Vouchers
21.2.1
Voucher Posting Processing Options
21.2.2
Processing Options
21.3
Posting A/R Invoices
21.3.1
Invoice Posting Processing Options
21.4
Posting Purchase Orders
21.4.1
Purchase Order Posting Processing Options
21.5
Posting Sales Orders
21.5.1
Sales Order Posting Processing Options
21.6
Journal Entries
22
Entry for A/P, A/R, and Sales Orders
22.1
About Posting Calculations
23
Tax Work File
23.1
Correcting the Tax Work File
23.1.1
Procedures
23.1.2
Guidelines
23.2
Purge the Tax Work File
23.2.1
Dream Writer Considerations
23.2.2
Guidelines
24
Working with Suspended VAT Tax
24.1
Understanding Suspended Tax Processing
24.2
Programs Used to Set Up Suspended Tax
24.3
Setting Up Suspended Tax
24.4
Setting Up AAIs for Suspended VAT Process
24.5
Setting Up Suspended Tax User Defined Codes
24.5.1
Batch Types (98/IT)
24.5.2
Document Types with Suspended Tax Hold (00/DH)
24.5.3
Tax Areas with Suspended Tax Hold (00/TH)
24.5.4
Tax Areas Using Suspended Tax (00/XA)
24.6
Releasing Suspended Tax
24.6.1
Processing Options
24.6.2
Processing Options for Releasing Suspended Tax (Batch)
24.7
Reviewing and Posting Suspended Vat Tax Batches
25
European Union Activities
25.1
About European Activities
25.2
Purging the Sales Order Management System
25.3
Uploading Information to F0018T for the Intrastat Report
25.3.1
What You Should Know About
25.4
Manually Entering/Updating Information in F0018T for the Intrastat Report
25.4.1
Direct Extra Tax File Adjustment (P0018T)
25.4.2
Procedures
25.4.3
What You Should Know About
25.5
EU Intrastat Tax File Batch Update
25.5.1
Using Extra Tax File Revisions
25.6
Invoice for the A/R System
25.7
Review of EU Responsibilities
26
Italian IVA Activities
26.1
About IVA Activities
26.2
Annual IVA File Build (P00911)
26.2.1
Processing Options
26.3
Annual IVA File Revisions (P00900)
26.4
Creating a Tape Copy of IVA Information
26.4.1
Adding Supplemental Address Book Information (P0091)
26.4.2
Creating File for Tape
26.4.3
Coping File to Tape
26.5
A/P Year-End Report
26.5.1
DREAM Writer Considerations
27
Japanese Consumption Tax Activities
27.1
About Japanese Consumption Tax
27.2
Upload Information to F00189 for Reports
27.2.1
Consumption Tax Workfile Edit Report
27.3
Update Information in F00189 for Reports
27.4
Errors
28
Date Translation Generation
28.1
Date Formats
Part IV Tax Report
29
Overview to Tax Report
29.1
Before You Run Reports
29.2
Reports
29.2.1
General Reports
29.2.2
Canadian Tax Report
29.2.3
European Union Tax Reports
29.2.4
Italian Tax Reports
29.2.5
Japanese Consumption Tax Reports
30
Use/VAT Tax Reports
30.1
About Use/Vat Tax Reports
30.2
Use/VAT Tax Report (P0018P)
30.2.1
Detail Report
30.2.2
Summary Report
30.2.3
What You Should Know About
31
Sales Tax Reports
31.1
About Sales Tax Reports
31.2
Sales Tax Reports
31.2.1
Sales/VAT Tax Authority Report by Company
31.2.2
Sales/VAT Tax Detail Report by Company
31.2.3
Sales/VAT Tax Authority Report by Sales Order
31.2.4
What You Should Know About
32
Generic VAT Reports
32.1
About Generic VAT Reports
32.1.1
About the XML Generation Process
32.1.1.1
Extract Data Files
32.1.1.2
Get Parameters
32.1.1.3
Country Specific Data Requirements
32.1.1.4
Generate XML
32.2
Work with Generic VAT Reports (P700001)
32.2.1
Processing Options
32.3
Revising VAT Reports
33
VAT Journal Reports
33.1
About VAT Journal Reports
33.2
VAT Journal
33.2.1
What You Should Know About
34
VAT Exception Reports
34.1
About VAT Exception Reports
34.2
VAT Exception Report (P0018P7)
34.2.1
What You Should Know About
35
Canadian GST and PST Tax Reports
35.1
About Canadian GST and PST Tax Reports
35.2
GST and PST Tax Report (P0018P8)
35.2.1
What You Should Know About
36
European Union Tax Reports
36.1
About European Union Tax Reports
36.1.1
Before you Begin
36.2
EU Sales Listing (P0018S)
36.3
Intrastat Reports
36.3.1
EU Intrastat Report
36.3.2
EU Intrastat Report (for Purchase Transactions)
36.3.3
Belgian Format Intrastat Report
36.3.4
French Format Intrastat Report
36.3.5
U.K. Format Intrastat Report
36.3.6
German Format Intrastat Report
36.3.7
Austrian Format Intrastat Report
37
Italian IVA Tax Reports
37.1
About IVA Reports
37.1.1
Before You Begin
37.2
IVA Reports
37.2.1
IVA by Tax Area Code (P00400)
37.2.2
Monthly IVA Reports (P004051)
37.2.3
Annual IVA Control Reports - Italian IVA Reports (P00910)
37.2.4
Annual Supplier IVA Form (P00917) and Annual Customer IVA Form (P00916)
38
Japanese Consumption Tax Reports
38.1
About Japanese Consumption Tax Reports
38.1.1
Before you Begin
38.2
Reports for Government
Part V Processing Options
39
Setup Processing Options
39.1
Tax Rates & Areas (P4008)
40
Daily/Periodic Activity Processing Options
40.1
Speed Voucher Entry (P041015)
40.2
Voucher Entry (P04105)
40.3
Speed Invoice Entry (P031015)
40.4
Invoice Entry (P03105)
40.5
Order Entry (P4311)
40.6
Journal Entries with Tax (P09106)
40.7
General Ledger Post (P09870)
40.8
Suspended Tax - Process Hold Pmts/Rcpts (P09861)
40.9
Generic VAT Reports (P700001)
A
Vertex Tax System
A.1
Overview to the Vertex™ Tax System
A.1.1
How Vertex Software Works
A.2
The Components of JD Edwards World/Vertex Interface
A.2.1
JD Edwards World Tax Calculator Components
A.2.2
Vertex Components
A.3
Considerations for Using the JD Edwards World/Vertex Interface
A.3.1
Company and Divisional Considerations
A.3.2
Product Considerations
A.3.3
Customer and Supplier Considerations
A.3.4
Foreign Tax Considerations
A.3.5
What You Should Know About
A.4
Setting Up the JD Edwards World/Vertex Interface
A.4.1
Before You Begin
A.5
Activating Vertex
A.5.1
Before You Begin
A.6
Assigning GeoCodes
A.6.1
GeoCodes Defaults
A.6.2
What You Should Know About
A.6.3
Assigning GeoCodes Globally to Address Book Records
A.6.4
Batch GeoCode Assignment
A.6.5
Assigning GeoCodes Manually to Address Book Records
A.6.6
What You Should Know About
A.6.7
Assigning GeoCodes to Customers
A.6.8
Online GeoCode Assignment
A.6.9
What You Should Know About
A.6.10
What You Should Know About
A.6.11
Assigning GeoCodes to Suppliers
A.6.12
What You Should Know About
A.6.13
What You Should Know About
A.6.14
Other Setup Considerations
A.7
Reviewing Taxes on Sales Orders and Purchase Orders
A.8
Activating Vertex Tax Decision Maker (TDM)
A.8.1
Before You Begin
A.8.2
The Master Table
A.8.3
The GeoCode Table
A.9
Assigning Non-Stock Product Categories to Order Types
A.10
Defining Tax Information for Items
A.10.1
The Product Table
A.10.2
The Customer Table
A.10.3
The Location Table
A.10.4
The Override Subtable
A.10.5
The Exemption Subtable
A.10.6
TDM Table Dependencies
A.10.7
The TDM Hierarchy
A.11
Common Troubleshooting Tips
A.11.1
UDC Table 73/EC
A.11.2
How to Print the Link/Parm Area
A.11.3
Proper Libraries Not in the Users Library List
A.11.4
Customer Master or Supplier Master Vertex Issues
A.11.5
Vertex Tax Calculation is Different from the World Tax Calculation
A.11.6
How to Write to a Different VTSREG file in CRP vs. Production
A.11.7
Sales order entry errors
A.11.8
Sales Update errors
A.11.9
Customer/Supplier Master errors
B
Understanding the Link/Parm Area
B.1
GeoCode Conversion - Program VGEO100
B.2
Sales Order Processing Tax Calculations - Program VTS110
B.2.1
Jurisdiction Data
B.2.2
Invoice Data
B.2.3
Customer Data
B.2.4
Company Data
B.2.5
Transaction Data
B.2.6
State Data
B.2.7
County Data
B.2.8
City Data
B.2.9
District Data
B.2.10
Intrastate Data
B.2.11
Address Data
B.3
Accounts Receivable Tax Calculations - Program VTS110
B.3.1
Jurisdiction Data
B.3.2
Invoice Data
B.3.3
Customer Data
B.3.4
Company Data
B.3.5
Transaction Data
B.3.6
State Data
B.3.7
County Data
B.3.8
City Data
B.3.9
District Data
B.3.10
Intrastate Calculation Area
B.3.11
Address Data
B.3.12
Accounts Payable
B.3.13
Purchasing
B.4
Understanding the Link/Parm Area
B.5
GeoCode Conversion - Program VGEO100
B.6
Sales Order Processing Tax Calculations - Program VTS110
B.6.1
Jurisdiction Data
B.6.2
Invoice Data
B.6.3
Customer Data
B.6.4
Company Data
B.6.5
Transaction Data
B.6.6
State Data
B.6.7
County Data
B.6.8
City Data
B.6.9
District Data
B.6.10
Intrastate Data
B.6.11
Address Data
B.7
Accounts Receivable Tax Calculations - Program VTS110
B.7.1
Jurisdiction Data
B.7.2
Invoice Data
B.7.3
Customer Data
B.7.4
Company Data
B.7.5
Transaction Data
B.7.6
State Data
B.7.7
County Data
B.7.8
City Data
B.7.9
District Data
B.7.10
Intrastate Calculation Area
B.7.11
Address Data
B.7.12
Accounts Payable
B.7.13
Purchasing
C
Examples of Tax Explanation Code Accounting
C.1
Example Data Sets
C.2
Guidelines
C.3
V VAT (GST in Canada)
C.4
VT VAT (tax only)
C.5
V+ VAT (calculated as a tax on a tax)
C.6
U Use Tax, Self-Assessed (PST in Canada)
C.7
UT Use Tax, Self-Assessed (tax only)
C.8
S Sales Tax, Seller-Assessed (PST in Canada)
C.9
ST Sales Tax, Seller-Assessed (tax only)
C.10
E Exempt (the product is not taxable)
C.11
Canadian Tax Explanation Code Examples
C.11.1
B GST + Self-Assessed PST (not calculated as a tax on a tax)
C.11.2
B GST + Self-Assessed PST (calculated as a tax on a tax)
C.11.3
BT GST + Self-Assessed PST (tax only)
C.11.4
C GST + Seller-Assessed PST (not calculated as a tax on a tax)
C.11.5
C GST + Seller-Assessed PST (calculated as a tax on a tax)
C.11.6
CT GST + Seller-Assessed PST (tax only)
C.11.7
GST Input Credits
D
Entry and Post Examples for Purchase Orders
D.1
Tax Explanation Code Examples
D.1.1
S Sales Tax, Inventory Example
D.1.2
S Sales Tax, Non-Inventory Example
D.1.3
U Use Tax, Inventory Example
D.1.4
U Use Tax, Non-Inventory Example
D.1.5
V VAT, Inventory Example
D.1.6
V VAT, Non-Inventory Example
D.2
Canadian Tax Explanation Code Examples
D.2.1
C GST + Seller-Assessed PST (Tax on a Tax), Inventory Example
D.2.2
C GST + Seller-Assessed PST (Tax on a Tax), Non-Inventory Example
D.2.3
B GST + Self-Assessed PST (Not Tax on Tax), Inventory Example
D.2.4
B GST + Self-Assessed PST (Not Tax on Tax), Non-Inventory Example
D.2.5
Guidelines
Index
Scripting on this page enhances content navigation, but does not change the content in any way.