Sage 100

Hi Sage Team, We run Sage ERP 100 Premium 2021. We have a few line items in sales order, most of them in Quote, we can not update or delete these lines, and all these lines are show in top in sales order entry detail panel. We checked these lines…

I'll like to obtain all table names that have the warehouse code field in it. E.g. AR_InvoiceHistoryDetail, AR_InvoiceHistoryHeader, PO_ReceiptHistoryHeader,etc. Not sure if this can be achieved via a SQL query. Thanks.

Hello every one. Whenever i am trying to open the data file with Sage 100 trading i7, the error shows as "The system cannot find the path specified". can any one help me in resolving the issue and getting the data please?

When running a report I get the following error. We use to not get this error when we run a report for a year but now, we cannot run it for more than a week. What do I need to do to correct this error. Description : An overflow occurred while converting…

Hello, Have a general question on Data Purge. How often is it done? How many years are the Norm to keep? We have many many many years of data probably going back to 2008 or so. and our backups and cloud back ups are taking too long due to the size…

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.

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…

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…

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…

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?

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…

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…

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

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…

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…

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.

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?

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…

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…

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?

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…

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.

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…

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…

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…