Sage 100

 View Only
  • 1.  Exporting Data from IM_ItemWarehouse v2019

    Posted 08-06-2020 19:58
    I rarely use V/I Export Jobs, but a customer asked why an export job for IM_ItemWarehouse doesn't show the full complement of fields, such QtyOnHand, QtyOnPO, TotalWhsValue, etc., whereas any tool that connects via ODBC does show all of the fields. I don't have a good answer.

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    Fresno CA
    803.252.6154 x242
    559.577.4142
    90 Minds Treasurer
    ------------------------------


  • 2.  RE: Exporting Data from IM_ItemWarehouse v2019

    Posted 08-07-2020 01:26
    There should be an options button on the first tab and that should bring up a dialogue that has a checkbox option to show all fields. Try that and see what happens.

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



  • 3.  RE: Exporting Data from IM_ItemWarehouse v2019

    Posted 08-07-2020 11:50
    Cool.  New trick learned for the day.  Thanks David.

    ------------------------------
    Thomas Rogers (TomTarget)
    Target System Technology, Inc.
    Spokane Valley WA
    ------------------------------