Sage 100

 View Only

  • 1.  AR Aged invoice Report

    Posted 08-04-2019 07:47
    Customer completed period end for March, April, May & June.
    He has the aged invoice report in paperless.
    Now if we try to go back and reprint the aged invoice report for those days, we get a different amount.
    Example, if I regenerate it for April 30th, the payments posted in May & June are still applied.
    I have tried printing Aged Invoice and Trial Balance and they both generate the same incorrect amounts
    Any ideas???

    ---------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ---------------------------------


  • 2.  RE: AR Aged invoice Report

    Posted 08-04-2019 08:28
    TB should be correct, but on the Aging - isn't there a check box about excluding future dated transactions?

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



  • 3.  RE: AR Aged invoice Report

    Posted 08-04-2019 11:23
    Thats what I thought...but nope. Trisl balance matches the “incorrect” ageing. I even generated the ageing with transaction date and its incorrect. I can see the cash receipt with the payments in May & June...but it is still applying them as of invoice date

    ---------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ---------------------------------



    Original Message


  • 4.  RE: AR Aged invoice Report

    Posted 08-04-2019 14:40
    would the fact that they purge history upon period closing wont let them do it???

    ---------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ---------------------------------



    Original Message


  • 5.  RE: AR Aged invoice Report

    Posted 08-04-2019 20:39
    Does the TB as of today match the GL as of today?  How long do they retain Open Invoices?  The transaction history is retained for the same amount of time.   Perhaps days to retain open invoices is set very short.

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

    Original Message


  • 6.  RE: AR Aged invoice Report

    Posted 08-06-2019 10:18
    Purging would mean missing invoices, not extra payments being shown.  I'd look at AR_TransactionPaymentHistory to verify the raw data.  The way Sage handles dates for Aging is not overly intuitive.

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

    Original Message


  • 7.  RE: AR Aged invoice Report

    Posted 08-06-2019 10:25
    The AR aging used AR openinvoice and at transactionpayment tables.  If transaction history is purged it would affect the aging.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


  • 8.  RE: AR Aged invoice Report

    Posted 08-06-2019 10:28
    Yes, days to retain open invoices would affect AR_OpenInvoice.

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

    Original Message


  • 9.  RE: AR Aged invoice Report

    Posted 08-07-2019 12:41
    I understand it would change the ageing....but also the trial balance???

    ---------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ---------------------------------



    Original Message


Related Content