Sage 100

 View Only
  • 1.  I'm wondering if anyone knows exactly how the ""Aut

    Posted 04-04-2018 13:15
    I'm wondering if anyone knows exactly how the ""Automatic"" Recalculate Aging function works in AR, specifically whether it runs only once in a 24-hour period unless credit checking is called via an entry of a sales order/invoice or if runs on some other kind of schedule. The reason I'm asking is because a payment was applied to an invoice at 10:00AM and by 10:00PM, the customer still showed as past due when an alert was run from KnowledgeSync. I'm assuming that the posting of the Cash Receipts Journal didn't update back to the customer aging buckets, so if that's the case, what else causes the aging to be recalculated besides order/invoice entry? How can I ensure that the buckets are correct every night if the customer record hasn't been touched that day?


  • 2.  RE: I'm wondering if anyone knows exactly how the ""Aut

    Posted 04-04-2018 13:23
    Printing an AR Statement does


  • 3.  RE: I'm wondering if anyone knows exactly how the ""Aut

    Posted 04-04-2018 13:25
    So does printing an Aged Invoice report.


  • 4.  RE: I'm wondering if anyone knows exactly how the ""Aut

    Posted 04-04-2018 13:28
    Wasn't there a discussion +/- a week ago about how to run such a report unattended inside of Windows Scheduler?


  • 5.  RE: I'm wondering if anyone knows exactly how the ""Aut

    Posted 04-04-2018 13:29
    Depending what version you're running, I believe you can schedule the A/R Aging to run every night via Sage 100 Task Scheduler (to Paperless .pdf), so that it correctly recalcs customer balances.


  • 6.  RE: I'm wondering if anyone knows exactly how the ""Aut

    Posted 04-04-2018 13:29
    I knew that, but it didn't occur to me I could create a Scheduled Task to run the Aging until you guys said this. That should force this process to work!


  • 7.  RE: I'm wondering if anyone knows exactly how the ""Aut

    Posted 04-04-2018 13:30
    I just input a check for a client and updated the Cash Receipts, then went into DFDM to look at the Customer record. The aging buckets were all 0, as they should have been. So in this case, it appears that the cash receipt DID update those buckets.


  • 8.  RE: I'm wondering if anyone knows exactly how the ""Aut

    Posted 04-04-2018 13:32
    Coincidentally I _just_ finished troubleshooting a client's Windows Scheduled Task that stopped running, which launches a VBScript that runs the A/R Aging to [Paperless] .pdf in order to recalc customer balances every night. This client is running v2013 so they don't have the ability to use the Sage 100 Task Scheduler.