Browse By Tags

In order to enhance the efficiency of our query logging system, we would like to inform you that the current method of logging queries via the existing webform will be discontinued as of March 31, 2024. We are transitioning to a more streamlined process…

In order to enhance the efficiency of our query logging system, we would like to inform you that the current method of logging queries via the existing webform will be discontinued as of March 31, 2024. We are transitioning to a more streamlined process…

We have recently made some changes to the Sage Customer Portal to provide you with an enhanced experience connecting with Sage. Our customers are at the heart of what we do, and part of our commitment to our customers is to simplify and optimise our processes…

We have recently made some changes to the Sage Customer Portal to provide you with an enhanced experience connecting with Sage. Our customers are at the heart of what we do, and part of our commitment to our customers is to simplify and optimise our processes…

anybody knows how i can get the backend SQL query for 'Invoice Lines' for <<sage X3 sale >> under invoices

Hi, I am trying to amend a query from Sage as needed to add in the delivery address details but doesn't seem to be working. Below is the original code that I need to amend and have highlighted in yellow in the table below what I am trying to add - any…

Hi, im querying an object via webservice but it does not return data on the fields that are not from the main table even though those tables are linked to the object. Is this a limitation or am i doing something wrong ?

Currently export a query data defaults to Excel. Is there a way to make more options available e.g. notepad?

I want to show the beginning balance based on a starting date of a check date range in the report query. How would the value from the query field be used? Example: I want to show a running total of accrued vacation hours from each pay period. I need…

Hello everyone, I am running a Query to get some info about a item. Table ITMMASTER ; Field ITMREF ; Others Fields by default. The info that i need is related with a Custom Field, where i need the value of the field and their descripton. Table…

Amount is being posted into In-transit account through inter-site transfer and container management, but not able to reconcile. Hence need a report to reconcile the transactions with Goods In-transit A/c.

Hello! I'm attempting to read a query in Excel, but the query is level 5. Currently when I set the level of the query to 5 via the menu item screen, it comes back as level 1. I can't find any way to effect the end result of what data comes out other…

Hi all, I am able to access analysis periods from StockItem class. However I cannot filter the AnalysisPeriods, lets say Period or Year. There is no Query() function on this class and I cannot use LINQ Where() as well because there is no Period or Year…

Hello community, I am trying to add some description data to a customer facing crystal report and noticed I am only pulling the ID/ Code of the certain fields but need to show the full description of what that id/code is. Trying to add the descriptions…

What I am trying to do is write a query that will list all SEI processes and the Folders they are located in. I can't seem to find any table in the SEI database that contains the folder structure. Is what I'm trying to do possible? My organization is…

I am encountering an intermittent "[ProvideX][ODBC Driver]Internal error" within an Excel workbook containing several worksheets, each of which contains a Microsoft Query (MSQuery) to various Sage 100 Advanced v. 2019 PU 2 files/tables. The query results…

I tried with all possible keys, but I still have a problem with the connections in between the table. Please, can anyone help me? I intend to create a query that presents all shipments and all production follow-ups made on a date and the respective accumulated…

All, Thanks for taking the time to read this. I have an issue with creating a library record via web services. AIM : Create a library Record -> Populate fields with data. Sample Code: ewarebase[] CRMBase = new ewarebase[1];//Allows reference…

I have an SData2 query that works fine for the first page of the pagination, but gives me a bad request for any query where startindex doesn't equal 1. The query is: opportunity?where=oppo_mydatefield%20ge%20@2016-09-01@%20and%20oppo_mydatefield%20le…

HI, I would like to understand if SDATA 2.0 GET API support any query options which would help me in getting selected records. Thanks, BrajMohan

I wrote a SQL query to evenly distribute leads to the user. The query runs perfectly on SQL Server, but not Sage CRM 7.1SP2. Any feedback is welcome! Thanks! The query is below. Here is what I did ,and got the SQL errors. The expected result is when…

I have a list of email addresses that were uploaded against the wrong Person records and am trying to run a query updating the emaillink ELink_RecordID column with the correct person IDs, but the query fails consistently. Any idea why the update fails…

When I try to get all the records in a single query, I got an error from X3 folder. And also tried with $next/$last links, however, we need to call these links synchronously until we get all the records from a table. Is there any chance to get all…

Hi all - I'm using Microsoft Query to extract info from the system and it appears whats happening is if the item has a few bin location the data is being returned in that manner meaning I could have the same item listed a few times Looking for a means…