Understanding Batch Journal Entries with VAT

If you use either the Store and Forward or the Batch Journal Entry programs, you might want to process journal entries with VAT taxes. When you process batch journal entries, you must create records in the F0911Z1 table, and then process them using the R0911Z1 program (depending on the menu, this program is referenced as either Journal Entries Batch Processor or Store & Forward Journal Entry Upload). When you run the R0911Z1 program, provided there are no errors, the system updates transactions in the F0911 table.

You can specify to post successfully processed batches automatically by setting a processing option or you can manually post them at a later date. Regardless of whether you select to post transactions automatically, when the system successfully processes the journal entry in the F0911Z1 table and creates it in the F0911 table, it also writes the appropriate records to the F0018 table.

The system processes journal entries with VAT exactly as if you had used the Journal Entry with VAT program (P09106). In addition to the fields required for processing journal entries without taxes, you must complete the fields in this table to process journal entries with taxes:

Field Name	Alias	Type	Length	Values to Enter/Definition
Taxable Amount	AA	Number	15	If you enter the taxable amount, the system calculates the tax and gross amounts based on the tax explanation code and tax rate/area. If you enter the gross amount, the system calculates the taxable and tax amounts based on the tax explanation code and tax rate/area. Note: If you enter any other combination of fields, the system validates the information based on the tax rate/area, tax explanation code, and tax rules that are set up. Tax amounts that you enter must be within the tolerance limits established for the tax rule. If you do not want the system to validate tax amounts that you specify, specify a tolerance of 100 percent or do not set up tax rules.
Gross Amount	AG	Number	15	.
Tax Amount	STAM	Number	15	.
Tax Expl Code 1	EXR1	Alpha	1	Enter a VAT tax explanation code (V, V+ or VT) only. No other values are valid.
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.
Track Taxes	TKTX	Alpha	1	Enter 1 to update tax information to the F0018R table. The account specified must be set up as taxable in the F0901 table or the system changes the Track Taxes field to0 when the journal entry is processed, and does not update the F0018R table.