• Connect multiple UDFs so selecting one will display extra info to be used in Crystal Reports

    I added a tab to my Invoice Data Entry panel with UDFs I want to be able to select an option in "SCAC Code" which will then display the proper name of the carrier outside of the SCAC Code dropdown. I want the SCAC Code and CARRIER NAME to be separate…
  • Generate PDF from UDF and create save/email functions from Sales Order/Invoice Data Entry custom tab

    Hello everyone, I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions: Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…
  • 100 perpetual change to 100c vs. version upgrade

    We are currently running Sage 100 v. 2013 perpetual license. We renewed our contract and changed to 100c as we eventually want to upgrade to premium. We also want to upgrade to 2018, but we have a lot of customization, so we want to don't want to make…
  • Moving data to another Sage 100 and CRM installation. - Not Merging

    FormerMember
    FormerMember
    Hello I have two Sage 100 ERP installations that have CRM integrated into both of them. I have 4 Sage servers in total which make up two CRM and two Sage 100 installations. I have two companies one company sits on the Sage 100 and CRM in California and…
  • UDF using script

    Hello Everyone I am trying to update UDF in sales order line using script, i am not getting any error but it's not working i am adding the the code that i am using any kind of help will be really great Thanks ____________________________________________________________________________________________________________…
  • Sage 100 Premium ERP 2013 ebusiness web services error?

    hi, I am new to sage 100 premium erp. I tried to access the ebusiness web services via soapui. But getting the error " An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB; ". Please advice me.
  • Creating Sales Order with Payment/Transaction data

    FormerMember
    FormerMember
    I'm trying to create Sales Orders within Sage 100 via C#, but I've been having trouble including payment information. I wonder if anyone could please help get me on the right track. I've been able to set a Freight Amount, but I've not be able to set any…
  • Does uninstalling Sage 100 2013 premium require reboot

    If I uninstall Sage 100 2013 premium from server, does it require you to reboot the server?
  • E-Business Web Services Bug With Shipping Address

    I have a tool that creates Sales Orders and Customers in Sage MAS 100 ERP 2013 through the E-Business Web Services. These Sales Orders and Customers come from an E-Commerce website. Sometimes, the Billing and Shipping addresses are the same, and at other…
  • BOI Sales Order Printing Issue

    I have looked at the threads on printing Sales Orders with the BOI, but am not having any success replicating what I found. I am getting the error "Data not selected for report printing." Can anyone look at this and tell me what might be happening…
  • Upgrading several versions

    We are currently on Sage 100 Advanced 2013 with no third-party customizations and looking to get up to 2016. Are there any advantages to doing so one step at a time (first 2014, then 2015, then 2016) or is it better to do just the one conversion? I'm…
  • Updating Credit Card Expiration Dates

    We are on 100 Advanced 2013, and have some automated processes that import sales orders through the BOI. We have a number of repeat customers who have been customers for years, and occasionally they use a card that they have been using for several years…
  • Printing From Shipping Data Entry

    Sage 100 ERP 5.00.8.0 We are adding a button to our Shipping Data Entry that calls for a print of an invoice based on a Sales Order Number. I am consistently getting the following two errors: 1) "The S/O0000000022SO_INVOICEPRINTING_UI STANDARD 00001…
  • Shipment packaging problems after updating to Sage ERP 2014 Update 4 (5.10.4.0)

    Hi Forum, Our shipping software' packaging logic fails after customers updated to Sage ERP 2014 5.10.4.0, due to the new Sage ERP Shipping Data Entry verification of packaged quantity to be matching shipped quantity. It is described in Sage release…
  • Setting up sData

    I am testing an upgrade to Sage 100 Advanced ERP 2013 and saw the sData installation. I can't find the install document anywhere, though. Does anyone have a document or link on how to get this set up?
  • Script or import to take AP Invoices off of hold

    I have a customer who wants to take AP invoices off of hold based on the condition that the AR invoices that go to that invoice have been paid. I ran into an issue with VI importing where I can't get it to let me take an invoice off of hold (This is for…
  • Business Insights explorer

    Is there a way to tell what tables the different views are using?
  • Jet Reports and SAGE ERP 2013

    Howdy, have a customer that has created a new balance sheet for entire year using jet reports. The issue is performance. The report is complex with adding debits and credits for each balance sheet account, for each period of the year. The report takes…
  • Update Purchase Order line UDF during receipt of goods entry

    I am trying to update a UDF in Purchase Order entry lines during a receipt of goods. The issue I am having is that the purchase order record is locked while a receipt of goods / invoice records exist referencing the purchase order. Here is the code I…
  • SAGE ERP 100 2013 64-bit ODBC errors on SQL server 2008 64-bit

    Howdy, I am trying to create a linked server on a SQL 2008 64-bit server. Using the SAGE ERP 100 64-bit ODBC. I want to link some of my MAS tables with SAGE CRM. The Linked server is setup to not use a security context. The query reads like…
  • How to write User Defined Script to calculate Discount?

    I need to let the system to calculate a discount based on Sales Order Header - 4. Totals -Order Total. The formula will be 5% * Order Total . I need to create a UDF, UDF_DISCOUNT, under Sales Order Header - 4. Totals Tab to show this amount. I don…
  • RE: How to Add UDF to PO Detail Table from PO Header Table

    Thank you very much. It works. However, how to get value from different module? For example, I want to get value from PO header to add to open sales order table. Also, what are all abbreviation of different type of tables, such as header table, wrk…
  • Crystal Reports for Sage 100 2013 does not print the MICR font

    I just upgraded a client from 4.3 to 2013 and their AP Checks print correctly with the MICR font in 4.3, but the MICR font does not print in 2013. I checked the form to make sure the MICR font is selected (even tried the MICR Std font) and it won't print…