Balancing F0911 to F0411 and F0414

[Rackley]

Apologies in advance if repeating a question that's been discussed before. I'm working on reconciling our General Ledger to our AP subsystem and I have some outages in prior months that I'm trying to identify and correct. Due to some integrity issues caused by acquisition related purging (we were acquired through an acquisition of part of another company) the canned integrity reports are useless. I'm trying to month by month take new vouchers (F0411 I think) + checks cut (F0414) and compare them to the F0911 detail for our appropriate AP Trade account. When I add together the Vouchers and the checks I don't tie back to the change in open ap from last month to this month and my outage isn't equal to my AP to GL outage I'm looking for. I'm obviously not doing something correct (possibly wrong tables, not excluding certain transactions I need to exclude...). I'm new to using Peoplesoft World so any help would be appreciated.

Thanks,

Eric

 

[John_Dickey]

Eric,

Well, do you have multiple A/P Trade accounts? If you do, you have
to be careful what records you try to use. F0414 is the check detail.
F0413 is the check header. Is it maybe better to data select on the
integrity report just for the last month, to avoid the history stuff?

John Dickey
JDE Financial Systems
Administrator/Programmer/Analyst
White-Rodgers, Division of Emerson
St. Louis, MO
314-577-1466