• BIE Send page by Email Option Not Working

    Upgraded from v2020 to v2020 and users cannot use the option to Send Page by Email option in BIE. Nothing happens when clicked on. I have the same issue on my workstation. My default email is working properly and I tried running Sage as admin. Thanks…
  • Sales Order View in BIE - How to show the Drop Ship field

    How do you add the Drop Ship yes/no field to the BIE Sales Order View? Or, create a new view that shows orders with Drop Ship line? Sage 100c 2016 (soon to be 2019) thanks! Ann
  • 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…
  • Business Insights Explorer - No data populating

    Wanted to use BI Explorer but no data is showing up. I've used it before at another company. Is there a setup or permissions requirement?
  • BIE removing costs of specific item codes from total job cost and revenue

    I'm using the BIE- History Invoice Items to see all items shipped against a customer's PO including credits. I then will use the total cost and price to calculate GP%. However, in order to get an accurate margin, I need to filter total the cost of all…
  • BIE- How to calculate GP Margin w/ credits

    This may be better accomplished by a crystal report, but I don't have access to create those. I'm looking to calculate the final GP Margin on a job including credits which are often $0 to the customer with negative costs of goods so they greatly improve…
  • BIE - Item Transactions View - Export to excel collapsed view?

    Hello, We are trying to get a summarized list in excel of our item transactions by item code. For example, if i'm looking at an item trasaction view of a specific item i see this... Collapsed None Item Code Name Date Quantity Type WDGTA Widget A…
  • BIE Vendor View

    Is there a way to get the aging buckets to display on the Vendor View in BIE? Aging buckets show fine in the Customer View. Thanks! I'm running 2013 ERP 100 Advanced Service Pack 4
  • 64-bit Excel and BIE

    We have a Sage 100 ERP 2014 on Terminal Server with 64-Bit Excel. Everything seems to work EXCEPT the Business Insights Explorer. Is BIE really incompatible with v2014, or am I missing something?
  • 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?
  • Business Insights explorer

    Is there a way to tell what tables the different views are using?
  • BIE Formula Help

    I called Sage support, but got nowhere, as my request was deemed "too complex" by the "subject matter expert". Note to Sage, if you're going to charge people for support, at least train your support reps on using Functions. Can anyone tell how to create…
  • Convert Inventory BIE Views from 4.3 to 4.5

    Howdy, I have a customer that has about 50 custom BIE views from inventory transactions in 4.3. In converting the customer to 4.5, the views do show but do not run. Because the source is still IM5. Is there a method to open the *.EV file and change…