Sage 100

 View Only

  • 1.  AP Invoice Import

    Posted 12-16-2019 17:03
    Customer has a VI job to import invoices from a certain vendor. They don't actually have invoice numbers so they use the first so-many characters from another field. Occasionally, they already exist and they get a warning that the invoice is already on file. They want to know if there is a way to not let it import it (it comes in as an adjustment). I'm sure I'm missing something easy.

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------


  • 2.  RE: AP Invoice Import

    Posted 12-16-2019 17:17
    Alnoor has posted some Perform Logic to do this filtering.

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



  • 3.  RE: AP Invoice Import

    Posted 12-16-2019 17:46
    Thanks @Kevin Moyes.

    @Alnoor Cassim any advice??​​

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


  • 4.  RE: AP Invoice Import

    Posted 12-17-2019 17:15
    This is what I was thinking of...
    https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=ae86ef24-2dc8-4828-a87a-52f20cfdbcef

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

    Original Message


  • 5.  RE: AP Invoice Import

    Posted 12-30-2019 11:55
    My bad. They are importing into MC Entry, not AP Invoice Data Entry. This would have to be a line item check on duplicate invoice in AP invoice history header. I tried the same logic but it didn't do anything. @Alnoor Cassim​ any suggestions??

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


  • 6.  RE: AP Invoice Import

    Posted 12-30-2019 14:02
    Hey Therese - Sorry I didn't see your original message. For some reason, I'm not getting pinged anymore when tagged on a discussion. Robert Wood is helping me with that. Anyway, yes you're correct about how the logic would need to work for MC Entry. I believe I've done it in the past but of course I can't remember when and for whom. ​What I might do is post what the Perform would look like but ask you to test it.

    ------------------------------
    Alnoor Cassim

    Accounting Systems, Inc. (ASI)
    Email: alnoor@asifocus.com
    Orange County, CA
    ------------------------------

    Original Message


  • 7.  RE: AP Invoice Import

    Posted 12-30-2019 14:08
    Of course - that would be perfect! Thanks @Alnoor Cassim!
    ​

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


Related Content