• Accessing the Sage 100 ODBC Driver from a Web Server

    FormerMember
    FormerMember
    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…
  • Store front interface with sage100

    What is anyone using for an online ordering system that interfaces with sage 100? thanks
  • Fed Ex Data Integration - for Return labels when using RMA

    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…
  • Sage 100 Standard - link to SQL server possible?

    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…
  • speedtax Sage 100c compatibility

    Is Speedtax compatible with Sage 100c?
  • set Payment type based Division number

    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…
  • VI commandline execution issue

    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…
  • How can I retrieve next usable sales order number via the SOTAMAS90 DSN?

    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…
  • Accounts Receivable invoice number field size in Sage 100 ERP

    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…
  • Website integration

    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…
  • Multi-Bin table or data changes?

    We plan on using the multi-bin module to help our inventory process. www.acsg.com/multibin.html The question I have is, does the multi-bin module make any table or data changes to the IM_ItemWarehouse table? We rely on this table heavily in our…
  • SO_InvoiceTracking failed field "Starship is not integrated"

    Is there any way to update these fields without the Starship integration? I have created UDF fields that store the data in the exact same table, but why would Sage lock specific fields to just one software vendor? I would just prefer not to have to use…
  • SData Error when using PUT on SO_InvoiceHeader

    I'm implementing an update operation for our integration and when I attempt a PUT operation I get the following error: This entry already exists in batch SERVO. Here's the raw request: PUT ~/sdata/masapp/mascontract/abc/SO_InvoiceHeader('0100117…
  • SDATA Error Message When POSTing/Creating AR_Customer

    When attempting to use SDATA to POST an AR_Customer, I'm receiving an error: <sdata:diagnosis> <sdata:severity>error</sdata:severity> <sdata:sdataCode>ApplicationDiagnosis</sdata:sdataCode> <sdata:applicationCode xsi:nil="true" /> <sdata:message>Exception…
  • Cash receipts import job message pop up on every record

    The import job will work correctly, but we have to click OK for every record that is imported. The job has worked for years, starting in Version 4.3, possibly even as far back as 4.1. Any ideas on how to prevent this message from showing for every…
  • Sage 100 ERP and Docuware - anyone had any experience with this?

    Have a client who just purchased Docuware (document scanning/paperless) and is trying to get it to work with Sage 100 ERP advanced. Install tech wants to use the Sage 100 ODBC drivers to extract some information, however we are not having a lot of luck…
  • EDI Solutions with MAS100

    Hi we are a wholesale furniture importer, and we currently use Gentran Director which we manually pull the 850s into director and then manually import the 850s into MAS100 using VI. these processes are manually done now. Gentran Director is running…
  • How to run a bat file from VI Perform?

    I am trying to run a batch file via the Perform logic of a VI job. In a nutshell, I want the VI job to create a file in a specific directory so that I know the VI job has completed. I have added an On Completion Perform Type to the job and set the command…
  • VI Import POs with Misc Item Codes - fail with default warehouse error

    I am attempting to import purchase orders through visual integrator into Sage 2014. The PO line items are comprised of misc item codes. When I test the job, it passes and shows all lines are okay to be imported; however, when I actually run the job…
  • Integrating Sage 100 with MES

    How can Sage 100 be integrated with an existing MES system. Are there APIs built into the Sage application for ease of integration?