Open Forum

Expand all | Collapse all

MICR Check Format Storage

  • 1.  MICR Check Format Storage

    GOLD CONTRIBUTOR
    Posted Aug 16, 2019 11:06 AM
    Hello,
    We are validating our upgrade from GP2015 to GP2018 and I can't remember where the check formats are stored.  I know they are now stored in the database but I can't figure out what table to  make sure they came over ok.

    Thank you,
    Melanie

    ------------------------------
    Melanie Knight
    System Administrator
    NetJets Inc.
    Columbus OH
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: MICR Check Format Storage

    TOP CONTRIBUTOR
    Posted Aug 16, 2019 12:33 PM
    I will doublecheck when I get back to the office from lunch, but think that's in the tables that start with ME... under each company name.

    ------------------------------
    Kelly Hobart
    Business Data Analyst
    Mount Pleasant Waterworks
    Mount Pleasant SC
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: MICR Check Format Storage

    GOLD CONTRIBUTOR
    Posted Aug 16, 2019 12:37 PM
    @Kelly Hobart
    Yes, but do you know which one?  I'd guess it'd have a large number of records since there are so many default check formats, but every one I'm querying only seems to have 4 or so.  Or does it only store what you are actually using?

    Thanks,
    Melanie​

    ------------------------------
    Melanie Knight
    System Administrator
    NetJets Inc.
    Columbus OH
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: MICR Check Format Storage

    TOP CONTRIBUTOR
    Posted Aug 16, 2019 12:44 PM
    Just did a quick search on https://gptables.azurecurve.co.uk/products/mekorma-micr-2404/purchasing/micr-check-setup-2-me27601/ (Thank you Ian Grieve!)
    and looks like ME27601

    Hope that helps you out!



    ------------------------------
    Kelly Hobart
    Business Data Analyst
    Mount Pleasant Waterworks
    Mount Pleasant SC
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: MICR Check Format Storage

    GOLD CONTRIBUTOR
    Posted Aug 16, 2019 02:18 PM
    @Kelly Hobart  Thank you so much!  Very helpful! ​

    ------------------------------
    Melanie Knight
    System Administrator
    NetJets Inc.
    Columbus OH
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role