Sage 100

 View Only

  • 1.  One VI source file to feed multiple company GL import

    Posted 05-16-2019 11:23
    I have created a VI job to import a journal entry.


    I have a customer who wants to have one source file where they embed a Sage company code. They have 6 or more separate Sage companies.

    They want to use VI to pull in the lines that are appropriate for the company code they are running the VI job from

    Example,

    I am in company ABC - I want to go to VI - kick off my journal entry import.
    I want the VI job to compare the company I am running VI from ( ABC ) to a field "company code" in the import source. 
    If there is a match I want to bring that line in
    If there is not a match I want to skip that line

    This seems pretty basic but perhaps I'm oversimplifying what would need to happen.

    I'm not sure on the VI side how to pull the current company code so I could compare it to the company code field in the source file.

    Has anyone done this or do I need to go back to the customer and tell them I need 6 separate VI jobs after all ? 


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


  • 2.  RE: One VI source file to feed multiple company GL import

    Posted 05-16-2019 11:36
    You should be able to create a Temp string variable in your VI Job and use the Assign operation.  The default value would be <CompanyCode>.  Then.  Import the CompanyCode field from your import source to a Temp string variable also.  Make the import of records conditional on whether Temp01 = Temp02.

    ------------------------------
    Chris St. Amand
    Arizona Accounting & Information Systems
    ------------------------------



  • 3.  RE: One VI source file to feed multiple company GL import

    Posted 05-17-2019 02:31
    You don't even need the Temp variable. This worked for me. Just make sure to select the correct field number, start, and length values.


    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------

    Original Message


  • 4.  RE: One VI source file to feed multiple company GL import

    Posted 05-17-2019 09:01
    6 VI jobs chained to each other each looking for the specific company from the one source file?

    ------------------------------
    alan niergarth
    Velosio LLC
    ------------------------------



  • 5.  RE: One VI source file to feed multiple company GL import

    Posted 05-17-2019 09:11
    I don't think chaining is going to work easily since whatever company code the first VI job is launched under, the subsequently chained VI jobs will launch under the same company code as the first one.
    I think it would be easier to have a single batch file containing the lines needed for each company code. You would basically create the first line with the correct external link, path, vi job, launch method, credentials, company code, etc. Copy the line for each company code and just change the company code on each line.

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------

    Original Message


  • 6.  RE: One VI source file to feed multiple company GL import

    Posted 05-17-2019 09:31
    @David Speck II That is right.  Wasn't thinking through the change company component.  Knew it was too easy.  ​

    ------------------------------
    alan niergarth
    Velosio LLC
    ------------------------------

    Original Message


Related Content