Sage 100

 View Only

  • 1.  "Line Consolidate" logic in a VI

    Posted 04-22-2019 17:22
    Is there a way for VI to consolidate like items during an import to SO Invoice Entry? The client receives a csv files from another system and it lists the same item multiple times, they would like the quantities aggregated and to show a single line in the invoice.

    Is there a way to do that with perform logic? Anyone ever done that before?

    TIA

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------


  • 2.  RE: "Line Consolidate" logic in a VI

    Posted 04-22-2019 17:25
    @Alnoor Cassim can likely write some perform logic to preprocess the file and get the desired results.​

    ------------------------------
    Jim Woodhead
    DSD Business Systems

    ------------------------------



  • 3.  RE: "Line Consolidate" logic in a VI

    Posted 04-22-2019 17:34
    Thanks Jim.

    I have a sample and can provide the VI if anyone (@Alnoor Cassim?) would like to quote the job.​

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------

    Original Message


  • 4.  RE: "Line Consolidate" logic in a VI

    Posted 04-22-2019 17:39
    Greg I'll send you a direct message.

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

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------

    Original Message


Related Content