Sage 100

 View Only

  • 1.  Apply to Invoice No is Not On File When Creating a CM in SO Invoice Entry

    Posted 03-25-2022 12:07
    Version 2017 Advanced. The end user has several bad debt invoices they want to write off.   all of the invoices they want to write off are more than one year ole and appear on the AR aged invoice report.  A credit memo is crested in SO invoice entry.  Some of the open invoices are on the "apply to" list and some invoices are not there.  The missing invoices are available in cash receipts entry.

    I have looked at the records in AR_OpenInvoice and AR_TransactionPaymentHistory for the missing invoices and don't see anything unusual.  I called Sage and Phillip was not able to figure it out and because the version is not supported they can;t transfer me to anyone that would know.  They do use national accounts and it seems that it may be somehow related to this but I am not sure.  I have tried the regular customer number and the bill to customer number and the same apply to invoices are listed.

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


  • 2.  RE: Apply to Invoice No is Not On File When Creating a CM in SO Invoice Entry

    Posted 03-25-2022 12:16
    Maybe AR invoices vs SO invoices?

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



  • 3.  RE: Apply to Invoice No is Not On File When Creating a CM in SO Invoice Entry

    Posted 03-25-2022 12:54
    @Kevin Moyes  It seems that these are AR invoices not SO invoices.  Why would that matter?  This company has a mix of AR and SO invoices and it seems that only the AR are affected.  ​

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

    Original Message


  • 4.  RE: Apply to Invoice No is Not On File When Creating a CM in SO Invoice Entry

    Posted 03-25-2022 13:01
    I was thinking Sage might filter the ApplyTo list based on source module... it was just a guess.

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

    Original Message


  • 5.  RE: Apply to Invoice No is Not On File When Creating a CM in SO Invoice Entry

    Posted 03-25-2022 13:37
    It's a good thought, and I originally thought the same.  I tested that theory and it appears invoices entered in AR invoice entry can later have a credit memo applied to them using SO invoice entry.

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

    Original Message


  • 6.  RE: Apply to Invoice No is Not On File When Creating a CM in SO Invoice Entry

    Posted 03-25-2022 17:03
    I just had a client posting a deposit for invoices including a -CM that had been Applied To.  The original invoice was still unpaid.  The -CM is not viewable/selectable in Cash Receipts Entry.  We were not able to enter it manually either.  Our solution was to enter a -PP and apply when the original invoice was paid.

    ------------------------------
    Bob Pfahnl
    Manager - Silicon Valley
    DSD Business Systems
    ------------------------------

    Original Message


Related Content