Browse By Tags

  • I am trying to join the PORDER table to the SINVOICED table

    Good morning Sage City, I am creating an invoices tables with the base table SINVOICED, I need to JOIN PORDER table to my base table but am unsure of how to do so. How can I go about doing this?

  • llamada a procedimiento almacenado de sql server por código desde un elemento de Cálculo

    Buenas tardes. No se si este es el lugar adecuado para hacer esta consulta. Quisiera saber en sage 200 si es posible ejecutar un procedimiento almacenado de sql server desde un elemento de Cálculo del repositorio, si existiese alguna función de sage…
  • SQL Server Topic - Max Degree of Parallelism

    SQL Server Topic - Max Degree of Parallelism

    Last month in June, I wrote about capping SQL Server's memory so that it does not use up all available memory. You can read about it here . In this blog, I want to look at another setting in SQL Server, and that setting is the Max Degree of Parallelism…
  • SQL Server Topic - SQL Server has to know its limitations

    SQL Server Topic - SQL Server has to know its limitations

    The main objective in this blog is to draw your attention to SQL Server and the min/max memory setting . Why is this setting important? Well, SQL Server is a memory hog. It would take all the memory if you let it. SQL Server has got to know its limitations…

  • Consolidated billing query with AR_InvoiceHistoryDetail

    We are trying to write a query or stored procedure to identify the cash receipts for each of our franchises (warehouses) but ran into some trouble with consolidated billing. Since payments aren't applied to the line items we need to create a lookup table…

  • Collation de Sql Server

    Bonjour, Chez un client on a installé la langue Anglaise, puis en changant la langue dans l'application un message d'erreur appraitre : Suite à des recherches de la source de l'erreur on aperçois que la collation du serveur et de la base de donnée…
  • Limit SQL Server memory to a fixed amount

    Limit SQL Server memory to a fixed amount

    Have you ever noticed that SQL Server loves to use memory, even when there is not much activity happening on the server? Is there a way to manage the amount of memory utilized by SQL Server? Yes, you can limit the amount of memory SQL Server can use.…

  • SQL Replicator and the table PRM_MASTER__EMPLOYEE_TAX

    We just installed SQL Replicator and previously used Anterra Datacenter. The table PRM_MASTER__EMPLOYEE_TAX has a field called Tax_ID that, when using Anterra, held Tax ID's like FED, MED, MED_E, etc. Now, using SQL Replicator, that has changed to a long…

  • Sage 100 Premium - SQL Server User Permissions

    We're looking into upgrading from Sage 100 Standard to Premium. Currently we do a lot of connecting directly to the database via ODBC for querying; our AP users query the AP tables, our Payroll users query the Payroll tables, etc. I don't want these two…
  • How to find the SQL Server version from a bak file

    How to find the SQL Server version from a bak file

    If you work with lots of different SQL Server backup files, is there a way to find out what version of SQL Server they came from without having to restore it? Short answer, Yes! If you work with many backup files from different versions of SQL Server…

  • Sage EM V12 & SQl SERVER 2014 R1

    Bonjour, Quelqu'un a réussi à installer la dernière version de la V12 ( V12.0.21 - 2020 R1) avec SQL SERVER 2014 SE R1 je reçois ce message lors de la configuration de la base par la console. merci par avance

  • Latest V12 & SQL SERVER 2014 R1

    Hi everyone someone has successfully installed the latest V12 update ( V12.0.21 - 2020 R1) with SQL SERVER 2014 (not R2) I receive this message while configuring the database by the console any help please

  • New GL Accounts for 200 Companies

    For FFCRA, we need to add the same 4 new GL Accounts to over 200 different companies. Does anyone have a suggestion on how to "automate" this process? We are using Sage 100 on SQL Server. My background is in MS SQL Server database management and development…

  • Microsoft Azure Environment

    Hi, One of our new customer is looking to implement Sage X3 ERP in Azure environment. They have a couple of questions which I have to answer before the Azure services procurement. Web Server: Can it be hosted using Azure App Service? Database…
  • Alert! (Part 1)

    Alert! (Part 1)

    In this blog I want to introduce to you a tool you can use directly from Microsoft SQL Server. The tool I am talking about is an Alert. The function of an Alert is to notify you when a particular condition has occurred. This is similar to when running…

  • non MAS database on MAS server? (Sage 100c SQL)

    Sage 100c 2018 SQL server I want to add a database to my production Sage 100 Server instance. Will this cause any issues with Sage 100? I may also be able to use a linked server, but I'm not familiar with the limitations there, either.

  • Using a Table-Valued User-Defined Function to return data

    This article has been triggered by a question from a customer asking about alternatives to using views for returning data into the interface. They wanted to know whether views were the only way in which data can be accessed. I have looked at the use…

  • Custom Field Search

    In CRM, the custom tables store metadata for any new fields, screens, lists or entities that are created. Sometimes when I'm working on the front end that has been heavily customised, I may need to find where a custom field is referenced in the application…

  • Changing a Checkbox to a Selection list

    Checkbox fields are brilliant for letting a user quickly collect certain types of data. But they do have their limitations and you may discover that you want to be able to store answers such as 'Y' (Yes), 'N' (No), 'M' (Maybe) rather than a simple 'check…

  • Sage CRM SQL Server running on a VM in Azure

    Can Sage CRM run using SQL Server running on a VM in Azure?

  • Sage 100 2019 SQL

    We are currently on Sage 100 v2016 Cloud and looking to upgrade to v2019. Is there a 2019 SQL version or only Provide X? I see a few years back that Sage 100 Premium was available but nothing recent.

  • MAS 90 Providex to SQL Conversion / Archive Reporting purposes

    FormerMember
    FormerMember
    Hello, I am completely new to this. I am a SQL DBA and I have been asked to take our OLD MAS90 system convert the data to SQL and write reports to allow accounting people to find data from our old system. We currently use MS Dynamics NAV. We switched…

  • Is Sage 100c 2018 compatible with Microsoft SQL 2017?

    FormerMember
    FormerMember
    We want to upgrade our version of Sage 2017 to 2018 and at the same time start using SQL for our database. With that, we would need to purchase a license of Microsoft SQL. The documentation states that Sage 2018 is only compatible with SQL 2017, however…

  • For UPS WorldShip where do I grab the ShipMethod for a sales order?

    Does anyone have a recommendation of where I can tell UPS to pull the ship method for a sales order? UPS wanted to use the tsoSalesOrder.DfltShipMethKey, but we noticed that wasn't the correct ShipMethod imported from EDI. Once a shipment was generated…

  • What's the latest build of SQL Server that you're safely using with Sage 100 Premium?

    Hi all! Just curious what your experiences are because Sage doesn't officially validate individual SQL Server builds with Sage 100 Premium. If you can supply the version of Sage 100 Premium (e.g., 2017 ) and the SQL Server build # (e.g., 12.00.5546…

*Community Hub is the new name for Sage City