Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
How do I get the SData GET to return only the XML with the requested data items? It is currently returning a ton of unwanted HTML that is a waste to transmit on every GET. I have tried different Content-Type options, but nothing I tried has worked:
…
Hi,
I am trying to import/create a Purchase order and have 'Assign' operation for Vendor No and still getting an error : "L record AddLine() failed. The Vendor number is required. "
-Column position is correct
-Vendor exists in the system
I don…
My Company is trying to setup a system to access our Sage database to report to our cloud CRM software. We are trying to use PHP and a local web server to access the ODBC driver for Sage on our local area network. We are currently working on building…
I am using SData for Sage 100 to create invoices for AP. I am able to create an AP_InvoiceHeader and a single AP_InvoiceDetail line item using the AP_InvoiceHeaderSPECIAL template including the standard AP_InvoiceDetail. That works just fine.
The issue…
During our RMA process we like to have FED produce a FED EX return label and email it to the customer. I have the data integration established with FEDEX Ship manager software and i am able to create the Shipping / Return label from Shipmanager.
I would…
Hi There...
I'm working on an ecommerce integration using sData ( and PHP ) and I'm having trouble trying to create a sales order. I'm getting a message " This Order has no lines and has zero total amounts " back from the server. I know the issue is…
Hello everyone,
We have a solution on Sage 100 5.10.01 but it has to be deployed on Sage 4.40.0.2.Does it support Custom office and User-Defined Script..I tried to finds some information of compatibility and it`s turn out that version 4.40 is retirement…
Hello,
We run Sage 100 2015 with eBusiness Web Services on top to integrate order entry from our website (which runs on WordPress/WooCommerce). Everything is working perfectly passing orders through up until we try to expose UDFs. In the eBusiness…
Ok,
So I'm new to this forum, so I apologize in advance for any breach of protocol.
Basically, I have set up a DSN on my server running MS SQL, and it works fine. I can see all of my tables (but not fields) for Sage 100 Advanced ERP in SSMS - Great…
We want to create an integration between Sage 100 and a SaaS product. The SaaS product puts constraints on the number of external operations per day. (By "external operations", I mean sending data to or receiving data from software or a service other…
Can you create a linked server in a SQL 2008 R2 x64 environment to SAGE 100 Standard Edition 2016?
We understand Standard is 32bit and have a 32bit ODBC System DSN setup(with system DSN), but the database is not coming up in SQL.
Here is one…
I have a VI import job and I want to set the payment type to be "CHECK" if the division is "01" and "WEB" for anything else. I have read a few posts and seems I need to do something with Temp fields, I'm not sure exactly what to do with the Temp fields…
Sage 100
58 users seats
ver: 5.10.7
I'm getting an error running the following query against ci_item:
SELECT Count(*) as NumRecords from ci_item
There's 90,000 items in the ci_item table.
Works fine on my development system.
I'm having a bit of an issue launching VI from command-line when not logged in to a user account. Below is the contents of the .bat file
cd /d Z:\mas90\Home\ PVXWIN32.EXE ..\LAUNCHER\SOTA.INI ..\SOA\Startup.M4P -ARG DIRECT UIOFF user password GFU VIWI02…
We are running v4.50.5.0.
I am currently using php to compile new sales orders data from Ebay, PayPal, OpenCart etc then connect to the DSN and query SO_SalesOrderHeader and AR_InvoiceHistoryHeader to retrieve the last # in the 08XXXXX range which we…
Installed a test version of Sage 100 2016 Advanced on same box as version 2013. Now we get "Service disabled by Sage 100 System Configuration" when we connect to SData.
Tried reinstalling SData from the 2013 media. Same message. Permissions and External…
As our Amazon volume continues to grow, I created a VI job to import Amazon orders using a .csv file. That .csv file is readily available as a download directly from Amazon.
The import itself works fine, but the issue I'm having is that the .csv includes…
Okay, so let me start out by saying that I've searched these forums and Google for the last few days and while I find many similar situations, I still haven't been able to find a solution to my problem. I have setup linked servers in SQL and they have…
Hello,
Has anyone purchased/recommend a third party solution that increases the Accounts Receivable invoice number field size from 7 to a larger field size for Sage premium 100 ERP? If so, is there additional AR functionally included?
Thanks!
B…
We are running Sage 100, Server 2008 and win 7 workstations for the terminals.
There are only 2 users, and I've eliminated the firewall/network as the issue (that I can do, erp not so much).
Sage seems to take forever to pull up the forms on Starship…
We have a customer currently in v4.3 (waiting for SWK POS) ready to move to v4.5 within the next 4 weeks. They are building a complete website with ecommerce using Magento (?). What integration tool would be best to use to integrate (read/write) data…