Sage 100

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?

Is user data backed up, and if so, is it backed up to a third-party solution? what about Hosting Platform, Can you provide detailed information about this ?

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…

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…

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…

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…

Moving from the Progress DB to SQL Server version discount percentage type columns are decimal(7,3) but in the old version it is decimal(8,3). Also a lot of other decimal columns went from (16,6) to (15,6). How have people handled this? It is breaking…

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

I have been attempting to simply change the data type of a column for a query I am running through the ProvideX ODBC but I keep getting errors, and I am wondering if this scalar function is not available here. Simply, I am trying to query the IM_PeriodPostingHistory…

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?