• Build Custom Explore Views?

    Is there a way to build custom explore views. For example, If I go into Business Insights > Explorer am I able to create one of those views from scratch?
  • Making an Explore view a shortcut

    I am wondering if there is a way to make a custom view from the business insights explorer a shortcut within the Explore Tab? am I able to put a custom view in here somehow as a shortcut?
  • Moving a BOM to History

    Is there a way to change an old REV of a BOM to history in order for the inactive REVs to not show on every inquiry? We have been using Sage for a long time and some of our BOMs are no longer active as we no longer build those items. We need to keep the…
  • Query data from IM_PeriodPostingHistory

    Hello, I'm trying to export the history tab of Item Inquiry window (see above) to excel sheet for reporting purpose. I created query which pulls data from the table of IM_PeriodPostingHistory. However, the beginning quantity of each month shows 0…
  • display separate quantities for each warehouse in item look up

    Hi there! I'm a fairly new Sage 100 user and work in a call center that handles sales for multiple warehouses. I get a lot of questions about the availability of products and in different sizes (which we use different item codes for). I would like…
  • Sage WO vs PM Cross Reference?

    Hi, Is there a cross reference list of what the WO tables/fields are now called/located in PM. I'm looking to make a new query for PM to replace what I had in WO coming from the WO9 table or WOO depending on Active or History. Thanks, Ryan
  • Question regarding Invoice Table relationships.

    Hello, I am trying to put together a report for tax purposes and am not confident I am pulling paid invoices correctly. My initial thought was that all invoices in the ar_invoicehistoryheader table were paid, but I was told that these invoices are…
  • Sales Order lines

    I previously worked with Sage 500 and was able to run a query from Sales Order lines and dump that data into excel and then manipulate it for my presentations and create pivot tables.This would brake down the sales order to the line level and provide…
  • Full-time & part-time status not reportable fields?

    Hello, all - is the answer right in front of my face and I can't see it? Neither the Employee Listing (in Payroll Reports) and Custom Lookup View (in Payroll Employee Maintenance) seem to report part-time status in EE Maintenance; this status is indicated…
  • I can't seem to set an event for an item change

    I am trying to get an event trigger when an item quantity changes so I can perform a real time update in a UI. I have tried setting Post Write Events on IM_ItemWarehouse and IM_ItemTransactionHistory, but although I can see the DB Tables changing/updating…
  • Mass Update GL_Account table via SQL update query

    We have upgraded to Sage100 Premium (SQL version). We have been using a separate Excel workbook for special coding we like to use. We would now like to get all those special codes into Sage100 into the rollup codes and UDF's. We do not want to manually…
  • Prepaid Invoice Requests

    Our developers have written an interface to pull and push AR customer data. Invoices (IN) are not a problem, but prepaid invoices (PP) produce no results and no errors. I'm pasting the code below. Any ideas? using System; using System.Collections.Generic;…
  • Determine field lengths

    Is there somewhere in Sage 100 that I can see the field lengths for each field in each table? Here is why I ask: the stock Sales Order printing report shows only the first 100 characters of SO_SalesOrderWrk.CommentText. We have many records having…
  • "Auto Complete" Not Working for New Items

    On every module or input field where Auto Complete feature should work, if the item is relatively new, the Auto Complete does not function. I am unsure when, if ever, Auto Complete will work on these items. Is there any way to force Sage to recognize…
  • Newly received Purchase orders

    Hello, I'm new to SAGE 100 and trying to find out newly received all purchase orders in any given month. Can some one please help me to get this list? If you have any T-sql query and willing to share that would great. Hope to get someone's help…
  • Paperless Office Log Files / Visual Integrator Import - PLEASE VOTE!

    This idea for the Paperless Office/Visual Integrator module was posted over a year ago and could use some votes. You don’t really realize you need this, until you really need it. Currently, the Paperless Office log files cannot be accessed through…