Adding Transactions to the Taxes Table

Access the Tax File Revisions form.

Document Type

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 value that identifies an account in the general ledger.

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 the system assesses a tax and distributes it 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 that the system uses to assess taxes.

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.