AP to GL Integrity issue

Our integrity report shows that the balance between F0411 and F0902 is off. I was able to find the item in question and here is what looks like happened.

The invoice was paid, but our AP person said that when she looked at the item in the supplier ledger, it had a P for posted but the amount was still open. It paid it again in a different check run later. So the detail in the GL AP account is debited twice for an invoice that went in only once. Hence the variance.

How the heck can this be fixed? I imagine some type of out of balance je or would this be a je from ap to cash?

Thanks in advance!

Marc,

It soulnd like the record lock (#) was changed on the voucher while in payment processing. Here is what you need to do to correct the record.

1. Look at both checks in the GL to make sure both are posted. If one is not, that is the record you want to work with.
2. Void the check. This will re-open the voucher.
3. Post the void. This completes the check processing.
4. Change the open amount on the voucher using a database utility to Zero.
5. Run your AP integrity tests to make sure you are in balance.

abc123 <[email protected]> wrote:
Our integrity report shows that the balance between F0411 and F0902 is off. I was able to find the item in question and here is what looks like happened. The invoice was paid, but our AP person said that when she looked at the item in the supplier ledger, it had a P for posted but the amount was still open. It paid it again in a different check run later. So the detail in the GL AP account is debited twice for an invoice that went in only once. Hence the variance.How the heck can this be fixed? I imagine some type of out of balance je or would this be a je from ap to cash? Thanks in advance!
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=55535
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+

---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.


World, OW B733X and Xe

Thanks Mike. One question.

4. Change the open amount on the voucher using a database utility to Zero.

What is the name of this utility?

Marc,
The utility depends on your platform. For AS400, SQL or DFU. For Wintel, SQL or Access. If you need help, talk with your tech team.

abc123 <[email protected]> wrote:
Thanks Mike. One question.4. Change the open amount on the voucher using a database utility to Zero.What is the name of this utility?
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=55647
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+

---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.


World, OW B733X and Xe