Sage 100

Hi Where do I set up the rules for when to bring freight costs back from Starship into the Sage invoice? Thank you. Rob

We are running an old version of MAS200, version 4.40. I had to upgrade my laptop due to it's untimely death. I am currently on Windows 10, Office 2019 (32-bit). For some reason, the Export to Excel button that was available on my old laptop is "grayed…

We just upgraded to Sage 100 2019 and would like to know if Sage 100 2019 has real-time API or SDKs to use so we can integrate Sage 100 2019 with connectwise with out making it a manual process. Thanks

Hello everyone! I am hoping to get some help/guidance from someone who might have more experience with the Sage E-Business Module than myself. We're currently trying to implement and install the Sage E-Business Module using the Sage Web Engine and…

Have a client running Sage 100 2017 standard. Client runs a few V/I jobs from the Job Select menu. Problem occurs when the click the job and try running it. The screen closes abruptly. Then, when they try again, the job is locked and does not show…

Is anyone else having any issues with this? It appears to be a conflict between Avatax and Starship. System is Sage 100c Premium 2018 (Version 6.00.3.0); , Avatax Config shows "Sage 100, 6.00.3.0 || 2.0 DSD", StarShip Client is 18.0.3. Some funny…

Good morning everyone, I'm looking to create a reasonable workflow for reporting from sage with SSRS. Currently, we're using report builder with an ODBC connection to achieve this, but even with limited testing we're noticing that this slows down the…

Have a new environment to get familiar with. Hoping to get some clarification on similarities with Sage 100 (ProvideX) and Sage 100 Contractor with MS SQL Server backend. For example, under Sage 100 Contractor, can I still run <File><Run> *info? …

Hello! We just upgraded from Sage 100 2014 Advanced to Sage 100 2018 Premium. Our website for years used e-Business web services / SData integration. All worked fine. And after upgrade all is good, except this small issue - custom rules with shipping…

hi, I am new to Sage 100. Our company bought Sage100 2018 and installed on our windows server. Right now, my goal is to use .net/java/python/php or any other codes to integrate with Sage 100. I found one link mentioned ( Sage Evolution SDK . http:/…

We use the Infor CRM platform and would like to integrate our order processing (Sage 100) so we can produce a sales order straight from the CRM without having to navigate all over the place. Does anyone know if there is an integration between the 2 platforms…

Sage 100 2014 Imported two part numbers using Visual Integrator into the DeleteChange table. Went to the Item Maint/Utility and ran the utility. The parts were displayed with the starting and ending part numbers, each line jhad a unique line no. …

Hello, I am new to the community. I hope someone can help me with this relatively simple problem. I am tasked by a client to send Customer orders from their Wordpress Website to their SAGE 100 ERP. From what we can tell everything is sent over, received…

This is the error message that appears: Error 88 Invalid/Unknown property name. O/S Error Call was rejected by Callee (err/ret=2/0) SY_Excel.PVC. When the user clicks on the Excel button a pop up window appears requesting a sign on to Microsoft Office…

We have an application that wraps around the Sage 100 data base using the Sage 100/Providex 64-bit ODBC driver as a linked server to an instance of MS SQL Server 2014 Express 64-bit. Various views are then defined against the S100 tables in the SQL Server…

We have six retail showrooms. In the past, one of our showrooms served as the distributor/vendor/showroom, and sold inventory to the other showrooms. Now we have a new distribution facility, and have created a new company within Sage. The distribution…

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…

So I have a user with the following setup: HP Elitebook 840 G4 Laptop Windows 10 Pro (1709) HP UltraSlim Docking Station (D9Y32UT) 2 External monitors plugged into the dock Microsoft Excel 2016 (32-bit) (O365) Sage BI Generator Addin 1…

Hello everyone, Is there anyone who would be kind enough to provide us with a tutorial to link Sage 100c (Cloud) v3 to PHP? Thank you.

Access 2003/Sage 100 ver. 2014 Using a linked table in access Can't get figure how to format the date value...keep getting errors. Tried {d '2018-01-01'} =#01/01/2018# ...no luck sql select blahfield, blahfield where table.datecolumn=>{d '2018…

We've built a connector between WooCommerce and Sage 100 Standard using SData and have found that SData has some quirks that have proven to be a real pain to work around. It's also not very well documented (at least the version of SData used in Sage 100…

Sage 100 Access 2003 SELECT IM_Audit.Date, IM_Audit.WorkstationName, IM_Audit.ItemCode, IM_Audit.ItemCodeDesc, IM_Audit.TransactionType, IM_Audit.FieldName, IM_Audit.FieldValueOriginal, IM_Audit.NewFieldValue FROM IM_Audit WHERE (((IM_Audit.Date…

I have a need to delete a Sales Order Invoice using SData and I can't seem to figure it out. When I run an HTTPS DELETE request to https://<sdata-connector-server>/sdata/masapp/mascontract/<company-name>/SO_InvoiceHeaderSPECIAL('0026094') I get the following…

We are currently using the SData Native Adapter with Sage 100 2017 to connect our store application with Sage. I'm trying to decide if it would behoove us to upgrade to Sage 100 2018 and the associated SData adapter. I'm wondering if the new adapter gives…

Complete Error Message <api:MBXML statusCode="10601" statusMessage="Schema Validation failed (The element 'WorkOrderAddRq' has invalid child element 'PurchaseOrderNumber'. List of possible elements expected: 'DispatchTime, ScheduledDate'.)" statusSeverity…