Contents

• Title and Copyright Information
• Preface

1 Introduction to JD Edwards EnterpriseOne Tax Processing

• JD Edwards EnterpriseOne Tax Processing Overview
• JD Edwards EnterpriseOne Tax Processing Implementation
  • Implementation Steps

2 Understanding Tax Explanation Codes

• Understanding Tax Explanation Codes
• Sales Tax (S) - Purchase Order to Voucher
  • Purchasing for Stock Items - Three-Way Voucher Match
  • Purchasing for Nonstock Items - Three-Way Voucher Match
  • Purchasing for Nonstock Items - Two-Way Voucher Match
• Sales Tax (S) - Sales Order to Invoice
• Sales Tax (S) - Voucher and Invoice Entry
• Use Tax (U) - Purchase Order to Voucher
  • Purchasing for Stock Items - Three-Way Voucher Match
  • Purchasing for Nonstock Items - Three-Way Voucher Match
  • Purchasing for Nonstock Items - Two-Way Voucher Match
• Use Tax (U) - Voucher Entry
• VAT Tax (V) - Purchase Order to Voucher
  • Purchasing for Stock Items - Three-Way Voucher Match
  • Purchasing for Nonstock Items - Three-Way Voucher Match
  • Purchasing for Nonstock Items - Two-Way Voucher Match
• VAT Tax (V) - Sales Order to Invoice
• VAT Tax (V) - Voucher and Invoice Entry
• VAT + Sales Tax (C) - Purchase Order to Voucher
  • Purchasing for Stock Items - Three-Way Voucher Match
  • Purchasing for Nonstock Items - Three-Way Voucher Match
  • Purchasing for Nonstock Items - Two-Way Voucher Match
• VAT + Sales Tax (C) - Sales Order to Invoice
• VAT + Sales Tax (C) - Voucher and Invoice Entry
• VAT + Use Tax (B) - Purchase Order to Voucher
  • Purchasing for Stock Items - Three-Way Voucher Match
  • Purchasing for Nonstock Items - Three-Way Voucher Match
  • Purchasing for Nonstock Items - Two-Way Voucher Match
• VAT + Use Tax (B) - Voucher Entry
• Tax Exempt (E)

3 Setting Up Tax Information

• Common Fields Used in This Chapter
• Setting Up Tax Authorities
• Setting Up Tax UDCs
  • Tax ID Validation (70/TI)
  • Setting Up UDCs for Alternate Tax Rate/Area Assignment
    • Countries Alternate Tax Rate/Area (00/EC)
    • Edit Flag (00/EE)
    • Transaction Source (00/ES)
• Setting Up Tax Rules by Company
  • Understanding Tax Rules by Company
    • Tolerance Rules
    • Calculation Rules for Discount and Tax Amounts
    • Examples: Calculation Rules for Taxes
    • Example 1
    • Example 2
    • Example 3
    • Example 4
    • (GBR) Example 5
    • (DEU) Example 6
    • Edit Rules
  • Forms Used to Set Up Tax Rules
  • Setting Up Tax Rules
• Setting Up AAIs for Taxes
  • Understanding AAIs for Taxes
  • Understanding Financial AAIs for Taxes
    • AAI Hierarchy
    • VAT Tax AAIs for the Accounts Payable, Accounts Receivable, and General Accounting Systems (PTxxxx, RTxxxxx, GTxxxx)
    • VAT Tax AAIs for JD Edwards EnterpriseOne Procurement (PTVATD)
    • Tax AAI (PT) for the Accounts Payable and Procurement Systems
  • Understanding Distribution AAIs for Taxes
    • Tax Rate Area Setup
    • Distribution AAI Set Up
• Setting Up Tax Rate Areas
  • Understanding Tax Rate Areas
    • Tax Rate Areas for Items
    • Revising Tax Rate Areas
  • Understanding Nonrecoverable VAT
    • Example: Using Nonrecoverable VAT
  • Prerequisites
  • Forms Used to Set Up Tax Rate Areas
  • Setting Processing Options for Tax Rate/Areas (P4008)
    • Display
    • Edits
  • Setting Up Tax Rate Areas
• Setting Up Default Tax Information
  • Understanding Default Values for Taxes
  • Forms Used to Set Up Default Tax Information for the Business Unit, Supplier, and Customer Records
• Setting Up Alternate Tax Rate/Area Assignment Functionality
  • Understanding Alternate Tax Rate/Area Assignment Functionality
  • Setting Up the Alternate Tax Rate/Area Assignment Company Constants
    • Understanding the Alternate Tax Rate/Area Assignment Company Constants
    • Forms Used to Set Up the Alternate Tax Rate/Area Assignment Company Constants
    • Setting Up Alternate Tax Rate/Area Assignment Company Constants
  • Setting Up Alternate Tax Rate/Area Definitions
    • Understanding Alternate Tax Rate/Area Definitions
    • Examples of Alternate Tax Rate/Area Definitions
    • Forms Used to Set Up Alternate Tax Rate/Area Definitions
    • Setting Up Alternate Tax Rate/Area Definitions
  • Setting Up Company Address Number for Tax Reports
    • Understanding Company Address Number for Tax Reports Setup
    • Forms Used to Set Up Company Address Number for Tax Reports
    • Setting Up Company Address Number for Tax Reports
  • Setting Up Alternate Tax Rate/Area By Country
    • Understanding Alternate Tax Rate/Area By Country
    • Forms Used to Set Up Alternate Tax Rate/Area By Country
    • Setting Up Alternate Tax Rate/Area By Country
  • Running the Alternate Tax Rate/Area By Country Integrity Report
  • Setting Processing Options for Alternate Tax Rate/Area by Country Integrity (R40083)
    • Process
  • Setting Up Address Book Records to Work with the Alternate Tax Rate/Area Assignment Functionality
• Assigning Tax Information to General Ledger Accounts
  • Understanding Tax Information for General Ledger Accounts
  • Forms Used to Assign Tax Information to General Ledger Accounts
  • Assigning Tax Information to General Ledger Accounts
    • More
• Setting Up the Tax Constant by Company
  • Understanding Tax Capture Settings
  • Forms Used to Set the Tax Constant by Company
  • Setting the Tax Constant by Company

4 Validating Tax IDs

• Validating Tax ID Numbers
  • Understanding Tax ID Validation
    • Example of Tax ID or VAT Registration Numbers by Country
    • (ITA) Tax ID or VAT Registration Number for Italy
    • (AUT) Tax ID or VAT Registration Number for Austria
    • (NLD) Tax ID or VAT Registration Number for the Netherlands
    • (DEU) Tax ID or VAT Registration Number for Germany
    • (GBR) Tax ID or VAT Registration Number for the United Kingdom
    • (SWE) Tax ID or VAT Registration Number for Sweden
    • (FIN) Tax ID or VAT Registration Number for Finland
    • (DNK) Tax ID or VAT Registration Number for Denmark
  • Understanding How to Activate Tax ID Validation Routine
    • User Display Preferences
  • Understanding How to Override Tax ID Validation Routine
• Validating EU VAT ID Using VAT Information Exchange System (VIES)
  • Understanding the VIES to Validate EU VAT ID
    • Using JD Edwards EnterpriseOne to Validate EU VAT ID Using VIES
    • Understanding Batch Validation
    • Validating the VAT ID for Italy Using VIES
  • Prerequisites
    • Understanding the Soft Coding Record for VIES Validation
    • Forms Used to Set Up Soft Coding Templates
      • Adding a Soft Coding Template
    • Forms Used to Set Up Soft Coding Records
      • Adding a Soft Coding Record
    • Understanding Business Service Property Information
    • Forms Used to Manage Business Service Properties
    • Set Up the Business Service J740105
  • Setting Up a UDC for EU VAT ID Validation
  • Setting Processing Options for the Validate VAT ID VIES Program (R74101)
    • General Processing Options
    • Requester Information Processing Option
  • Validating VAT ID Using VIES
    • Validating a New VAT ID at the Time of Data Entry
    • Validating Multiple Records
  • Reviewing VAT IDs Validated by VIES
    • Form Used to Review VAT IDs Validated Using VIES
    • Reviewing VAT IDs Validated Using VIES

5 Working With Tax Information on Orders and Transactions

• Understanding Rounding vs. Soft Rounding
• Understanding Programs that Update the Account Ledger Table (F0911)
• Understanding How the System Calculates Taxes on Foreign Amounts
  • Understanding Tax Calculations on Foreign Invoices, Vouchers, and Purchase Orders
    • Example of Tax Calculation on Foreign Invoice
    • Setup
    • Calculations
  • Understanding Tax Calculations on Foreign Sales Orders
    • Example of Tax Calculation on Foreign Sales Order
    • Setup
    • Calculations
• Entering Tax Information on Purchase Orders and Sales Orders
  • Understanding Tax Information for Purchase Orders and Sales Orders
    • Releasing Retainage on Purchase Orders with Taxes
    • Taxable and Nontaxable Invoice Pay Items Generated from Sales Orders
  • Prerequisites
  • Forms Used to Enter Tax Information on Purchase Orders and Sales Orders
  • Entering Tax Information on Purchase Orders
  • Entering Tax Information on Sales Orders
• Understanding Tracking Taxes
• Tracking Taxes by Tax Rate/Area on Invoices and Vouchers
  • Understanding Tracking Taxes by Tax Rate/Area
  • Prerequisites
  • Forms Used to Track Taxes by Tax Rate/Area
  • Tracking Taxes by Tax Rate/Area on Invoices
    • Standard Invoice Entry
    • GL Distribution
  • Tracking Taxes by Tax Rate/Area on Vouchers
    • Enter Voucher - Payment Information
    • GL Distribution
• Tracking Taxes by Pay Item and G/L Account on Invoices and Vouchers
  • Understanding Tracking Taxes by Pay Item and G/L Account
    • Tracking Taxes by Pay Item and G/L Account With Split Payments or Installments
    • Tracking Taxes by Pay Item and G/L Account in the Journal Edit Register Program
    • Tracking Taxes by Pay Item and G/L Account in the A/P Voucher Journal Entry Redistribution Program
  • Prerequisites
  • Forms Used to Enter Tax Information by Pay Item and G/L Account
  • Entering Tax Information by Pay Item and G/L Account
• Updating Tax Information
  • Understanding the General Ledger Post Program and Updating Tax Information
  • Running the General Ledger Post Program
• Revising Invoices and Vouchers with Taxes
  • Splitting Vouchers for Payment
• Entering Journal Entries with VAT
  • Understanding Journal Entries with VAT
    • (COL) Journal Entries with VAT for Colombia
    • Example: Journal Entry with VAT
  • Prerequisite
  • Forms Used to Enter Journal Entries with VAT
  • Setting Processing Options for Journal Entries with VAT (P09106)
    • Addr # Required
    • MBF Version
    • Defaults (Release 9.2 Update)
  • Entering Journal Entries with VAT
• Processing Batch Invoices and Vouchers with Taxes
  • Understanding Batch Processing for Invoices and Vouchers with Taxes
    • Tax Rate Area and Tax Explanation Code Defaults
    • Fields Required for Processing Tax Information on Batch Invoices and Vouchers
    • Distribution Information for Batch Processing
    • Processing Foreign Amounts and Taxes
• Processing Batch Journal Entries with VAT
  • Understanding Batch Journal Entries with VAT
    • Processing Foreign Amounts with Taxes

6 Working with the Taxes Table

• Understanding the Process to Update the Taxes Table
• Adding Transactions in the Taxes Table
  • Understanding the Tax File Revisions Program
  • Forms Used to Add Transactions to the Taxes Table
  • Adding Transactions to the Taxes Table
• Purging Transactions in the Taxes Table
  • Purging Transactions in the Taxes Table

7 Updating the Tax Reconciliation Repository

• Updating the Tax Reconciliation Repository
  • Understanding the Process to Update the Tax Reconciliation Repository
    • Reconciling Tax Amounts by GL Account
    • Revising Reconciled Transactions
    • Example: Updating the Tax Reconciliation Repository
    • Tax Rate Area Setup
    • AAI Setup
    • Invoice Entry
    • Invoice: 11223 RI 00001
    • GL Distribution: 11223 RI 00001
    • Post Report
    • Update Tax Reconciliation Repository
  • Running the Update Tax Reconciliation Repository Program
  • Setting Processing Options for Update Tax Reconciliation Repository (R0018R)
    • Selection Criteria
• Reviewing the Tax Reconciliation Repository
  • Understanding the Process to Review the Tax Reconciliation Repository
  • Form Used to Review Records in the Tax Reconciliation Repository

8 Working With VAT Processing

• Understanding VAT Terminology and Principles

9 Working With Generic VAT Reports

• Understanding Generic VAT Reports
  • Understanding the XML Generation Process
    • Extract Data Tables
    • Get Parameters
    • Country Specific Data Requirements
    • Generate XML
• Generating Generic VAT Reports
  • Running Generic VAT Reports
  • Setting Processing Options for Generic VAT Extractor Program (R700001)
    • Processing Mode
    • Data Selection
    • Fiscal Information
    • Declaration Information
    • Default
    • Validations
    • Print Options
    • Currency
    • European Union
• Reviewing Generic VAT Reports
  • Understanding How Review Generic VAT Reports
  • Forms Used to Review Generic VAT Reports
  • Reviewing Generic VAT Reports

10 Setting Up the Interface to Vertex Sales Tax Q Series

• Understanding the Interface to Vertex Sales Tax Q Series
• Understanding JD Edwards EnterpriseOne Tax Calculation Components
  • Tax Considerations
• Understanding Databases Used by Vertex Sales Tax Q Series
• Prerequisite
• Setting Up Vertex Sales Tax Q Series
  • Understanding the Setup for Vertex Sales Tax Q Series
    • Vertex Sales Tax Q Series Constants
    • Vertex Sales Tax Q Series Connection Verification
    • Vertex Sales Tax Q Series Logging
  • Prerequisites
  • Forms Used to Set Up Vertex Sales Tax Q Series
  • Setting Up Vertex Q Series Constants
  • Testing the Vertex Sales Tax Q Series Connection
  • Activating Vertex Sales Tax Q Series Logging
• Setting Up AAIs for Vertex Sales Tax Q Series
  • Understanding AAIs for Vertex Sales Tax Q Series
    • AAI Items PTxxxx and RTxxxx
    • JD Edwards EnterpriseOne Sales Order Management, Service Management, and Procurement Systems
• Setting Up User-Defined Codes for Vertex Sales Tax Q Series
• Processing Taxes for Stock and Nonstock Items
  • Understanding the Tax Process for Stock and Nonstock Items
    • Hierarchy for Product Category IDs and Transaction Types
  • Forms Used to Assign Non-Stock
  • Assigning Non-Stock Product Categories to Order Types
• Defining Tax Information for Items
  • Understanding Tax Information for Items
  • Prerequisite
  • Forms Used to Define the Tax Fields for an Item
  • Defining the Tax Fields for an Item
• Working With GeoCodes and Address Book Records
  • Understanding How to Assign GeoCodes to Address Book Records
    • Calculating Taxes for Related Addresses
  • Understanding How to Assign GeoCodes Globally
    • Update Address Book GeoCodes
    • Updating Effective Dates on Address Book Records
  • Understanding How to Assign GeoCodes Manually
  • Understanding How to Override GeoCodes
    • Overriding GeoCodes on an Invoice
    • Overriding GeoCodes on a Voucher
    • Overriding GeoCodes on a Sales Order
    • Overriding GeoCodes on a Purchase Order
    • Overriding GeoCodes on a Service Contract
    • Overriding GeoCodes on a Service Order
    • Overriding GeoCodes on a Call
    • Overriding GeoCodes on a Contract Billing Line
    • Overriding GeoCodes in the JD Edwards EnterpriseOne Service Billing System
  • Prerequisite
  • Running the Update Address Book GeoCodes Program
  • Running the Effective Address Update Program
• Processing Vertex Sales Tax Q Series Tax Information
  • Understanding the Tax Process When Using Vertex Sales Tax Q Series
    • Financial Processes
    • Distribution Processes
    • JD Edwards EnterpriseOne Service Management System Processes
    • Contract Billing and Service Billing Processes
• Printing Tax Information

11 Appendix A - Mapping Fields from Vertex Sales Tax Q Series System to JD Edwards EnterpriseOne Software

• JD Edwards EnterpriseOne Accounts Payable
  • Accounts Payable Ledger Table (F0411)
  • Address Selection Hierarchy
    • Accounts Payable, Tax Explanation Code U or E
    • Accounts Payable, Tax Explanation Codes
• JD Edwards EnterpriseOne Accounts Receivable
  • Customer Ledger Table (F03B11)
  • Address Selection Hierarchy
    • Accounts Receivable - Sales Tax
• JD Edwards EnterpriseOne Contract Billing and JD Edwards EnterpriseOne Service Billing and JD Edwards EnterpriseOne Service Management
  • Billing Detail Workfile Table (F4812)
  • Address Selection Hierarchy
    • JD Edwards EnterpriseOne Contract Billing and JD Edwards EnterpriseOne Service Billing - Sales Tax
    • JD Edwards EnterpriseOne Service Management System - Contract Sales Tax
    • JD Edwards EnterpriseOne Service Management System - Service Order Sales Tax
    • JD Edwards EnterpriseOne Service Management System - Service Order Use Tax
• JD Edwards EnterpriseOne Sales Order Management
  • Sales Order Detail File (F4211) and Sales Order Header File (F4201) tables
  • Address Selection Hierarchy
• JD Edwards EnterpriseOne Procurement
  • Address Selection Hierarchy
    • JD Edwards EnterpriseOne Procurement - Use Tax

12 Appendix B - JD Edwards EnterpriseOne Tax Processing Reports

• JD Edwards EnterpriseOne Tax Processing Reports: A to Z
• JD Edwards EnterpriseOne Tax Processing Reports: Selected Reports
  • R0018P - Tax/Detail Summary Report
    • As If Currency Reporting
    • Intracommunity Reporting
  • Data Selection and Sequencing
  • Processing Options for Tax Detail/Summary (R0018P)
    • Tax Report
    • As-If Currency
    • Dates
  • R0018P1 - Tax Summary Report/Use VAT
    • Intracommunity Reporting
  • Processing Options for Tax Summary Report/Use VAT (R0018P1)
    • Tax Report
    • As-If Currency
    • Dates
  • R0018P2 - Sales Tax
  • Processing Options for Sales Tax (R0018P2)
    • Versions
  • R0018P7 - VAT Exception Report by Tax Area
    • As If Reporting
  • Data Selection
  • Processing Options for VAT Exception Report by Tax Area (R0018P7)
    • As-If Currency
  • R0018P8 - GST/PST Tax
  • Processing Options for GST/PST Tax (R0018P8)
    • Update Options
    • Display
  • R00320 - VAT Journals
  • Processing Options for VAT Journals (R00320)
    • Select
    • Print
    • Columns
    • Process

13 Appendix C - Alternate Tax Rate/Area Assignment Functionality - Impacted Objects

• Understanding Objects Impacted by the Alternate Tax Rate/Area Assignment Functionality
• Financial Management: Accounts Payable
• Financial Management: Accounts Receivable
• Financial Management: Expense Management
• Customer Service Management
• CRM - Case Management
• Contract Billing
• Service Billing
• Grower Management
• Homebuilder Management
• Procurement Management
• Advanced Contract Billing
• Real Estate Management
• Sales Order Management
• Transportation Management
• Work Orders