Sage 100

 View Only

  • 1.  Linking Files for VI Export

    Posted 09-11-2019 16:00
    Client needs to export GL Detail Postings for the current year for budgeting purposes.  I have created an export for them but thought it would be nice to link in the GL Accounts file to snag the Account Description.  Sounds simple enough.  It accepts the link but error's out when I run the import. Any help would be greatly appreciated.  Here's the link setting:



    ------------------------------
    Kathryn Scofield
    STA Network Accounting Systems
    ------------------------------


  • 2.  RE: Linking Files for VI Export

    Posted 09-11-2019 17:49
    Depending on the number of fields you need in the export, you may consider using Crystal reports to create and export the data.  it is easier to join tables in Crystal.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------



  • 3.  RE: Linking Files for VI Export

    Posted 09-11-2019 17:55
    @Doug Higgs I'd rather do this in Access but this is all I have to work with.  Plus, linking two GL files on the AccountKey, I mean this should be easy peasy.​

    ------------------------------
    Kathryn Scofield
    STA Network Accounting Systems
    ------------------------------

    Original Message


  • 4.  RE: Linking Files for VI Export

    Posted 09-12-2019 02:39
    Change the "Sequence No." to "00" since no other links are defined.​

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



  • 5.  RE: Linking Files for VI Export

    Posted 09-12-2019 09:23
    I feel your frustration regarding Access.  Had to export a gazillion GL transactions last night without Access or Excel.  Extremely painful, managed with Crystal.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 6.  RE: Linking Files for VI Export

    Posted 09-12-2019 11:34
    @David Speck II, that did the trick!  Thanks!

    ------------------------------
    Kathryn Scofield
    STA Network Accounting Systems
    ------------------------------

    Original Message


  • 7.  RE: Linking Files for VI Export

    Posted 09-12-2019 16:03
    A free ODBC tool can be helpful sometimes.


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

    Original Message


Related Content