Fields Required for Processing Tax Information on Batch Invoices and Vouchers

In addition to the fields required for processing invoices and vouchers that do not have taxes, you must complete these additional tax fields in the F03B11Z1 table to process invoices that have taxes and in the F0411Z1 table to process vouchers that have taxes.

Field Name

Alias

Type

Length

Values to Enter/Definition

Taxable Amount

ATXA

Number

15

Enter the amount of the transaction that is taxable. If the total gross amount of the transaction is not taxable, you must enter the nontaxable portion of the transaction in the Non-Taxable field (ATXN). The sum of the Taxable (ATXA), Non-Taxable (ATXN), and Tax Amounts (STAM) fields must equal the gross amount of the transaction.

If you leave the Gross Amount field (AG) blank, the system calculates the gross amount based on the taxable (ATXA) and nontaxable (ATXN) amounts.

Non-Taxable Amount

ATXN

Number

15

Enter the amount of the transaction that is not taxable. The sum of the taxable, nontaxable, and tax amounts must equal the gross amount of the transaction.

Tax Amount

STAM

Number

15

This field identifies the amount of tax that is calculated for the transaction.

If you leave this field blank, the system calculates the tax amount based on values in the Taxable Amount (ATXA), Tax Explanation Code (EXR1), and Tax Rate/Area (TXA1) fields.

Tax Rate/Area

TXA1

Alpha

10

The tax rate/area specifies at what percent the tax is calculated and defines the taxing authority.

The value that you enter in this field must exist in the F4008 table.

Tax Expl Code 1

EXR1

Alpha

1

The value that you enter in this field must exist in UDC 00/EX (Tax Explanation Codes). All values are hard coded to perform tax calculations specific to the setup of the tax rate/area and in conjunction with the tax rules by company.

Service/Tax Date

DSVJ

Date

6

This date corresponds to the effective date used in the Tax Rate Area field (TXA1). Enter the date in the format that the database accepts.

If you leave this field blank, the system uses the value from the GL date.

Alternatively, you can leave this field blank and complete the fields DSVM (mm), DSVD (dd), DSVY (yy), and DSV# (cc) in the month/day/year/century format. Enter the prefix of the year in the Century field (DSV#). For example, enter 19 for 1999, or enter 20 for 2005.