Results 1 to 6 of 6

Thread: Updating Check Number

  1. #1
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,757

    Updating Check Number

    Howdy,

    We have a situation where a clerk reran some checks, starting with the a different check sequence number. Somehow, the first set of checks were sent out - and positive pay was created for the second sequence of checks. Basically, JDE shows a different check number than the paper check that went out.

    Is there any harm back-dooring the check number in the F0413? I've been asked to update the JDE Check Number to match the actual check number on the Paper Check.

    Thoughts? What am I missing?

    (db)
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  2. #2
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,757
    I guess I should 'guess' that no one ever runs into this type of problem. Everyone has perfect AP folk...

    (db)
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  3. #3
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,164
    Daniel,

    I think we don't have preprinted numbers on our check stock ...
    Larry Jones
    E1 9.1 - TR 9.1.5 on Win 2012 R2. Oracle DB 11.2.04
    Wintel, BI Publisher

    Migrating to JDE 9.2 and SQL Server 2016

  4. #4
    Member
    Join Date
    Jan 2002
    Location
    Valley Forge, PA
    Posts
    79
    Daniel

    Also keep in mind that the check number appears in the GL tables in the "K" batches. This is where the check reconciliation takes place after the checks clear.
    E1 9.2 TR 9.2.2.1
    Netscaler traffic managers
    SQL Server 2016
    Weblogic Web Servers, Windows Enterprise Servers

    I do all my own stunts!

  5. #5
    we do have pre-printed check numbers as we do not have a specific MICR printer. This also happens if you try to write multiple payment batches at the same time as it doesn't sequence in the same order as within the respective batches. When this happened to our users, we opted to maintain a separate file with these one-offs to be able to cross reference against the bank activity for purposes of bank reconciliation and vendor inquiry. We also added an attachment text note to each payment in the supplier payment inquiry for anyone who may not realize a different number was on the check. Thankfully the bank accepted the checks given that the pre-printed number and the MICR line were in agreement, but we had to approve a lot in our bank positive pay due to the mis-matches from our positive pay file vs what the actual check #s on paper were. Otherwise, we opted not to backdoor any data changes in any of the correlating tables, but we were only dealing with about 100 checks.

  6. #6
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,757
    Thanks everyone

    - tboat, nice catch!

    (db)
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

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.