ORACLE JD Edwards 集成性报告 TYPES OF INTEGRITIES

[p31415926]

Here is a list of reports we run regularly.

TYPES OF INTEGRITIES

JD Edwards provides two main types of Financial Integrity reports,
Batch Header reports and General Ledger reports. The Batch Header
reports locate problems in the batches and their corresponding detail.
The G/L reports compare transactions within a company, Intercompany
settlement, account balances to detail, and compare the Account Master
F0901 to the BU Master F0006, Account Balances F0902, and the Account
Ledger F0911.

We will also utilize four subsidiary forms of integrities, Accounts
Payable, Fixed Assets, Accounts Receivable, and Inventory. These
reports compare each subsystem to the General Ledger.

AVAILABLE INTEGRITY REPORTS

A list of currently available reports and brief descriptions of their
purposes:

GENERAL LEDGER INTEGRITIES

Companies in Balance (G0922, R097001) � Compares all postings on a
single company number. Amount should balance to zero. Out of Balance
conditions will be shown for current year, prior year, and future
periods.

This is the primary report to identify that an out of balance
condition exists.

Intercompany Accounts in Balance (G0922, R097011) � Balances the
machine generated intercompany accounts to each other. All of these
accounts, system wide, should net to zero. (Does not work with detail
Intercompany settlements, only HUB method)

Accounts without Business Units (G0922, R097041) � Lists records
(Accounts) in the F0901 file with Business Unit and Company
discrepancies. Also, it is capable of updating the F0901 from the
F0006, BU Master.

Account Balance without Account Master (G0922, R097031) � Compares
Object Accounts in the F0901 to the Balances in the F0902 file.

Transactions without Account Master (G0922, R097021) � Compares Object
Accounts in the F0901 to the Transactions in the F0911 file.

Account Balance to Transactions (G0922, R09705) � Compares Detail
Transactions, F0911, to the Account Balance, F0902, on a period-by-
period basis.

Global Update BU/OBJ/SUB to F0902/F0911 from F0901 (G09316, R09806) �
Updates obsolete Chart of Accounts values (Business Unit, Object
Account and Subsidiary) in the Account Balances and Account Ledger
tables to current values.

BATCH HEADER INTEGRITIES

Unposted Batches (G0922, R007011) � Prints all batches shown as non-
posted regardless of the reason.

Company by Batch Out of Balance (G0922, R09706) �Shows out of balance
for each company within each batch.

Normally a follow up, details report once an out of balance condition
exists.

Transactions to Batch Headers (G0922, R007021) � Compares the F0011
Batch Header File to the F0413 Batch Header Records file. Shows
transaction records without a batch header record and unposted
transactions with a batch status of �D� (posted).

Batch to Detail & Out of Balance (G0922, R007031) � Shows batches
posted out of balance. Also has update capability to delete batch
header records with no detail records and update batch status to D
(posted) if the detail records all show posted.
Normally a follow up, details report once an out of balance condition
exists.

ACCOUNTS PAYABLE INTEGRITIES

A/P Original Document to G/L by Batch (G0421, R04701, ZJDE0001) �
Shows posted A/P ledger F0411 amounts and the corresponding posted
Account Ledger F0911 amounts by batch, tests for any differences. Also
shows invalid pay status conditions for each record within an A/P
batch.

A/P Payments to G/L by Batch (G0421, R04702A) � Locates possible
integrity problems in the payments records, only reviews posted
payments.

A/P to G/L by Offset Account (G0421, R047001A, ZJDE0001) � Prints open
(posted) A/P Ledger F0411 amounts and the corresponding A/P control
offset account amounts in the Account Balances File F0902.

ACCOUNTS RECEIVABLE INTEGRITIES

A/R to G/L by Batch (G03B21, R03B701) - Shows posted A/R ledger F0311
amounts and the corresponding posted Account Ledger F0911 amounts by
batch and tests for any differences. Also shows invalid pay status
conditions for each record within an A/R batch.

A/R to G/L by Offset Account (G03B21, R03B707, ZJDE0001) - Prints open
(posted) A/R Ledger F0311 amounts and the corresponding A/P control
offset account amounts in the Account Balances File F0902.

FIXED ASSET INTEGRITIES

Fixed Assets to G/L Integrity (G1224, R127011) � Compares balance
records in the Fixed Assets Item Balances File to the General Ledger
Account Balances File.

Unposted to F/A Transactions (G1224, R12301, ZJDE0001) � Prints a list
of all transactions that have been posted to the General Accounting
System but have not yet been posted to Fixed Assets.

Fixed Asset Transaction Integrity/Report (G1224, R127012) � Reports a
detail list of all transaction records from the F0911 Account Ledger
for a particular account in the current year for a particular company.
Similar to a detail G/L report, normally a follow to investigate
outages.

G/L to Fixed Assets Integrity (G1224, R127013) � Compares the General
Ledger Account Balances File to balance records in the Fixed Assets
Item Balances File.

INVENTORY INTEGRITIES

Item Ledger/Account Integrity Report (G41111, R41543) � Shows
discrepancies that exist between the Item Ledger File F4111 and the
Account Ledger F0911.

Item Balance/Ledger Integrity Report (G41111, R41544) � Compares the
Item Ledger File F4111 to the Item Balance File F41021. Shows variance
in amounts, quantities, or both.

PAYROLL INTEGRITIES

Tax History Integrity Report (G07BUSP3, R077011) � Identify errors in
your Tax History table (F06136).
PDBA Integrity Report (G07BUSP3, R077021) � Identify errors in the
Employee Transaction History Summary table (F06146).

Note: We run these two reports during the Final Update process of
every payroll.

J.D. EDWARDS RECOMMENDED SCHEDULE

REPORT - WHEN TO RUN

Companies in Balance (R097001) - Weekly during month (minimum) and
nightly during the 1st through the 6th business day (close).

Intercompany Accounts in balance (R097011) - Twice Monthly, 15th and
End of Month

Accounts without Business Units (R097041) - Twice Monthly, 15th and
End of Month

Account Balance without Account Master (R097031) - Twice Monthly, 15th
and End of Month

Transactions without Account Master (R097021) - Twice Monthly, 15th
and End of Month

Account Balance to Transactions (R09705) - Twice Monthly, 15th and End
of Month

Unposted Batches (R007011) - Monthly for Batches over 45 days old.

Transactions to Batch Headers (R007021) - As needed to investigate out
of balance

Batch to Detail & Out of Balance (R007031) - As needed to investigate
out of balance

Company by Batch Out of Balance (R09706) - As needed to investigate
out of balance

A/P Original Document to G/L by Batch (R04701) - Twice Monthly, 15th
and First of Month

A/P Payments to G/L by Batch (R04702A) - Twice Monthly, 15th and First
of Month

A/P to G/L by Offset Account (R047001A, ZJDE0001) - Twice Monthly,
15th and First of Month

A/R to G/L by Batch (R03B701) - Twice Monthly, 15th and First of Month

A/R to G/L by Offset Account (R03B707, ZJDE0001) - Twice Monthly, 15th
and First of Month

Fixed Assets to G/L Integrity (R127011) - Twice Monthly, 15th and 7th
Business Day

Unposted to F/A Transactions (R12301, ZJDE0001) - Twice Monthly, 15th
and 7th Business Day

Fixed Asset Transaction Report (R127012) - As needed to investigate
out of balance

G/L to Fixed Assets Integrity (R127013)

Item Ledger/Account Integrity (R41543) - Twice Monthly, 15th and First
of Month

Item Balance/Ledger Integrity (R41544) - Twice Monthly, 15th and First
of Month