Sage 100

I have seen two unrelated instances of a single random line showing up on my invoice when generating one using the path sales order, main, invoice data entry the GL detail report that I printed early May for our April rebill, as well as the latest…

We are trying to update the Daily Labor Register /Update showing below: but are getting the below error. The problem is a missing employee number (really have no idea how the employee number is missing, but it is, possibly some sort of system glitch…

We have Sage 100 Enterprise at the company I support. Performance directly on the host server is lightning fast, but on client PCs over the network it is painfully slow, especially when printing to paperless and opening Adobe Reader. I have followed every…

looking for anyone who has a download of Mas90 3.61

Does anyone know if you can add a UDF field in Inventory Maintenance that shows the date of the last price change?

I have a button script located on a Cash Receipts Entry screen. Sage disables it by default until a customer number has been entered. The purpose of the button is to assist the user with locating the customer number, so this doesn't work for our use-case…

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…

we are attempting to delete a SO. we have successfully done so to other SO but this one item gives us an error #47 Substring reference out of string and we are unable to do anything.

Fairly new to most of Sage. From what I've heard it's not possible to migrate MAS 200 into Sage 100 because of different tax structure setups. We run MAS 200 v4.40 (listed in install as C:\M200cs\V44\MAS90), Sage CRM 200, and Sage 100 2017 v5.40.0…

When invoicing RMA's, we use logic in a custom script to set the cost account key and the sales account key on the line items based on based on the customer division. When I go to the newly created invoice, the sales account key has the correct value…

All, I'll try and be concise. I am working with Sage100 2019 and Visual Integrator Jobs. We just moved up from Mas90 4.3. Whoa, I know. Here's my dilemma: In Mas90, we had a VI job that would bring in website orders in a csv formatted file and import…

Running MAS90 4.4. We've been getting this problem intermittently for some time, but more frequently of late. Customer information and Line items from sales orders previously entered (normally the sales order immediately before the present) are printed…

I have a dilemma with a client. Company has an a/r account with many outstanding invoices that have been "donated" to a particular client. However, the salesperson has done the donation and the owner has offset all of these "sales" by deducting them from…

Hi, We're running MAS90 v4.12c. The database is on a Server 2008 R2 64 bit system. but nobody logs directly into the server. Workstations are Windows 7 Pro both 32 and 64 bit systems. Everything has been working for quite some time now. Is it…

We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…

Hi I have a business requirement, where we have a Date Field1 and Date Field2 , while entry of the details data, Field1 will get the date auto defaulted from the header date field. And Field2 will be blank . Later when there is an update on the Date…

I have a client that uses Sage 100 and we've developed a product using Sage 100 integration for work orders. Lately we've been seeing Integration work order errors like this: "Error in D:\Sage\Sage 100 Advanced\ MAS90 \SY\SY_SDataServer.pvc at line…

Hello Sage City - I need to rebuild an old environment with MAS90 4.5 and FRx 6.7 with the latest service pack. SAGE support said they don't have it, and directed me here. I believe there is SP12 for FRx 6.7 out there. If anyone still has it - would…

Does the Connector support UNION Queries for Sage 100 Data? Have a simple UNION that just doesn't seem to work. See sample below: Select JT_Transaction.SalesOrderNo as 'SalesOrderNo' , JT_Transaction.TotalCost+JT_Transaction.TotalLaborCost…

I'm running into a problem with an import job from Excel where the VI Job passes in Test mode but not when executed. If there is more information needed please let me know and I will try to get it. Keep in mind that I was not fully trained in this…

We are working on an eCommerce site that is linked to our MAS90. I have an import job created that I use for internal price updates that uses the CI_Item table. I am wanting to add an Update Date field to the Import Job, but can't find that anywhere…

Questions: 1. How to check status completion of VI Job? (see picture 1) 1. What Sage MAS 100 table and field should we use to determine VI Job status using ODBC? 2. Is there other way to run VI Job without using PVXWIN32.EXE? The problem description…

Questions: 1. Is there any option (bypass) for access to Job Cost tables via ODBC driver? 2. Is there any option (bypass) to decrypt employee encrypted data from external app? 3. Which of tools are recommended for reading data from Sage Mas 100 in replace…

I am receiving the above error code when trying to process a work order transaction batch. Has anyone seen this error before?

I am new to Sage, but have some experience dealing with Aptean's Ross ERP at my previous job. I started working for a company this year that is still using MAS90 and has only been utilizing the accounting/payroll relevant modules. As far as I know, we…