Sage 100

 View Only
  • 1.  Preventing duplicate AR Invoices from importing in VI

    Posted 03-28-2023 19:20
    Edited by Kenny Daniel 03-28-2023 20:20
      |   view attached

    Customer uses VI to import AR Invoices. Sage100 2022.2.  They want to prevent the importing of duplicate Invoice numbers. I found something for preventing AP Invoices from being imported (credit to @Alnoor Cassim). I tried to adapt it to AR but I'm not having much luck. I keep getting Perform Logic errors. Attached is the AP Invoice Perform Logic. Any help/advise is appreciated. TIA



    ------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ------------------------------

    Attachment(s)

    txt
    AP_Check4DupeInvoice.txt   988 B 1 version


  • 2.  RE: Preventing duplicate AR Invoices from importing in VI

    Posted 03-29-2023 07:05

    Reach out to @Marcos DeLuna 

    He helped me with this exact logic for an import



    ------------------------------
    Dana Young
    Lehman Wesley & Associates
    ------------------------------



  • 3.  RE: Preventing duplicate AR Invoices from importing in VI

    Posted 03-29-2023 07:29
      |   view attached

    Kenny, try the attached.  I included notes.  You can certainly reach out to me if you have any questions.



    ------------------------------
    Marcos DeLuna
    Deluna Consulting
    ------------------------------

    Attachment(s)

    TXT
    FIND_INVOICE.TXT   909 B 1 version


  • 4.  RE: Preventing duplicate AR Invoices from importing in VI

    Posted 03-29-2023 13:20

    OMG, worked like a charm...the first time. Thank you so much @Marcos DeLuna and @Dana Young 



    ------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ------------------------------