Sage 100

 View Only
  • 1.  AP Transfer type Invoice Register keeps stopping at same point

    Posted 06-03-2022 14:40
    Have an 874 line transfer type invoice register that keeps stopping on the same line.  I have rebuilt AP_Invoice Detail/Header/Detail Posting/Header Posting/ Tax Summary/Tax Detail and the same History file.  I delete the line after the line it stops on.  And STILL - it stops on that line.

    Any ideas?

    ------------------------------
    Beth Bowers
    Mom to Peanut, ChiChi, Canton, Cagney and Daisy (I miss you, Sammy)
    Tennessee Software Solutions
    (269) 358-0989
    ------------------------------


  • 2.  RE: AP Transfer type Invoice Register keeps stopping at same point

    Posted 06-03-2022 14:45
    Maybe copy the company to a test company, uncheck the 2 invoice history check boxes in setup options, and see if it goes through.  Also, maybe try deleting the line before the error occurs.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 3.  RE: AP Transfer type Invoice Register keeps stopping at same point

    Posted 06-03-2022 15:10
    One would have thought this would have forced it to go through - but NOT.  If it's not posting to Invoice History, then WTH posting IS it hanging on??????  It's not GL - that file, in balance, was already created prior to this portion of the update.

    OOHHHH - because it's a TRANSFER, the Check History is also being updated.  Didn't rebuild that.  Argh, off to try that.

    ------------------------------
    Beth Bowers
    Mom to Peanut, ChiChi, Canton, Cagney and Daisy (I miss you, Sammy)
    Tennessee Software Solutions
    (269) 358-0989
    ------------------------------



  • 4.  RE: AP Transfer type Invoice Register keeps stopping at same point

    Posted 06-03-2022 17:01
    Found it, eventually.  Like more than halfway into 840 lines....
    Here's the deal:
    This is for PCards.  Have 2 imports, both of which use the same file.
    1st pass imports all invoices into actual vendors.
    After updating, a second import creates a transfer into the CC vendor.

    The issue was that in the original file, some of the invoices had lower case letters.
    Sage correctly changed those to uppercase during the first import, but for some reason stalled out AFTER UPDATING the line on the second import if the TRANSFER invoice had lowercase in the import file.
    I manually modified the rest of the records to have uppercase and the update finally successfully finished.

    ------------------------------
    Beth Bowers
    Mom to Peanut, ChiChi, Canton, Cagney and Daisy (I miss you, Sammy)
    Tennessee Software Solutions
    (269) 358-0989
    ------------------------------