This chapter contains the following topics:
After you generate vouchers and invoices, you must post them to the general ledger to create offsetting entries and update the Account Balances table (F0902). Additionally, if the transactions have taxes that you want to reconcile or report on, you must update the Taxes table (F0018). The transaction type determines how the system updates the F0018 table:
For invoices and vouchers with taxes, the system updates the F0018 table when you set the appropriate processing option in the General Ledger Post Report program (R09801).
The system creates one record in the F0018 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 F0018 table when you enter the transaction, regardless of whether it is posted.
The system creates one record in the F0018 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 F0018 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.
This section provides an overview of the Tax File Revisions (P0018) program and discusses how to add transactions to the Taxes table.
Use the Tax File Revisions program to review, add, delete, and modify records in the F0018 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 F0018 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 F0018 table, you must either:
Make revisions using the standard entry program, and then post those changes to update the F0018 table.
Add a new transaction to the F0018 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 F0018 table. |
| Form Name | Form ID | Navigation | Usage |
|---|---|---|---|
| Work With Tax File | W0018A | Tax Revisions (G00216), Tax File Revisions. | Review and select tax records. |
| Tax File Revisions | W0018C | Click Add on the Work With Tax File form. | Add transactions to the Taxes table. |
Access the Tax File Revisions form.
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.
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.
This field is required.
Enter value that identifies an account in the general ledger.
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.
Enter a user-defined code (00/EX) that controls how the system assesses a tax and distributes it to the general ledger revenue and expense accounts.
This field is required.
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.
Enter a date that indicates when you purchased goods or services, or when you incurred a tax liability.
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.
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.
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.
Enter the amount that the system uses to assess taxes.
This field is required.
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.
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.
Periodically, you might want to purge the F0018 table to remove records that are no longer required. Use the Tax File Purge (R0018PURGE) program remove records from the F0018 table based on the data selection.
Select Tax Processing and Reporting (G0021), Tax File Purge.