Sage 100

 View Only
  • 1.  Client is trying to export inventory items with Qu

    Posted 11-21-2016 12:21
    Client is trying to export inventory items with Quantity on Hand using VI (v2016). But IM_ItemCost, IM_Physical and IM_ItemWarehouse seem to have the QOH stripped from the export. Has anyone found a way to export the QO Using VI? They are trying to stay away from MSQuery so they can automate it. Is Perform my only option here?


  • 2.  RE: Client is trying to export inventory items with Qu

    Posted 11-21-2016 12:30
    In VI Export Job Maintenance, click on the Options button on the Header tab and then enable the option Display Read Only Fields for Export


  • 3.  RE: Client is trying to export inventory items with Qu

    Posted 11-21-2016 12:31
    Ah!! There it is! Thank you @RobertWhite I forgot about that little gem. I thought I remembered being able to export those fields.


  • 4.  RE: Client is trying to export inventory items with Qu

    Posted 11-21-2016 13:35
    I often forget about those settings on an Export; under the options button...


  • 5.  RE: Client is trying to export inventory items with Qu

    Posted 11-21-2016 13:44
    Does anyone have a logical reason for hiding them on the export side of things?