Sage 100

 View Only

  • 1.  Auto Check Recon

    Posted 05-12-2020 12:07
    Bank doesn't include leading zeros in Check download AND customer has both 5 and 6 digit checks in the same account.  I don't see any way to do anything about this in the file layout.  I figured Sage would add the leading zeros but it doesn't appear to be - all are coming up as invalid checks.

    Is it me?

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------


  • 2.  RE: Auto Check Recon

    Posted 05-12-2020 17:03
    Are there alpha's in the check number?  Not quite understanding the issue.  A number is a number.  I never import leading zeros.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: Auto Check Recon

    Posted 05-12-2020 19:15
    I was going to update this and forgot.  I don't know the issue but it's not what I thought it was.  Connecting again with the client tomorrow.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------

    Original Message


  • 4.  RE: Auto Check Recon

    Posted 05-12-2020 19:29
    I remember having to write a script to extract the check# into its own column once (because the bank's file embedded it in a text string... which is just silly).

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 5.  RE: Auto Check Recon

    Posted 05-13-2020 00:26
    Should be able to accomplish this with a calculated operation in the VI job, basically checking if the value is numeric and if so, pad zeros on the left, otherwise, leave as is.

    You could also achieve this with a couple temp fields and use the ENV("NUM()") combination to return whether or not the value is numeric and then do conditional statements against the result. Refer to this post for that example.
    https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=349afeef-9be3-40a8-a7c1-0939ea6e5b1b&CommunityKey=4593d843-4557-43ff-ba4d-6240681ed696&tab=digestviewer#bm349afeef-9be3-40a8-a7c1-0939ea6e5b1b

    Here is the full command if you use the example in the snippets. Replace IMP$[x] with either a string temp field or replace just the x within the brackets with the column number containing the value in the source file that you need to correct.
    TBL(ENV("(NUM(IMP$[x])*0)+1",0),IMP$[x],PAD(STR(NUM(IMP$[x])),6,"L","0"))​


    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------

    Original Message


Related Content