• Can I restrict invoice dates when posting invoices in A/P Invoice data entry , and also when receiving invoices in on a PO?

    I have run across some posting errors, right now you can use any date in any future year and the systems accepts it. This creates huge problems if you don't discover it right away.
  • ItemCode and Alias Item Code are the same

    I am working on setting up alias item codes for a few different customers. Certain customers get specific item codes that are unique from the standard library of item codes. However, I am running into an issue where I cannot setup an alias item code for…
  • Importing Kit Item Code Components

    I had an issue with running a VI job to import components for kits in the past, but now I am drawing a blank on why the import is not running correctly. It looks like the import is finding the kit item code but not finding it when it goes to import the…
  • Has anyone noticed that when creating a support ticket on the Partner Portal that the most recent Sage 100 version is 2022?

    I just created a helpdesk ticket, and here is the pull-down list for Sage 100 versions: Call me crazy, but shouldn't 2023 and maybe even 2024 be on that list? Side note: when creating this post on Sage City (or whatever they call it now), I am forced…
  • Automatic download from sage100

    Dear experts, I want to create an automation that will download excel files from sage100 to the dedicated folder on my computer everyday morning without any kind of human intervention. Is it possible to do?
  • Correct ODBC Drivers to pull data from Sage 100 Contractor into Power Query

    Hello, I am trying to connect Sage 100 Contractor to Power Query. I downloaded Microsoft ODBC Driver for SQL Server and was able to add a DSN to connect to our Sage database. However, all the tables are strangely formatted and it is hard to read the…
  • Sage 100 Visual Integrator for Sales Order Entry

    Typically for Sales Order/Invoice Data Entry, I input the Invoice No., Invoice Date, and Sales Order Number. Sage then auto populates a majority of other data. I move to Lines and say Yes to ship the complete sales order. I want to streamline this process…
  • Invoices deleted

    By mistake I delete the complete batch of the invoices and I would like to know how to restore them can you help me??
  • VI Automation behaving oddly

    I have a Batch file that has been running VI jobs for years. But recently some of it hasn't been working. The batch file calls 2 separate VI Import jobs, with a timed pause between. The first VI job runs fine, and loads the data without issue. The…
  • Zip Code Removal on US Country

    Hi, I'm having an EDI PO import error that says zip code "33966" for Fort Myers FL is used in more than one country. I exported the SY_ZipCode table and found it listed for both US and USA. Would someone be willing to suggest a method for removal…
  • Visual Integrator

    We recently had two customers combine and now have a new company name. I am trying to use visual integrator to update their ship-to address names (all of them - not just primary) and I cannot figure it out. Thank you in advance for any info.
  • Error message while trying to print sales order in MAS 90 V 3.22

    Got this error message when printing sales order in was 90 v 3.22. Was able to "end" and print sales order. Error 262. Program SOZREB. Line 5305. I have no idea what this means. Any help?
  • VI Job for IM_ItemMemo

    Hello, Was trying to create a VI import job to add an item memo for a particular vendor items. When an user enters in the item during SO entry it would auto display letting them know they must call vendor for quote. However when attempting to create…
  • Merging Items

    I am getting this error when trying to merge items, I am assuming in is an Insynch table but I don't see it in the SQL DB. Any ideas? Also have about 24k items we want to merge, importing into IM_DeleteChange table and running the merge utility is the…
  • Where to see Task Schedule completion?

    This is all done on a test company. I am running a task through Task Scheduler, but am not seeing anywhere that is has completed running. I've looked through the logs with no indication of completion. Anyway to see completion?
  • Import Error

    I am receiving an error message when clicking on any template in the task scheduler. Here is what happened. How it happened: Library Master > Task Scheduler > I ran IMPORTITEMS (worked great until I put all the imports into script). It has been…
  • Opening Balances of GL

    Hi Team Please help to locate the Opening Balance column/field in the GL table list. Or how can we get the Opening Balance/Closing Balance data from Sage 100 ERP. Thanks Thulasi.
  • Product in Shipping but no Sales Order To Review

    Hello Sage Community, Todays question is how to find order(s) in shipping that I cant find! In the image below, I have the part in Shipping and cannot find it!! I've reviewed numerous orders and shipping batches that are not updated yet, they are nowhere…
  • VI import

    Hello... I'm trying to create VI jobs that will update the Customer Price Levels. I have two tables with fields I need, CI_Item (itemcode & Vendor) and the IM_PriceCode (Price Method, CustomerPriceLevel and DiscountMarkup). So I created one VI job to…
  • Full Inventory Inventory List w/filters

    Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
  • UNABLE TO UPDATE SALES ORDER JOURNAL IN MAS 90 V 3.22

    Unable to update sales order module. In Mas 90, I Get Error Record M/CU is Missing from syoctl.soa. when I click on master console. I Also get errors unable to update sales order journal. A not on file customer has been encountered. and an invalid or…
  • OLD MAS90 IMPORT TRANSACTION PROBLEM

    Hi guys.. I just tried to "import transactions" (Xchange tab) with DIF file on my MAS90 ver3.4 (it's very old. It's time to upgrade... anyway) All thing's going well except 'year'. For example, whatever I key in or put in 12/31/23 or 12/31/2023 or…
  • CHANGING MULTIPLE ITEMS "INVENTORY CYCLE"

    Hi all, Boy I sure wish it was easier to look up SAGE help ANYWHERE on the internet... I need to modify hundreds of items "INVENTORY CYCLE" code/status. We just did Inventory and out of 87 pages printed, there were actually only around 6-7 pages of…
  • Importing Vendors

    Hello, I am running into an issue when importing vendors. We are mass importing items along with the vendors, but are running into a block on the vendor import. It appears that this popup might be blocking the vendors from being imported. Is there…
  • IM_QTY Inconsistency

    Still having issues with incorrect data in IM. Items are on SO's but are not showing the correct quantities on the header tab under "On SO". Rebuilt sort files last night, not sure if I can try something else or do I need to report to SAGE? This item…