Setting Up Tax Information

This chapter provides an overview of tax explanation codes and discusses how to:

• Set up tax authorities.

• Set up tax user-defined codes (UDCs).

• Set up tax rules by company.

• Set up automatic accounting instructions (AAIs) for taxes.

• Set up tax rate areas.

• Set up default values for taxes.

• Validate tax ID numbers.

• Assign tax information to general ledger accounts.

• Set up the General Ledger Post program to update tax information.

Note. Additional country-specific setup for tax processing exists for many countries.

See Also

(ARG) Setting Up the System for Argentinian Taxes

(AUS) Setting Up Australian Goods and Services Tax

(BRA) Setting Up the System for Brazilian Taxes

(MEX) Working With VAT in Mexico

Setting Up Tax Rate Areas for Ecuador

Setting Up VAT for China

(BEL) Setting Up Tax Rate Areas for Belgium

(COL) Setting Up the System for Colombian Taxes

Setting Up the System for VAT Reporting

Setting Up Register Types and Classes for Summary VAT

Establishing an Initial VAT Balance

(RUS) Setting Up Your System to Process VAT

Understanding Intracommunity VAT

Understanding Tax Explanation Codes

You might be required to calculate, pay, collect, and track taxes on invoices that you receive from suppliers and send to customers. When this is necessary, you need to enter a tax explanation code on the transaction. You can enter the tax explanation code on the transaction entry form, or let the system use a default tax explanation code that you set up on the customer or supplier record.

Tax explanation codes are hard-coded values that exist in the Tax Explanation Codes (00/EX) user-defined codes (UDC) table. These codes specify the algorithm that the system uses to calculate the tax amount and which, if any, GL account is used to record tax information. Each tax explanation code specifies a particular algorithm that affects the amount to distribute in the general ledger. You can create your own tax explanation codes, but if they begin with B, C, E, S, U, or V, they will use the same algorithm and work exactly as the standard tax explanation codes. For example, S1 will function exactly as S and V7 will function exactly as V. If you create tax explanation codes for any other letter or number, the system uses the sales tax algorithm to calculate tax and distribution amounts.

The letter T follows some tax explanation codes. You use this type of tax explanation code when you want to enter only the tax portion of the transaction. For example, if you enter a voucher and do not include the tax information, you can enter another voucher and use the appropriate tax explanation code followed by the letter T to indicate that the entire voucher represents a tax amount.

Not every tax explanation code is applicable to every system in JD Edwards EnterpriseOne software.

These table lists the available tax explanation codes, the systems that use each code, and the gross and GL distribution amounts that the system calculates when the taxable amount is entered:

*AP = JD Edwards EnterpriseOne Accounts Payable

AR = JD Edwards EnterpriseOne Accounts Receivable

GA = JD Edwards EnterpriseOne General Accounting (journal entries)

PO = JD Edwards EnterpriseOne Procurement

SO = JD Edwards EnterpriseOne Sales Order Management

Note. Tax explanation code of AR is used by JD Edwards EnterpriseOne Property Management.

See Also

(COL and ECU) Tax Explanation Codes for Columbia and Ecuador

Sales Tax (S) - Purchase Order to Voucher

When you enter purchase orders with sales tax (tax explanation code S), the system uses distribution AAIs (automatic accounting instructions) to record the tax and, if you are purchasing for stock, update the inventory account. These AAIs differ depending on whether you are purchasing for stock and whether you use two-way or three-way matching.

These examples display the AAIs that the system uses and the tables and accounts that the system updates when you run the program specified. All of the examples are for a purchase order in the amount of 1,000 USD with a 10 percent sales tax rate. The system was set up to create the journal entries in detail.

Purchasing for Stock Items - Three-Way Voucher Match

When you purchase for stock, you must use three-way voucher matching. When you enter the purchase order receipt, the system records the tax in two general ledger accounts: Purchase Tax Accrual and Received Not Vouchered Tax. When the system creates the voucher, it offsets the Received Not Vouchered Tax account. You use the Purchase Tax Accrual account to track the tax portion of the item. You do not remit sales tax to a tax authority because the seller (supplier) pays it.

Example: Purchasing for Stock Items - Three-Way Voucher Match

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Note. When you enter tax information during the voucher match process, instead of when you enter the purchase order, the system does not make an entry to the account associated with DM AAI 4355; instead, the system debits the account for DM AAI 4350, as well as the Received Not Vouchered account, and credits the AP Trade account when the voucher is posted.

Purchasing for Nonstock Items - Three-Way Voucher Match

When you purchase for a nonstock item, you can use either two-way or three-way voucher matching. When you use three-way voucher matching and enter the purchase order receipt, the system records the tax in the Received Not Vouchered Tax account, which is offset when the system creates the voucher. The system records the sales tax on the voucher only and includes it in the amount of the expense distribution. The system does not record sales tax in a separate account because you do not remit it to a tax authority; the supplier pays it.

Example: Purchasing for Nonstock Items - Three-Way Voucher Match

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Purchasing for Nonstock Items - Two-Way Voucher Match

When you use two-way voucher matching, the system does not use the Received Not Vouchered accounts because you do not enter purchase order receipts; you enter the purchase order and create the voucher. The system does not record the sales tax in any general ledger account at any time during the process. The system records the sales tax on the voucher only and includes it in the amount of the expense distribution. The system does not record sales tax in a separate account because you do not remit it to a tax authority; the supplier pays it.

Example: Purchasing for Nonstock Items - Two-Way Voucher Match

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Sales Tax (S) - Sales Order to Invoice

When you enter a sales order with sales tax (tax explanation code S) and run Update Customer Sales (R42800), the system uses distribution AAIs to record the Store Sales, Tax Liability, Cost of Goods (COG) Sold, and Inventory accounts. You offset the Tax Liability account when you pay the tax authority.

This example displays the AAI that the system uses and the tables and accounts that the system updates when you run the specified program. The example is for a sales order in the amount of 1,000 USD with a 10 percent sales tax rate.

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Sales Tax (S) - Voucher and Invoice Entry

When you enter a voucher or invoice with sales tax, the system calculates the tax amount but does not create a separate entry to the general ledger. The sales tax appears only in the voucher or invoice record. For vouchers, the tax is part of the expense, so you do not need to enter the tax in a specific account. For invoices, however, you might want to track the sales tax in a separate account because you must pay it. In this instance, you would need to subtract the sales tax amount from the revenue and enter it separately.

Alternatively, instead of using tax explanation code S, you can use tax explanation code V for the system to record the tax in the account specified by PTxxxx (for payables) or RTxxxx (for receivables), where xxxx is the GL offset that is entered on the tax rate/area.

This example displays the AAI that the system uses and the tables and accounts that the system updates when you enter and post a voucher or invoice. The examples are for a taxable amount of 1,000 USD with a 10 percent sales tax rate.

Example: Voucher Entry

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Use Tax (U) - Purchase Order to Voucher

When you enter a purchase order with use tax (tax explanation code U), the system calculates the tax amount and makes a separate entry to the general ledger when you post the transaction.

The examples that follow display the AAIs that the system uses and the tables and accounts that the system updates when you run the program specified. All of the examples are for a purchase order in the amount of 1,000 USD with a 10 percent use tax rate. The system was set up to create the journal entries in detail.

Purchasing for Stock Items - Three-Way Voucher Match

When you purchase for stock, you must use three-way voucher matching. When you enter the purchase order receipt, the system records the tax in two general ledger accounts: Purchase Tax Accrual and Received Not Vouchered Tax. When the system creates the voucher, it offsets the Received Not Vouchered Tax account and records the tax in the Purchase Tax Accrual asset account only for tracking purposes. When you post the voucher, the system records the tax in the Use Tax Payable account. When you pay the tax authority, you enter a voucher that offsets the Use Tax Payable account.

Example: Purchasing for Stock Items - Three-Way Voucher Match

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Purchasing for Nonstock Items - Three-Way Voucher Match

When you purchase for a nonstock item, you can use either two-way or three-way voucher matching. When you use three-way voucher matching and enter the purchase order receipt, the system records the tax in the Received Not Vouchered Tax account, which is offset when the system creates the voucher. The system does not include the use tax in the gross amount of the voucher, nor does it include it in the amount of the expense distribution. The system records the tax in a separate account that is offset when you remit the tax to the tax authority.

Example: Purchasing for Nonstock Items - Three-Way Voucher Match

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Purchasing for Nonstock Items - Two-Way Voucher Match

When you use two-way voucher matching, the system does not use the Received Not Vouchered accounts because you do not enter purchase order receipts; you enter the purchase order and create the voucher. When the system creates the voucher, it does not include the use tax in the gross amount of the voucher, nor does it include it in the amount of the expense distribution. The system records the tax in a separate account that is offset when you remit the tax to the tax authority.

Example: Purchasing for Nonstock Items - Two-Way Voucher Match

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Use Tax (U) - Voucher Entry

When you enter a voucher with use tax, the system calculates the tax amount and creates a separate entry to the Use Tax Payable account when you post the transaction. You offset this account when you pay the tax authority.

This example displays the AAIs that the system uses and the tables and accounts that the system updates when you enter and post a voucher that has a taxable amount of 1,000 USD with a 10 percent use tax rate.

Example: Voucher Entry

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

VAT Tax (V) - Purchase Order to Voucher

When you enter a purchase order with value-added tax (VAT) (tax explanation code V), the system calculates the tax amount and makes a separate entry to the general ledger when you post the transaction.

The examples that follow display the AAIs that the system uses and the tables and accounts that the system updates when you run the program specified. All of the examples are for a purchase order in the amount of 1,000 USD with a 10 percent VAT tax rate. The system was set up to create the journal entries in detail.

Purchasing for Stock Items - Three-Way Voucher Match

When you purchase for stock, you must use three-way voucher matching. When you enter the purchase order receipt, the system does not accrue the tax; tax is recorded in the Received Not Vouchered Tax account only, and then is offset when the system creates the voucher. When you post the voucher, the system records the tax in the VAT recoverable tax account. Rather than pay a tax authority, you pay the seller (supplier) for the amount of the goods plus tax and recover the tax amount from the tax authority later.

Example: Purchasing for Stock Items - Three-Way Voucher Match

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Purchasing for Nonstock Items - Three-Way Voucher Match

When you purchase for a nonstock item, you can use either two-way or three-way voucher matching. When you use three-way voucher matching and enter the purchase order receipt, the system records the tax in the Received Not Vouchered Tax account, which is offset when the system creates the voucher. When you post the voucher, the system records the tax in the VAT Recoverable Tax account. Rather than pay a tax authority, you pay the supplier for the amount of the goods plus tax and recover the tax amount from the tax authority later.

Example: Purchasing for Nonstock Items - Three-Way Voucher Match

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Purchasing for Nonstock Items - Two-Way Voucher Match

When you use two-way voucher matching, the system does not use the Received Not Vouchered accounts because you do not enter purchase order receipts; you enter the purchase order and create the voucher. When the system creates the voucher, it includes the VAT tax in the gross amount of the voucher, but not in the expense distribution. When you post the voucher, the system records the tax in the VAT Recoverable tax account. Rather than pay a tax authority, you pay the supplier for the amount of the goods plus tax and recover the tax amount from the tax authority later.

Example: Purchasing for Nonstock Items - Two-Way Voucher Match

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

VAT Tax (V) - Sales Order to Invoice

When you enter a sales order with VAT tax (tax explanation code V) and run Update Customer Sales (R42800), the system uses distribution AAIs to record the Cost of Goods (COG) Sold and Inventory accounts. Although the VAT amount appears on the sales update report, the system does not record it in the VAT Payables account until you post the invoice. You offset the VAT Payables account when you pay the tax authority.

This example displays the AAI that the system uses and the tables and accounts that the system updates when you run the specified program. The example is for a sales order in the amount of 1,000 USD with a 10 percent VAT tax rate.

Example: Sales Order to Invoice

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

VAT Tax (V) - Voucher and Invoice Entry

When you enter a voucher or invoice with VAT tax, the system calculates the tax amount and creates a separate entry to the general ledger when you post the transaction. In accounts payable, you offset the VAT Recoverable Tax account when you receive payment from the tax authority. In accounts receivable, you offset the VAT Payables account when you pay the tax.

This example displays the AAI that the system uses and the tables and accounts that the system updates when you enter and post a voucher or invoice. The examples are for a taxable amount of 1,000 USD with a 10 percent VAT tax rate.

Example: Voucher Entry

Example: Invoice Entry

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

VAT + Sales Tax (C) - Purchase Order to Voucher

When you enter a purchase order using tax explanation code C for VAT + sales tax, the system calculates the tax amount and makes a separate entry to the general ledger for the VAT portion of the tax when you post the transaction.

The examples that follow display the AAIs that the system uses and the tables and accounts that the system updates when you run the program specified. All of the examples are for a purchase order in the amount of 1,000 USD with a 7 percent VAT and 3 percent sales tax rate. The system was set up to create the journal entries in detail.

Note. If you use tax-on-tax calculations, which you specify in the tax rate/area by activating the Compound Tax field, the system uses these formula to calculate the tax amount:

(Taxable + VAT) x sales tax rate = tax

(1,000 + 70) x 03 = 32.10

Purchasing for Stock Items - Three-Way Voucher Match

When you enter the purchase order receipt, the system records the sales tax in two general ledger accounts: Purchase Tax Accrual and Received Not Vouchered Tax. When the system creates the voucher, it offsets the Received Not Vouchered Tax account. You use the Purchase Tax Accrual account to track the sales tax portion of the item. You do not remit sales tax to a tax authority because the seller (supplier) pays it. The gross amount of the voucher includes both the sales and VAT taxes; the GL distribution includes the goods + sales tax only. When you post the voucher, the system records the VAT in the VAT Recoverable Tax account. Rather than pay a tax authority, you pay the seller (supplier) for the amount of the goods plus VAT and recover the VAT amount from the tax authority later.

Example: Purchasing for Stock Items - Three-Way Voucher Match

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Purchasing for Nonstock Items - Three-Way Voucher Match

When you purchase for a nonstock item, you can use either two-way or three-way voucher matching. When you use three-way voucher matching and enter the purchase order receipt, the system records the sales tax in the Received Not Vouchered Tax account, which is offset when the system creates the voucher. When the system creates the voucher, it includes both the sales and VAT tax amounts in the gross amount, but only the sales tax in the expense distribution. When you post the voucher, the system records the VAT in the VAT Recoverable Tax account. Rather than pay a tax authority, you pay the supplier for the amount of the goods plus VAT and recover the VAT amount from the tax authority later.

Example: Purchasing for Nonstock Items - Three-Way Voucher Match

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Purchasing for Nonstock Items - Two-Way Voucher Match

When you use two-way voucher matching, the system does not use the Received Not Vouchered accounts because you do not enter purchase order receipts; you enter the purchase order and create the voucher. When the system creates the voucher, it includes both the sales and VAT tax amounts in the gross amount of the voucher, but only the sales tax in the expense distribution. When you post the voucher, the system records the VAT in the VAT Recoverable Tax account. Rather than pay a tax authority, you pay the supplier for the amount of the goods plus VAT and recover the VAT amount from the tax authority later.

Example: Purchasing for Nonstock Items - Two-Way Voucher Match

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

VAT + Sales Tax (C) - Sales Order to Invoice

When you enter a sales order using tax explanation code C for VAT + sales tax and then run Update Customer Sales (R42800), the system uses distribution AAIs to record the Store Sales, Tax Liability, Cost of Goods (COG) Sold, and Inventory accounts. Although the VAT amount appears on the sales update report, the system does not record it in the VAT Payables account until you post the invoice. You offset the VAT Payables account when you pay the tax authority.

This example displays the AAI that the system uses and the tables and accounts that the system updates when you run the specified program. The example is for a sales order in the amount of 1,000 USD with a 7 percent VAT and 3 percent sales tax rate.

Example: Sales Order to Invoice

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Note. If you use tax-on-tax calculations, which you specify in the tax rate/area by activating the Compound Tax field, the system multiplies the sales tax rate by the VAT tax rate and adds the amount to the sales tax. In this example, the sales tax would be 30.21 {30 + [(.03 x .07) x 100] = 30.21} if the tax rate/area was set up for tax-on-tax.

VAT + Sales Tax (C) - Voucher and Invoice Entry

When you enter a voucher or invoice using tax explanation code C for VAT + sales tax, the system calculates the sales tax amount but does not create a separate entry to the general ledger. For vouchers, the sales tax is part of the expense, so you do not need to enter the tax in a specific account. For invoices, however, you might want to track the sales tax in a separate account because you must pay it. In this instance, you would need to subtract the sales tax amount from the revenue and enter it separately. The system records the VAT amount when you post the transaction. In accounts payable, you offset the VAT Recoverable Tax account when you receive payment from the tax authority. In accounts receivable, you offset the VAT Payables account when you pay the tax.

This example displays the AAI that the system uses and the tables and accounts that the system updates when you enter and post a voucher or invoice. The examples are for a taxable amount of 1,000 USD with a 7 percent VAT and 3 percent sales tax rate.

Example: Voucher Entry

Example: Invoice Entry

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Note. If you use tax-on-tax calculations, which you specify in the tax rate/area by activating the Compound Tax field, the system uses this formula to calculate the tax amount:

(Taxable + VAT) x sales tax rate = Tax

(1,000 + 70) x .03 = 32.10

VAT + Use Tax (B) - Purchase Order to Voucher

When you enter a purchase order using tax explanation code B for VAT + use tax, the system calculates the tax amount and makes two entries to the general ledger when you post the transaction: one for the use portion of the tax and one for the VAT portion of the tax.

The examples that follow display the AAIs that the system uses and the tables and accounts that the system updates when you run the program specified. All of the examples are for a purchase order in the amount of 1,000 USD with a 7 percent VAT and 3 percent use tax rate. The system was set up to create the journal entries in detail.

Note. If you use tax-on-tax calculations, which you specify in the tax rate/area by activating the Compound Tax field, the system uses this formula to calculate the tax amount:

(Taxable + VAT) x use tax rate = Tax

(1,000 + 70) x .03 = 32.10

Purchasing for Stock Items - Three-Way Voucher Match

When you purchase for stock, you must use three-way voucher matching. When you enter the purchase order receipt, the system records the tax in two general ledger accounts: Purchase Tax Accrual and Received Not Vouchered Tax. When the system creates the voucher, it offsets the Received Not Vouchered Tax account and records the tax in the Purchase Tax Accrual asset account only for tracking purposes. When you post the voucher, the system records the tax in the VAT Recoverable Tax and Use Tax Payable accounts. When you pay the tax authority, you enter a voucher that offsets the Use Tax Payable account.

Example: Purchasing for Stock Items - Three-Way Voucher Match

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Purchasing for Nonstock Items - Three-Way Voucher Match

When you purchase for a nonstock item, you can use either two-way or three-way voucher matching. When you use three-way voucher matching and enter the purchase order receipt, the system records the tax in the Received Not Vouchered Tax account, which is offset when the system creates the voucher. The system includes the VAT tax only in the gross amount of the voucher (not the use tax), but includes only the use tax in the expense distribution. The system records the tax in a separate account that is offset when you remit the tax to the tax authority.

Example: Purchasing for Nonstock Items - Three-Way Voucher Match

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Purchasing for Nonstock Items - Two-Way Voucher Match

When you use two-way voucher matching, the system does not use the Received Not Vouchered accounts because you do not enter purchase order receipts; you enter the purchase order and create the voucher. The system includes the VAT tax only in the gross amount of the voucher (not the use tax), but includes only the use tax in the expense distribution. The system records the tax in a separate account that is offset when you remit the tax to the tax authority.

Example: Purchasing for Nonstock Items - Two-Way Voucher Match

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

VAT + Use Tax (B) - Voucher Entry

When you enter a voucher using tax explanation code B for VAT + use tax, the system calculates the use tax amount and includes it in the expense distribution. When you post the voucher, the system creates entries to the:

• Use Tax Payable account, which you offset when you pay the tax authority

• VAT Recoverable Tax account, which you offset when you receive payment from the tax authority

This example displays the AAI that the system uses and the tables and accounts that the system updates when you enter and post a voucher. The example is for a taxable amount of 1,000 USD with a 7 percent VAT and 3 percent use tax rate.

Example: Voucher Entry

* DM - AAI = Distribution/Manufacturing AAI (F4950); FIN - AAI = Financial AAI (F0012)

Note. If you use tax-on-tax calculations, which you specify in the tax rate/area by activating the Compound Tax field, the system uses this formula to calculate the tax amount:

(Taxable + VAT) x use tax rate = Tax

(1,000 + 70) x .03 = 32.10

Tax Exempt (E)

If you want to make a purchase or sales order line item or a voucher or invoice pay item, tax exempt, you use tax explanation code E. When you use tax explanation code E, the system maintains the tax explanation code and tax rate/area values, but removes the taxable and tax amounts from the voucher or invoice.

You must have the AAI for PT set up to enter tax-exempt purchase orders or vouchers. You must have the AAI for RT set up to enter tax-exempt sales orders or invoices.

If you set the processing option in the General Ledger Post Report program (R09801) to update the Taxes (F0018) table for all tax explanation codes, tax-exempt transactions are excluded.

Common Fields Used in This Chapter

Setting Up Tax Authorities

Tax authorities are government agencies that assess and collect taxes. For tracking and reporting purposes, the organization must set up an address book record for each tax authority to which it remits taxes. If you want, you can set up a user-defined code for a new search type, such as TAX, in UDC (01/ST) that you can assign to tax authority address book records to differentiate them from other address book records.

Note. Ensure that the self-service processing option is not activated for the Address Book program (P01012) using the Tax Authorities option on the Tax Processing and Reporting menu (G0021); otherwise, you cannot add new tax authorities (address book records).

See Also

Entering Address Book Records

Setting Up Tax UDCs

Many fields throughout JD Edwards EnterpriseOne software accept only user-defined codes. You can customize the system by setting up user-defined codes that meet the specific needs of the business environment.

Note. The setup for many countries for which JD Edwards EnterpriseOne software processes taxes requires that you enter values for country-specific UDCs.

See Getting Started With Country-Specific Setup and Processes for Asia and Australia.

See Getting Started With Country-Specific Setup and Processes for the Americas.

See Getting Started With Country-Specific Setup and Processes for Europe.

Tax ID Validation (70/TI)

To validate tax identification numbers that you set up in the JD Edwards EnterpriseOne Address Book system according to the country in which it is used, you must set up the country codes in UDC 70/TI.

This table displays examples of country codes set up in UDC 70/TI:

To activate tax ID validation for a specific country code, enter 1 in the Special Handling field for that country code. To disable tax ID validation for a specific country code, remove the 1 from the Special Handling field.

To activate tax ID validation for a country code that is not listed in UDC table (70/TI) or to change the meaning of an existing country code, complete the fields as:

1. Enter the country code in the Codes field.

   The country code must also be set up in the Country Codes (00/CN) UDC table.

2. Enter the standard two-digit ISO code for that country in the Description 02 field.

   The two-digit ISO code is required in the Description 02 field to cross-reference the new country code with the country code that is hard-coded in the system.

   For example, if you use DE for Denmark, enter DN (the two-digit ISO code for Denmark) in the Description 02 field for the DE country code. The system then validates tax IDs that are entered with the country code DE according to Danish, not German, specifications.

3. Enter 1 in the Special Handling field.

To activate tax ID validation for the default (blank) country code, complete the fields as described, but leave the Codes field blank.

For example, if you use a blank country code to mean Denmark, enter DN (the two (2) digit ISO code for Denmark) in the Description 02 field for the blank country code.

Setting Up Tax Rules by Company

This section provides an overview of tax rules and discusses how to set up tax rules by company.

Understanding Tax Rules by Company

You set up tax rules so that the system can calculate any applicable taxes when you enter transactions with taxes. You use the Tax Rules (P0022) program to define tax rules differently by company and by system. The system uses these rules to:

• Establish tolerance limits on changes that you make to the tax amount when you use VAT tax explanation codes (V, C, and B).

• Display a warning message (or reject a transaction) whenever you enter a tax amount that differs from the system-calculated tax.

• Determine whether transaction amounts should be calculated on the gross amount or the gross amount less the discount amount.

• Determine whether discount amounts should be calculated on the gross amount (including tax) or the net amount (excluding tax).

• Determine whether taxes are calculated for sales orders at the order or detail level.

• Allow taxes to be understated.

  Note. If you do not set up rules for a specific company, the system uses the rules that you define for company 00000. If you do not set up rules for company 00000, the system uses only these default rules:
  
  Tolerance limits are set to zero.
  
  Tax is calculated on gross including discount.

When you set up tax rules for the JD Edwards EnterpriseOne Accounts Payable system, you also set up rules for the JD Edwards EnterpriseOne Procurement system. When you set up tax rules for the JD Edwards EnterpriseOne Accounts Receivable system, you also set up rules for the JD Edwards EnterpriseOne Sales Order Management system.

The tax rules that you set up for the system consist of tolerance ranges and calculation rules. Not all of the tax rules apply to all systems.

Tolerance Rules

Tolerance rules specify the amount of variance that can exist between the amount of tax that you enter for a transaction and the tax amount that the system calculates. When you enter a tax amount that differs from the system-calculated tax amount, the system automatically issues a warning message for all tax types except VAT.

For VAT taxes, the system uses the tolerance rules that you set up to determine when to issue a warning or error message. The system does not issue a warning message until the difference between the tax amount that you enter and the tax amount that they system calculates exceeds the tolerance limit established for a warning. By setting up tolerance information, you control the type of message that the system issues.

Tolerance rules:

• Apply to both understated and overstated amounts.

• Apply only to VAT taxes and can be defined as either a percentage or amount.

  For accounts receivable, the tolerance rules that you define do not apply to VAT taxes unless you also activate the option to understate taxes.

For example, you might specify a tax rule with a tolerance range by amounts as:

• Tolerance amount for warning is 2.

• Tolerance amount for error is 10.

To determine the tax amount, the system multiplies the taxable amount by the tax rate. If the taxable amount for a transaction is 1000 and the tax rate is 10 percent, the system calculates a tax amount of 100. Based on the tolerance range, the system determines the range for warning or error as:

Calculation Rules for Discount and Tax Amounts

When you enter transactions with discounts and taxes, you must specify how you want the system to calculate the discount and tax amounts. Calculation rules specify which method to use for calculating discount and tax amounts when both are specified. The rules control how the system validates the correct tax amount, based on the total amount transaction.

Calculation rules are not displayed if you select the JD Edwards EnterpriseOne General Accounting system.

Examples: Calculation Rules for Taxes

The system calculates gross and discount amounts using the tax rules that you set up. Each of these examples uses a different combination of rules to calculate:

• Tax on gross including or excluding the discount amount

• Discount on gross including or excluding the tax amount

The examples use these amounts:

• Taxable amount: 1,000

• Gross amount: Varies

• Tax rate: 10 percent

• Tax amount: 100

• Discount: 1 percent

Example 1

This table displays how the system calculates the discount, gross, and taxable amounts when the options Calculate Tax on Gross (Including Discount) and Calculate Discount on Gross (Including Tax) are activated.

Example 2

This table displays how the system calculates the discount, gross, and taxable amounts when the options Calculate Tax on Gross (Including Discount) and Calculate Discount on Gross (Excluding Tax) are activated.

Example 3

This table displays how the system calculates the discount, gross, and taxable amounts when the options Calculate Tax on Gross (Excluding Discount) and Calculate Discount on Gross (Including Tax) are activated.

Example 4

This table displays how the system calculates the discount, gross, and taxable amounts when the options Calculate Tax on Gross (Excluding Discount) and Calculate Discount on Gross (Excluding Tax) are activated.

(GBR) Example 5

In Great Britain, you must set the options for the calculation rules as:

• Tax on Gross (Including Discount) - Off

• Discount on Gross (Including Tax) - Off

The system calculates the discount and gross amounts as:

(DEU) Example 6

In Germany, you must set the options for the calculation rules as:

• Tax on Gross (Including Discount) - On

• Discount on Gross (Including Tax) - On

The system calculates the discount and gross amounts as:

Edit Rules

You have only the option to understate tax amounts when you select the JD Edwards EnterpriseOne Accounts Receivable system.

The edit rules activate the tolerance rules for VAT for the JD Edwards EnterpriseOne Accounts Receivable system only. If you do not allow taxes to be understated, the tolerance rules that you set up apply to sales taxes only.

Forms Used to Set Up Tax Rules

Setting Up Tax Rules

Access the Tax Rules Revisions form.

Setting Up AAIs for Taxes

This section provides overviews of setting up AAIs for taxes, including financial AAIs and distribution AAIs.

Understanding AAIs for Taxes

If you are required to collect or pay taxes, you must set up the system so that the tax amounts are applied to the correct general ledger accounts. The system applies tax amounts automatically to the account that you specify in an Automatic Accounting Instruction (AAI).

When you set up AAIs for a specific type of tax, such as VAT, you specify which accounts you want the system to debit and credit for the tax amount. If you pay taxes in multiple currencies, you need to set up tax AAIs for each company.

The financial systems within JD Edwards EnterpriseOne (Accounts Payable, Accounts Receivable, and General Accounting) use different AAIs than the distribution systems within JD Edwards EnterpriseOne (JD Edwards EnterpriseOne Sales Order Management and JD Edwards EnterpriseOne Procurement).

See Also

Setting Up Automatic Accounting Instructions

Setting Up AAIs for Sales Order Management

Understanding Financial AAIs for Taxes

You can enter taxes on invoices, vouchers, journal entries, purchase orders, and sales orders. If you enter VAT or Use taxes, you must set up an AAI to debit or credit the appropriate tax account for each of these systems:

• JD Edwards EnterpriseOne Accounts Payable

• JD Edwards EnterpriseOne Accounts Receivable

• JD Edwards EnterpriseOne General Accounting

• JD Edwards EnterpriseOne Procurement

• JD Edwards EnterpriseOne Sales Order Management

You use the Automatic Accounting Instructions (P0012) program to set up AAIs.

Country-specific setup for AAIs for taxes exists for Argentina, Brazil, Chile, and Russia.

See Setting Up AAIs for Argentina.

See (CHL and PER) Setting Up AAIs for Chile and Peru.

See Setting Up AAIs for Tax Processing for Brazil.

See Setting Up AAIs for Russian Taxes.

AAI Hierarchy

You can set up the AAI for each company or for company 00000 only. If you do not set up company-specific AAIs, the system uses the AAI that is set up for company 00000. If you do not use a GL offset, the system uses the account associated with the AAI item (PT, RT, GT) only.

If a tax rate area has a GL offset specified, you must set up an AAI with the same GL offset. If the system does not find the PTxxxx, RTxxxx, or GTxxxx, where xxxx is the GL offset specified in the tax rate area, the system returns an error message when you attempt to process the transactions.

You must specify a business unit and object account when you set up tax AAIs for the JD Edwards EnterpriseOne Accounts Payable and JD Edwards EnterpriseOne Accounts Receivable systems. The subsidiary field is optional. For the JD Edwards EnterpriseOne General Accounting system, if you do not specify a business unit for the tax AAI, the system uses the business unit from the account entered on the journal entry.

This table displays the hierarchy that the system uses to determine the account to which tax amounts are posted.

VAT Tax AAIs for the JD Edwards EnterpriseOne Accounts Payable, JD Edwards EnterpriseOne Accounts Receivable, and JD Edwards EnterpriseOne General Accounting Systems (PTxxxx, RTxxxxx, GTxxxx)

When you post a transaction that has VAT taxes, the system uses an AAI to locate the general ledger account to use to post the tax amount. Because you might require different accounts for different tax authorities, you can specify a GL offset value for each tax authority that you set up in the tax rate/area, and then set up a corresponding AAI that includes that value. The GL offset can be up to four characters in length and it follows the AAI item. Examples are PTVATA, RTVATB, and GTTXTX. Specifying a value in the GL Offset field enables you to direct VAT tax amounts to different accounts by offset (or tax authority) for each company and differentiates VAT tax accounts from use tax accounts in the JD Edwards EnterpriseOne Accounts Payable system.

Note. The system uses the GTxxxx AAIs when the journal entry with VAT transaction is entered, not when it is posted.

VAT Tax AAIs for JD Edwards EnterpriseOne Procurement (PTVATD)

The JD Edwards EnterpriseOne Procurement system uses the same AAI item as the JD Edwards EnterpriseOne Accounts Payable system (PT), except when you have a purchase order with retainage and you defer VAT. In this case, when you match the voucher to the receipt using the Voucher Match program (P4314), the system uses the AAI item PTVATD to locate the account for the deferred VAT. The system uses this AAI only when:

• The processing option (Retainage tab) for the Voucher Match program (P4314) is set to apply tax to the retained amount.

• You use a tax type of C or V.

When you release retainage, this AAI reverses debits and credits with the VAT Payables (PCVATP) AAI.

If you do not set up this AAI, the system returns an error.

Use Tax AAI (PT) - JD Edwards EnterpriseOne Accounts Payable and JD Edwards EnterpriseOne Procurement Systems

Use taxes (tax explanation code U and B) do not use a GL offset to specify a tax account; the system always uses PT (blank). You can set up the AAI for each company or for company 00000 only. If you do not set up company-specific AAIs, the system uses the AAI set up for company 00000.

Unlike VAT taxes, you can specify use tax accounts by tax rate/area. Instead of using multiple AAIs to specify different tax accounts, you set up different tax accounts for each tax rate/area by defining the subsidiary portion of the account as the tax rate/area. For example, if the tax account were 1.4433 and the tax rate/area were ONT (for Ontario), you would set up 1.4433.ONT in the F0901 table. Thus, you would have a unique account number for each tax rate/area.

When you set up the AAI for PT, you do not specify a subsidiary account; you specify the business unit and object account only. The system ignores the subsidiary account if one exists. When you post the voucher, the system looks for the account number specified in the AAI in conjunction with the tax rate/area specified on the voucher. If the account number exists, the system uses it. If the account number, including the tax rate/area, does not exist, the system uses the account number. For example, if you set up PT for 1.4433 and enter tax rate/area DEN on the voucher, the system searches for 1.4433.DEN. If the system cannot locate this account number, it uses 1.4433.

Understanding Distribution AAIs for Taxes

Transactions in the JD Edwards EnterpriseOne Sales Order Management and JD Edwards EnterpriseOne Procurement systems use both distribution and financial AAIs. The distribution AAIs are set up in multiple tables, each of which applies to a certain type of transaction. Not all transactions with taxes use the distribution AAIs. you use the Distribution AAIs (P40950) program to set up AAIs for the distribution systems.

This table displays the distribution AAI tables that you must set up to enter purchase orders and sales orders with taxes for the specified tax explanation code. Any other tax explanation codes that you enter on the order revert to the financial AAIs (RT, PT, GT).

Note. The system also uses the distribution AAIs for tax explanation codes B and C for the sales and use portion of the tax amount.

Each AAI table enables you to set up different general ledger accounts based on the company, document type, and GL category code (offset) that you enter. You enter the same value in the GL Cat field (data item GLPT) for the AAI that you have set up in the GL Offset field in the tax rate/areas. For example, if you had a tax rate/area set up for CO that includes a GL offset TXTX, and you had another tax rate/area ONT that includes a GL offset TXTY, you would set up two distribution AAIs. This example illustrates how the distribution AAIs correlate to the tax rate/area.

Tax Rate Area Setup

This table describes the Tax Rate Area, GL Offset, and Tax Rate.

Distribution AAI Set Up

This table describes the Distribution AAI Set Up for AAI Table 4250.

Note. You can define a flexible account number for the AAI table 4250. The system searches for the account number in the F4096 based on the AAI table. If the AAI table is not defined to use flexible accounts, the system uses the account number that is set up in the 4095.

Setting Up Tax Rate Areas

This section provides overviews of tax rate areas and nonrecoverable VAT, lists prerequisites, and discusses how to:

• Set processing options for Tax Rate/Areas (P4008).

• Set up tax rate/areas.

Understanding Tax Rate Areas

To calculate and track the different taxes that you pay to suppliers or for customers, you must set up tax rate areas. Each tax area is a physical, geographic area, such as a state, province, or county. Different tax authorities assess a variety of taxes for each geographic area. Additionally, each authority within a tax area can have a different tax rate.

When you set up tax rate areas, you must specify effective dates. The system does not check for duplicate tax rate and area information, which means that you can set up different tax rates and effective date ranges for the same tax rate and area. The system checks for overlapping effective date ranges. When an overlap exists, the system issues an error.

The Tax Rates/Areas (P4008) program also provides features for special situations. For example, you can specify whether tax is calculated as tax-on-tax, whether a portion of the tax is nonrecoverable (available for input credits), and whether maximum unit cost is associated with a particular item.

This diagram illustrates how some tax areas could be organized:

Tax Rate Areas

The three circles represent three tax authorities. The seven numbered areas represent tax areas.

Notice that tax authority jurisdiction can overlap and that a tax area can be assessed taxes by one or more tax authorities. The tax rate for a tax authority does not vary from one tax area to another. Tax authority A assesses a 3 percent tax in tax areas 2, 3, 5, and 6.

For each tax area, however, the total tax burden can vary. It is the cumulative effect of multiple tax authorities for a single tax area that causes the tax burden to vary from one tax area to another. For example, the businesses located in tax area 5 must remit tax to only one tax authority (Tax Authority A for 3 percent). Businesses in tax area 2 remit taxes to two tax authorities (Tax Authorities A for 3 percent and B for 2 percent), and businesses in tax area 3 remit taxes to all three tax authorities.

You can run a report to review all of the tax areas that are set up.

Tax Rate Areas for Items

You can specify tax information for an item or group of items. To specify tax information for an item, set the processing option to validate information against the Item Branch File (F4102) table and enter the item number in the tax rate/area.

To specify a tax rate for an item group, enter one of the valid options in the Sales Taxable Y/N field on the Item Branch/Plant Info. form in the Item Branch/Plant (P41026) program. Options 3 through 8 are for grouping items together based on the tax rate. You set up the tax rate by area for one of the options and then specify the option for like items on the Item Branch/Plant Info. form.

See Setting Up a Base Pricing Structure.

Revising Tax Rate Areas

You can revise any of the information for the tax rate/area except the expiration date. If you need to extend the expiration date of a tax rates area, you must enter a new tax rate/area record.

Understanding Nonrecoverable VAT

When they sell their goods, most countries that pay VAT fully recover the amount of VAT that they paid. In other words, VAT paid in accounts payable is offset against any VAT collected in accounts receivable to reduce the amount owed to the government or, in some cases, to generate a tax rebate. Exceptions to this rule might include expenses such as meals and entertainment, which might bee only 50 percent recoverable.

When you cannot recover all of the VAT that you pay, you must set up the tax rate area to indicate the percentage of tax that is nonrecoverable (or not available for credit). When you use the tax rate area in a transaction, the system credits the VAT account for the amount that can be recovered only. The system does not create a separate entry to an account for the nonrecoverable amount; however, it does store the amount in the Accounts Payable Ledger (F0411) and Customer Ledger (F03B11) tables.

The system only recognizes nonrecoverable VAT when using type explanation codes V, B, and C.

Example: Using Nonrecoverable VAT

When you set up a tax rate area that has nonrecoverable VAT, you enter the percent of the nonrecoverable tax on a separate line. Although the system requires a tax authority, it does not use the tax authority for reporting. When you specify a nonrecoverable percent, such as 50, the percent applies to the total tax on the tax rate area. However, if you set up the tax rate area for multiple tax authorities, the system applies the nonrecoverable tax to the first tax authority defined.

For example, this tax rate/area has two tax authorities specified, as well as a nonrecoverable percent.

Tax Rate/Area Revisions form

When you enter a voucher or invoice and use this tax rate area (ONT), the system will apply the entire 50 percent to the account associated with the GL Offset GST.

In this example, the AAIs associated with the tax rate area point to these accounts:

• 1.4444 for RTGST

• 1.4445 for RTPST

If you enter an invoice for a taxable amount of 1,000 USD, the system calculates the tax amount as 150 USD (1,000 x.15) and the gross amount as 1,150 (1,000 + 150). When you post the invoice, the system creates these entries:

*Normally, the entry to VAT Payable is a credit, but because the system calculates a - 5 (credit), it debits the account.

Prerequisites

Before you complete the tasks in this section:

• Set up the tax authorities in the address book.

• Set up the necessary tax AAIs.

Forms Used to Set Up Tax Rate Areas

Setting Processing Options for Tax Rate/Areas (P4008)

Processing options enable you to specify the default processing for programs and reports.

Display

Edits

Setting Up Tax Rate Areas

Access the Tax Rate/Area Revisions form.

Setting Up Default Values for Taxes

This section provides an overview of the default values that you can set up for taxes and discusses how to:

• Set up default tax information for the business unit.

• Set up default tax information for the supplier record.

• Set up default tax information for the customer record.

Understanding Default Values for Taxes

When you enter transactions with taxes, you can enter the tax information on the transaction or set up default values that the system uses during the entry process. Default tax values include the tax rate area and tax explanation code, and can be set up in the customer or supplier record or in the business unit record (tax rate area only). Regardless of whether you establish default values, you can override the tax information when you enter the transaction.

This table shows where the system retrieves the default tax rate area and tax explanation code from for each type of transaction that you enter:

Forms Used to Set Up Default Tax Information for the Business Unit, Supplier, and Customer Records

Validating Tax ID Numbers

This section provides overviews of the tax ID validation process, how to activate tax IDs, and overriding tax IDs.

See Also

How to Validate Tax IDs in Latin American Countries

Understanding Tax ID Validation

A tax ID is the identification number that you use when you report information to the various tax authorities. For every transaction that can occur with a company, a customer, or a supplier, you must enter an associated tax identification number. Tax IDs are also called VAT codes, VAT registration numbers, or fiscal codes.

To export goods free of value-added tax (VAT), you must have the tax ID or VAT registration number of customers in other EU (European Union) countries, and you must send your own tax ID or VAT registration numbers to suppliers. The length and format of these numbers vary by country.

When you create an address book record for each company, customer, or supplier, enter the tax ID number in the Tax ID field on the Address Book Revision form. To ensure that the tax ID that you enter is checked for authenticity, enter a country code from UDC table (00/CN) in the Country field on the Mailing tab on the Address Book Revision form. When a country code is on the Mailing tab, the system validates tax IDs for that country.

The system only validates the tax ID if the country code that you have specified is set up and activated for validation in UDC table (70/TI).

(ESP) The system validates foreign and domestic CIF (companies) and NIF (individuals).

Note. The length of Spanish tax IDs is nine characters.

Example of Tax ID or VAT Registration Numbers by Country

These examples display the tax ID or VAT number that the system validates according to the country.

(ITA) Tax ID or VAT Registration Number for Italy

Italy example:

Tax ID or VAT Registration Number for Italy

(AUT) Tax ID or VAT Registration Number for Austria

Austria example:

Tax ID or VAT Registration Number for Austria

(NLD) Tax ID or VAT Registration Number for the Netherlands

Netherlands example:

Tax ID or VAT Registration Number for the Netherlands

(DEU) Tax ID or VAT Registration Number for Germany

Germany example:

Tax ID or VAT Registration Number for Germany

(GBR) Tax ID or VAT Registration Number for the United Kingdom

Great Britain example:

Tax ID or VAT Registration Number for the United Kingdom

(SWE) Tax ID or VAT Registration Number for Sweden

Sweden example:

Tax ID or VAT Registration Number for Sweden

(FIN) Tax ID or VAT Registration Number for Finland

Finland example:

Tax ID or VAT Registration Number for Finland

(DNK) Tax ID or VAT Registration Number for Denmark

Denmark example:

Tax ID or VAT Registration Number for Denmark

Understanding How to Activate Tax ID Validation

You activate tax ID validation routines for specific countries by setting up a Localization Country Code in the user profile and by setting up country codes in UDC (70/TI).

See Setting Up Tax UDCs.

User Display Preferences

Completing the Localization Country Code field on the User Profile Revisions form causes the system to search for a tax ID validation routine, but the validation routine to use is not specified. For example, if you specify UK in the Localization Country Code field, you can still validate tax IDs for other countries. The system uses the value in the Country field on the Mailing tab on the Address Book Revision form to determine which validation to use for each address book record.

Understanding How to Override Tax ID Validation

You activate tax ID validation routines for specific countries by setting up country codes in the Tax ID Validation UDC table (70/TI). When you set the Special Handling code to 1 for a specific country, the system validates the Tax ID for that country.

(ESP, FRA, ITA) For France, Italy, and Spain, you can override the tax validation routine on a single customer/supplier basis. When you override the tax validation routine for a specific customer or supplier, the system does not validate the Tax ID for the specific customer or supplier, but it continues to validate the Tax ID for all of the other customers and suppliers in the country.

(ESP, FRA, ITA) You override the tax validation routine for these countries by entering 0 (zero) in the Person/Corp field for the supplier or customer. The Person/Corp field is on the Address Book Revisions form in the Address Book (P01012) program.

(BEL) In Belgium, the VAT ID might not be known for some customers, such as recognized healthcare providers. You can override the tax validation routine for a single customer or supplier by specifying 99_unknown or 99_onbekend in the Tax ID field on the Address Book Revisions form for that customer or supplier.

For other countries, you can override the tax ID validation routine by setting up the codes for that country in UDC (00/CN) and UDC (70/TI), specifying a 1 in the Special Handling field in UDC (70/TI) for one of the codes and not for the other. When you create an address book record for which you want to validate the tax ID, use the country code that has a 1 in the Special Handling field. When you create an address book record for which you do not want to validate the tax ID, use the country code that does not have a 1 in the Special Handling field.

Assigning Tax Information to General Ledger Accounts

This section provides an overview about tax information assigned to the general ledger accounts and discusses how to assign tax information to general ledger accounts.

Understanding Tax Information for General Ledger Accounts

If you track taxes by general ledger account, you must specify that the account is taxable by turning on the Taxable Account option on the account. When you specify that an account is taxable, the system enables you to specify a default tax rate area to use. The system uses the tax rate area for the account on journal entries that are generated automatically or when the corresponding field is left blank on the distribution form of the voucher or invoice and you have specified to track taxes.

Forms Used to Assign Tax Information to General Ledger Accounts

Assigning Tax Information to General Ledger Accounts

Access the Revise Single Account form.

More

Select the More tab.

Setting Up the General Ledger Post Report Program to Update the Tax Information

This section provides an overview of the General Ledger Post program as it relates to updating tax information to the Taxes (F0018) table, and discusses how to run the General Ledger Post program.

Understanding the General Ledger Post Program and Updating Tax Information

To report on tax amounts that you owe or collect, you must update the F0018 table. The system automatically updates the F0018 table when you post invoices, vouchers, and journal entries that have taxes if you set the appropriate processing options for the versions of the General Ledger Post Report program (R09801) that you use to post these transactions.

Note. If you bypass creating invoices when you run the Update Customer Sales program (R42800), the system does not update the Taxes table.

You must update the F0018 table for the system to update the Tax Reconciliation Repository (F0018R) table, which is used for reporting tax information by general ledger account.

The default versions of the General Ledger Post Report program that the system uses are:

• ZJDE0001 (General Ledger Post)

  If you enter journal entries with VAT tax, you must set the processing options for this version in order to update the F0018 table.

• ZJDE0002 (Voucher Post)

  If you enter invoices with taxes, you must set the processing options for this version in order to update the F0018 table.

• ZJDE0006 (Invoice Post)

  If you enter invoices with taxes, you must set the processing options for this version in order to update the F0018 table.

If you use different versions of the General Ledger Post Report program to post transactions with taxes, you must set the processing option for those versions in order to update the F0018 table.

You can update the table for all tax explanation codes, all tax amounts, or tax explanation codes relating to Use and VAT tax only.

Note. If you post transactions with taxes and do not have the processing options set to update the F0018 table, you must manually enter tax information into the F0018 table. You cannot post transactions again to update the table.

See Working with the Taxes Table.

Running the General Ledger Post Program

Use one of these navigations:

Select Journal Entry, Reports, & Inquiries (G0911), Post General Journal.

Select Supplier & Voucher Entry (G0411), Post Vouchers to GL.

Select Customer Invoice Entry (G03B11), Post Invoices to GL.