Sage 100

We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…

Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…

Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…

Hello, I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table. When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…

I would like to have a list of all email address associated with every account, but I am not aware of a method to do this.

Hello, Everyone has been so helpful in the past, I thought I would ask about another issue I am having. While trying to delete some items through the "Delete and Change Items" Module I receive the following Error Message for each of the items…

Hello, I am still having an issue with imported product item numbers being skipped. I do not know what could be causing this as I have successfully imported 250,000+ items with the same number scenarios. Has anyone else had this issue and if so, how…