1. Tax Processing Implementation Guide
  2. Understanding Programs that Update the Account Ledger Table (F0911)

Understanding Programs that Update the Account Ledger Table (F0911)

JD Edwards EnterpriseOne software has many invoice and voucher programs that integrate with the F0911 table. If you track taxes by tax rate/area, the system balances G/L distribution records in the F0911 table based on the invoice or voucher and tax information (tax rate area, tax explanation code and tax item number).

If you track taxes by pay item and G/L account, the system balances G/L distribution records in the F0911 table based on the invoice or voucher pay item and tax information. When you enter invoices, the system updates the values from the Pay Item, Tax Rate Area, Tax Explanation Code, and Tax Item Number fields from the F03B11 or F03B11Z1 tables to the F0911 or F0911Z1 tables. When you enter vouchers, the system updates the values from the pay item, tax rate area, tax explanation code, and tax item number fields from the F0411 or F0411Z1 tables to the F0911 or F0911Z1 tables.

When you use the following JD Edwards EnterpriseOne programs, the system automatically populates the F0911 table:

System

Programs

Accounts Receivable

  • Speed Invoice Entry (P03B11SI)

  • AR Delinquency Fees (R03B22)

  • Credit Reimbursement (R03B610)

  • AR/AP Netting (P03B455)

Accounts Payable

  • A/P Speed Voucher Entry (P0411SV)

  • Multi-Voucher Entry (P041017)

  • Multi Company - Single Supplier (P041016)

  • Store and Forward Upload (R0411Z1)

  • Store and Forward Voucher Batch Processor (R04110Z2)

  • Inbound EDI Voucher Edit/Create (R47041)

  • AR/AP Netting (P03B455)

Procurement

Voucher Match (P4314)

Distribution

Sales Update (R42800)

Advanced Pricing

Ship and Debit Claims (P4576)

Expense Management

Expense Report Reimbursement (R20110)

Real Estate Management

  • G/L Transaction Generation (R15199)

  • Revenue Fee Generation (R15105)

Contract/Service Billing

Journal Edit Register (R48300)

Payroll

Payroll Voucher Upload (R07411Z1)

When you use the following JD Edwards EnterpriseOne programs, the system populates the F0911 table based on the account distribution that you enter:

System

Programs

Accounts Receivable

  • Standard Invoice Entry (P03B11)

  • Batch Invoice Revisions (P03B11Z1)

  • Batch Invoice Processor (R03B11Z1A)

Accounts Payable

  • A/P Standard Voucher Entry (P0411)

  • A/P Batch Voucher Entry (P0411Z1)

  • A/P Voucher Journal Entry Redistribution (P042002)

  • Batch Voucher Processor Report (R04110ZA)