• Add a column in BIE? Help, I am not that smart!

    I am trying to make a custom report in Business Insights Explorer that shows: Item Code Item Description Product Line Quantity on Sales Order Total Quantity on Hand But I cannot link a "Qty. on Sales Order" column to the rest of the report…
  • Figure incorrect on Item maintenance Screen

    Hi I am having an issue were a figure on an item we have is not being reflected properly. Under orders it shows we have 100 + 80 on purchase order but when we look at PO field it only shows 100. I have ran the rebuild sort files for both item maintenance…
  • VI-JOB IM_TRANSACTION_HEADER

    RUNNING SAGE 100 V2017 . trying to create a VI job to adjust inventory for returns. what are the transaction types mean? 1,2,4,6,8 ? also, what fields do I need to import into to make a successful entry. for EntryNo , can i just select Next…
  • Why doesn't standard cost update to the latest price entered in Item Maintenance?

    I am wondering why the Standard Cost does not update in the Item Maintenance window. The item is set to Standard Cost in the Valuation slot, but when we enter a new updated cost in the "Last Costs" category, the "Standard Cost" space, in the Purchases…
  • Filter Inactive Items in BI Explorer

    Is it possible to filter Inventory Items or Customers that have been set to Inactive from BI Explorer views?
  • Can I create a UDF or use customizer in Item Maintenance to have the ability to view our BOM's for each item?

    When we view items in Item Maintenance, we would also like to see the BOM's listed on the Header. We want to see exactly how we calculated the price directly on IM and not have to open another module, then revert back ti IM. We have a lot of items that…