Sage 100

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.

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... 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…

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…

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…

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…

We are in the discovery phase of a vendor integration, previous vendor integrations have just been simple file transfers, no importing into SAGE, all exporting query results to FTP sites. The next integration I want to explore if we can expand on the…

Can anyone share with me the .csv format or what ever format sage needs to import an invoice and payroll time into sage 100 v 2022? im thanks Kevin

Hi, We are having trouble exporting reports and Listings to Excel, because it opens a unlicenced excel. We recently changed to 32 bit, but didn't help. Anyone can help?

Is there a way to import serial numbers when doing a receipt of goods entry?

Our SAGE consultant usually deletes items for us when we have a large amount of unused item codes. I think they do it through VI but I can't figure out which job they are using, they are not to helpful when we ask how did they do that either. Any hints…

I am looking into a way to export electronic payments from Sage in order to be able to import into our banking website to then submit the ACH's to our vendors. Does anything have any experience or guide to doing this in Sage? Thank you!

Hello. How do you configure multiple tables in a import job. I need to make changes to certain inventory items reorder point.qty, min and max order qty. Some data is in the CI_ITEM table but the other is not. I dont see how to add a second or table…

Over the years we have accumulated General Alias item numbers in our inventory that we would like to purge without having to do so one-by-one. Can it be done through VI?

We have a vi job to import data into sales orders, imported data is just on the lines. On this particular SO, #0302719, it does not receive the imported data, reason starts off as "The order total is less t....". Not sure what that means and how we can…

Had a user delete a good bit of repeating orders, we have another live company that we made a backup with, and it contains the orders that were deleted. Is there an easy way to get them into our "live" company without retyping them?

Hello all, SAGE 100 Could Advanced 2020 (V6.20.1.0) I have a VI (Visual Integrator) export job that pulls fields from CI_Items out of SAGE and into a .CSV file. I use Task Manager to automate this export and then another software reads the .CSV files…

We have a client with two company codes that are consolidating into a new company code (using DSD's LMCC). Both source companies have hundreds of credit cards stored in Paya (with SO pre-auths...). This is Premium, so we have some flexibility in the…

At the beginning of the year I am hoping to upgrade to Sage Manufactoring, JobOps, to help improve the efficiency of our end to end process as a metal job shop. Looking for options to extract data from thousands of cut files, as shown: material type,…