Getting Available Inventory Quantities

I am working on a C# .net desktop application that needs to be able to connect to Sage 100 2017 and retrieve available inventory quantities for all products. I've run into a complete brick wall trying to figure out how to do this. I have several questions:

1) Is there any reference material for the inventory module objects? The help file provided as part of the Sage University course on using the BOI does not contain any reference to it at all. Sage will not help beyond referring me to the $99 course I already have and it is nearly impossible to find code examples in Google.

2) How specifically do I query inventory levels through the BOI? I saw another thread refer to the IM_ItemWarehouse_bus, but I have no info on this at all.

3) Is there a way to retrieve inventory levels for all items?

4) Are there other ways of connecting to Sage 100 beyond the BOI? I've seen reference to ODBC but cannot find any information, which is maddening.

Thank you for any assistance you can provide.

  • 0

    Pulling with ODBC is about the easiest thing there is. Just connect to the SOTAMAS90 DSN or create a silent DSN and pull out the Item Warehouse file. People do this all the time with Excel or Access.

  • 0 in reply to BigLouie

    You can't find information on ODBC because it is an everyday thing for most of us. 

    For Premium, that is SQL and information on connection strings can be found anywhere.

    For Standard / Advanced, that uses a proprietary driver.  When you run Sage 100, a user DSN called "SOTAMAS90" is created / recreated with the correct connection string.  This is an example from my test system.

    To hard-code authentication / company selection, add these to the string (which will be different on every system, due to different paths, and Advanced also has a Port #):

    UID=username;PWD=password;company=MAS_###;

    ...where username / password are Sage 100 credentials.

    You can also look into creating a "silent DSN", which is detailed in a few places.

    Note: Sage 100 has optional ODBC security, which would be controlled by the system administrator.