Sage 100

 View Only
  • 1.  GL_DetailPosting file forked

    Posted 07-28-2022 11:51
    I'm going to create a case with Sage, too, but if anyone has anything, I know this will be quicker.
    Client got an error when attempting to post DTR.  Couldn't rebuild GL_DetailPosting file due to Error 11.
    The file  has a .001 portion, too.  DFDM indicated 4.2 million records.

    I brought both files back to my machine and UFARd.  The UFAR said 1.66 million records and removed the .001 file.
    I copied the lone file back (with lots of backups of the original 2) and rebuilt.
    It said it recovered 3.6 million of the 1.66 million but once the rebuild was done, the GL_DetailPosting file was missing.
    You could see the .NEW of both files, but it left nothing for the original file.

    Thinking at this point a restore may be in order, but also thinking this client probably last got a good backup in 2020.
    Any thoughts?

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


  • 2.  RE: GL_DetailPosting file forked

    Posted 07-28-2022 12:15
    Mmmmm......   Put out the disaster recovery billable rate book?   And here I thought I had a problem when client contacted me this AM asking what could cause three invoice that updated to the AR module not to post to the GL.  Second time since January this has happened.....  Good Luck.

    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    ------------------------------