Understanding the Process to Update the Taxes Table
This chapter provides an overview of the process to update the Taxes (F0018) table and discusses how:
Add transactions in the Taxes table.
Purge transactions in the Taxes table.
Understanding the Process to Update the Taxes Table
After you generate vouchers and invoices, you must post them to the general ledger to create offsetting entries and to update the Account Balances (F0902) table. Additionally, if the transactions have taxes that you want to reconcile or report on, you must update the Taxes table. The transaction type determines how the system updates the Taxes table:
For invoices and vouchers with taxes, the system updates the Taxes table when you set the appropriate processing option for the General Ledger Post Report program (R09801) for the version that you use.
The system creates one record in the Taxes table for each invoice or voucher pay item that has taxes. When you revise a posted pay item and post the revision, the system generates an additional record in the Taxes table for that pay item and increases the Line Number field incrementally.
For journal entries entered with valued-added tax (VAT), the system updates the Taxes table when the transaction is entered, regardless of whether it is posted.
The system creates one record in the Taxes table for each journal entry line that has taxes. If you revise a journal entry with VAT, the system writes a record for the revision if the journal entry was posted when it was revised. Otherwise, the system changes the information on the existing F0018 record.
Each record in the Taxes table contains fields for each tax authority, tax rate, and tax amount so that when you run reports, the system can provide you with a total tax amount by tax authority.
Adding Transactions in the Taxes Table
This section provides an overview of using the Tax File Revisions (P0018) program and discusses how to add transactions to the Taxes table.
Understanding the Tax File Revisions Program
You use the Tax File Revisions program to review, add, delete, and modify records in the Taxes table. For example, if you did not set the appropriate processing option in the version of the General Ledger Post Report program (R09801) to update the Taxes table, you might need to enter the tax information manually using the Tax File Revisions program. Similarly, you might want to delete a transaction from the table.
The system does not allow revisions to documents that begin with the letter P or R (which are normally used for voucher and invoice transactions). Because you cannot revise invoice or voucher records in the Taxes table, you must either:
Make revisions using the standard entry program, and then post those changes to update the Taxes table.
Add a new transaction to the Taxes table to adjust the tax amount appropriately.
If you revise the taxable or nontaxable amounts of a journal entry and you clear the Tax field, the system recalculates the tax amount.
Note. The system does not update the original transaction with revisions that you make to the transaction in the Taxes table.
Forms Used to Add Transactions to the Taxes Table
|
Form Name |
FormID |
Navigation |
Usage |
|
Work With Tax File |
W0018A |
Tax Processing and Reporting (G0021), Tax File Revisions. |
Review and select tax records. |
|
Tax File Revisions |
W0018C |
Click Add on the Work With Tax File form. |
Add and revise tax records. |
Adding Transactions to the Taxes Table
Access the Tax File Revisions form.
|
Document Type/Number/Company |
Enter a number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, and so on. If you need to add a document for tax explanation code V, the document type, document number, and document company that you specify must exist in the F0911 table. |
|
Order Suffix |
Enter a code that corresponds to the pay item in the JD Edwards EnterpriseOne Accounts Receivable and JD Edwards EnterpriseOne Accounts Payable systems. In the JD Edwards EnterpriseOne Sales Order Management and JD Edwards EnterpriseOne Procurement systems, this code identifies multiple transactions for an original order. For purchase orders, the code is always 000. For sales orders with multiple partial receipts against an order, the first receiver used to record receipt has a suffix of 000, the next has a suffix of 001, the next 002, and so on. |
|
Company |
This field is required. |
|
Account Number |
Enter an account in the general ledger. You can use one of these formats for account numbers: 1: Structured account (business unit.object.subsidiary) 2: 25-digit unstructured number 3: 8-digit short account ID number 4: Speed code. The first character of the account indicates the format of the account number. You define the account format in the General Accounting Constants program (P000909). |
|
Address Number |
Enter a number that identifies an entry in the JD Edwards EnterpriseOne Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location. This field is required. |
|
Tx Ex (tax explanation) |
Enter a user-defined code (00/EX) that controls how a tax is assessed and distributed to the general ledger revenue and expense accounts. This field is required. |
|
Tax Rate/ Area |
Enter a code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter against the F4008 table. The system uses the tax rate/area in conjunction with the tax explanation code and tax rules to calculate tax and GL distribution amounts when you create an invoice or voucher. This field is required. |
|
Tax Point Date |
Enter a date that indicates when you purchased goods or services, or when you incurred a tax liability. |
|
GL Date (general ledger date) |
Enter a date that identifies the financial period to which the transaction is to be posted. The company constants specify the date range for each financial period. You can have as many as 14 periods. Generally, period 14 is used for audit adjustments. The system validates this field for PBCO (posted before cutoff), PYEB (prior year ending balance), PACO (post after cutoff), and WACO (post way after cutoff) messages. This field is required. |
|
Line Number |
Enter a number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns this number, but in some cases you can override it. |
|
Non-Taxable Amount |
Enter the amount upon which taxes are not assessed. This is the portion of the transaction not subject to sales, use, or VAT taxes because the products are tax-exempt or zero-rated. |
|
Taxable Amount |
Enter the amount on which taxes are assessed. This field is required. |
|
Tax |
Enter the amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). Although you can enter the tax amount, the system might return an error if the amount that you enter differs from the system-calculated amount. For error-free processing, leave this field blank and let the system assign the amount. |
|
Extended Cost |
Enter the invoice (gross) amount for account receivable and account payable. For sales orders and purchase orders, the unit cost times the number of units. Enter the sum of the taxable and tax amounts. This field is required. |
Purging Transactions in the Taxes Table
Periodically, you might want to purge the F0018 table to remove records that you no longer require. When you run the Tax File Purge (R0018PURGE) program, the system removes all records from the Taxes table based on the data selection that you enter.
This section discusses how to purge the tax table.
Purging Transactions in the Taxes Table
Select Tax Processing and Reporting (G0021), Tax File Purge.