Sage 100

 View Only

  • 1.  In VI export there is an option to ""export column

    Posted 11-21-2012 05:39
    In VI export there is an option to ""export column names as fist record"". Is there a way to define the column heading? ie instead of the first row of the column being ""itemcode"" they would like it to say ""sku"" for the export.


  • 2.  RE: In VI export there is an option to ""export column

    Posted 11-21-2012 05:41
    I did this but not with VI - in my case I used Access. I'm not sure if it's possible using VI so I went the Access route since I was pretty sure that the customer would have other requests (which they did) that would have been difficult to accomplish in VI.


  • 3.  RE: In VI export there is an option to ""export column

    Posted 11-21-2012 05:42
    II don't think so as the column headings are taken from the data disctionary.


  • 4.  RE: In VI export there is an option to ""export column

    Posted 11-21-2012 05:43
    thanks. That's what I thought. I will go the MS Access route


  • 5.  RE: In VI export there is an option to ""export column

    Posted 11-21-2012 05:44
    I have setup queries in Excel where column headings are different. Using Excel of Access you're pulling the information out rather than exporting with VI.


  • 6.  RE: In VI export there is an option to ""export column

    Posted 10-26-2023 10:39
    Edited by Brett Zimmerman 10-26-2023 10:41



    Original Message


  • 7.  RE: In VI export there is an option to ""export column

    Posted 10-26-2023 10:41

    This sounds promising (corr link):  https://www.sagecity.com/us/sage100/f/personalization-customization-and-productivity-tools/198298/how-to-rename-a-temp-field-in-a-vi-export/503886



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


Related Content