Sage 100

 View Only

  • 1.  Is it possible to build into a VI import job a selection parameter to select records from a source file by company code?

    Posted 07-12-2019 12:31

    We have a client with multiple companies.  We are investigating building import jobs into Transaction JE Header and General JE Header.  The data for each job would be a CSV file containing records from multiple companies.  One column would contain the company code.  The provider (ManageAmerica) would like to provide a single file with records for all companies.  I'm envisioning using a Temp field with a runtime assign to gather the company code, but can I have the job only select records for that company code?



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------


  • 2.  RE: Is it possible to build into a VI import job a selection parameter to select records from a source file by company code?

    Posted 07-12-2019 12:54
    I have looked into something similar in the past... It has always aggravated me that 'Perform' logic is not included as an option in Record Selection... I think it would be perfect here... comparing ss'CompanyCode$ to one of your import columns to accept or reject each record. Seems like a perfect solution for a 'Perform' script...


    Sadly, I have generally ended up simply splitting the CSV into separate files one per company code...  If there is a better answer, I too would be interested...


    ------------------------------
    Randy Marion
    ------------------------------



  • 3.  RE: Is it possible to build into a VI import job a selection parameter to select records from a source file by company code?

    Posted 07-12-2019 13:06
    Like this? 

    https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=b4229162-5420-42c2-9f26-2d69f1f98a11&CommunityKey=4593d843-4557-43ff-ba4d-6240681ed696&tab=digestviewer#bmb4229162-5420-42c2-9f26-2d69f1f98a11

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 4.  RE: Is it possible to build into a VI import job a selection parameter to select records from a source file by company code?

    Posted 07-12-2019 13:07
    This post should help.
    I have created a VI job to import a journal entry. I have a customer who wants to have one source ...

    ------------------------------
    Bill Pfahnl
    Nims & Associates
    ------------------------------



  • 5.  RE: Is it possible to build into a VI import job a selection parameter to select records from a source file by company code?

    Posted 07-12-2019 14:16
    Yes, success!  Thank You!

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


Related Content