Sage 100

 View Only

  • 1.  AR Period end - aging customer invoices

    Posted 10-17-2020 16:19
    Running AR period end for one of my customers takes 20 minutes or more, most of the time spent 'aging customer invoices.' Yes, they have a lot of invoices but the aged invoice report doesn't take that long. Why/what is it doing during period end??

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------


  • 2.  RE: AR Period end - aging customer invoices

    Posted 10-17-2020 17:22
    Edited by Jeff Schwenk 10-17-2020 17:22
    How many records are in the open invoice table?  Might have some impact.  And what version of Sage?  ADV or STD?  Are you running at the server?

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



  • 3.  RE: AR Period end - aging customer invoices

    Posted 10-17-2020 17:30
    About 80,000 open invoices. v2019 advanced and yes, I am running it on the server. Twenty-eight minutes for the last month.

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


  • 4.  RE: AR Period end - aging customer invoices

    Posted 10-17-2020 17:33
    WHY is it aging customer invoices during period end??

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


  • 5.  RE: AR Period end - aging customer invoices

    Posted 10-17-2020 17:39
    Any add-ons? I have a customer with an add-on that changes the links in the Crystal Report for the Aging report. It takes over an hour to print any aging regardless of number of records, including ABC

    ---------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ---------------------------------





  • 6.  RE: AR Period end - aging customer invoices

    Posted 10-17-2020 17:41
    No, not really any add-ons but this isn't a Crystal issue. It is aging customer invoices when running period end.

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


  • 7.  RE: AR Period end - aging customer invoices

    Posted 10-18-2020 09:31
    A couple of thoughts:
    Try rebuilding the sort files before running period end.
    Maybe the status messages on the screen are not accurate and it is something else that is actually running in that time.

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


  • 8.  RE: AR Period end - aging customer invoices

    Posted 10-18-2020 19:36
    Actually, I think it is a WAD....  From way back I remember that it recalcs the aging when PE is processed......  And I think it recalcs when statements are printed as well.  How many days are paid invoices retained before being purged from the open invoice table?

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

    Original Message


  • 9.  RE: AR Period end - aging customer invoices

    Posted 10-19-2020 09:46
    80,000 is a lot of "open" invoices.  Maybe copy the company to a History Company then purge some of the older paid invoices?

    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------

    Original Message


Related Content