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 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.