Sage 100

 View Only

  • 1.  VI Cash Receipt with only invoice number

    Posted 02-22-2024 16:20

    Sage 2019 - Looking for way to import into AR_CashReceiptHeader from a source file that contains only the invoice number and check number but not the customer number.  Manual entry allows to enter an invoice number followed by the check number. This automatically pulls in the customer/invoice/amount.  However, there is not a header field for invoice number for the import.

    Thank you



    ------------------------------
    Rob Neal
    ------------------------------


  • 2.  RE: VI Cash Receipt with only invoice number

    Posted 02-22-2024 16:41

    Rob,

    The best way is to have some perform logic written that would look up the division and customer number by the invoice number.  The perform logic could populate the Cash Receipts header.   Our custom programming team can assist with this.



    ------------------------------
    Jim Woodhead
    DSD Business Systems
    619-990-3946
    ------------------------------



  • 3.  RE: VI Cash Receipt with only invoice number

    Posted 02-22-2024 22:55

    Several years ago we set something up in MS Access to locate the invoice # and populate the csv. 



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


  • 4.  RE: VI Cash Receipt with only invoice number

    Posted 02-22-2024 23:44

    An Excel Power Query solution would be maintainable without Proform Logic skills. It could match a CSV, text, Xlsx, or ODBC source with the AR_OpenInvoice table to provide the customer account and division number. It's like having the functionality of Crystal Reports behind the workbook without macro security issues. 



    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------



  • 5.  RE: VI Cash Receipt with only invoice number

    Posted 02-23-2024 10:34

    If the source file is CSV (or text) I've done stand-alone VBscripts for such lookups.  (Open the text file, loop through lines, ODBC query to look-up the invoice #... pop-up a warning if nothing is found or a duplicate match... then create a new CSV with added columns for Division and CustomerNo).

    If the source is SQL, it's even easier... just create a SQL view for the lookup, and import from that.



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



Related Content