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 |
|
Accounts Payable |
|
Procurement |
Voucher Match (P4314) |
Distribution |
Sales Update (R42800) |
Advanced Pricing |
Ship and Debit Claims (P4576) |
Expense Management |
Expense Report Reimbursement (R20110) |
Real Estate Management |
|
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 |
|
Accounts Payable |
|