Sage 100

 View Only

  • 1.  Cash Receipt Import

    Posted 12-16-2022 13:18
    Client on 2022 Premium, just upgraded/moved to cloud.  The Cash Receipt import they were using before in 2018 is failing on the detail import saying "The Invoice Number is required" and below that is the invoice number field listed with...wait for it... an invoice number in it.

    I've compared this import to one I recently did for someone on 2019 Adv and it's basically the exact same thing, line for line.  Is there something up with Premium?  Has anyone ever seen this error?  I include assigning line type I and the AmountPosted along with the invoice number - those are my only 3 line fields.  I also tried it without assigning the line type, same thing.  I've also tried it with and without Record Selection on an LI record type (the Adv one does not use it and still works).



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------


  • 2.  RE: Cash Receipt Import

    Posted 12-16-2022 13:54
    Maybe this will help? (from a diff kb article):

    Cause

    <content>

    Multiple records in sourcefile contain same invoice number but other line fields in import job change value

    </content>

    Resolution

    <content>
    • Examine sourcefile and verify line fields change values only when invoice number changes
    </content>


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



  • 3.  RE: Cash Receipt Import

    Posted 12-16-2022 14:11
    I don't think so.  I would expect the very first record to still import anyway... It fails even on a test of the first 10 records.

    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------

    Original Message


  • 4.  RE: Cash Receipt Import

    Posted 12-16-2022 14:16
    Do you have this option enabled?
    It could be throwing everything out due to an incorrect total.

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

    Original Message


  • 5.  RE: Cash Receipt Import

    Posted 12-16-2022 14:21
    It is checked, but the error doesn't really seem to be indicating that.  I do know my DEPOSIT total is correct (I added up the spreadsheet).

    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------

    Original Message


  • 6.  RE: Cash Receipt Import

    Posted 12-16-2022 14:26
    Are batches turned on? if so, are you assigning a batch number? I know the message doesn't indicate it but VI messages are often confusing.

    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------

    Original Message


  • 7.  RE: Cash Receipt Import

    Posted 12-16-2022 14:45
    Yes, and I assigned the batch and the Deposit number, both

    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------

    Original Message


  • 8.  RE: Cash Receipt Import

    Posted 12-16-2022 14:47
    Inactive customer? 

    Paid Today?  Invoices already in a different unposted Cash Receipts batch?
    Scripts / enhancements?

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

    Original Message


Related Content