Results 1 to 4 of 4

Thread: AP to GL Integrity issue

  1. #1

    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!


  2. #2
    Senior Member
    Join Date
    Nov 2000
    Location
    Houston, TX
    Posts
    548

    Re: AP to GL Integrity issue

    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 <marc.aanenson@olddutchfoods.com> 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/showthrea...W&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

    World, OW B733X, Xe, E1 8.0, 8.9, 8.10, 8.11, 9.0 Financial, Distribution, Dev, CNC

  3. #3

    Re: AP to GL Integrity issue

    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?

  4. #4
    Senior Member
    Join Date
    Nov 2000
    Location
    Houston, TX
    Posts
    548

    Re: AP to GL Integrity issue

    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 <marc.aanenson@olddutchfoods.com> 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/showthrea...W&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

    World, OW B733X, Xe, E1 8.0, 8.9, 8.10, 8.11, 9.0 Financial, Distribution, Dev, CNC

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.