Hello,
I am generating a sales report from a custom view and the report seems to run ok, but it ignores things like capitalization and the removal of apostrophies and stuff like that. Has anyone experienced this? Please see attached images.
…
Hi All,
Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script.
I right clicked on the…
Hi
I have a customer with a v12 installation with multiple folders (SEED, PILOT, X3). Every folder is somehow pointed to the PILOT data. I have checked SQL, and the normal SEED data is present,. If I add record in any folder, it is reflected in all…
Where can I find the information I need to calculate customer aging over time? Usually when I get stuck I can copy something one of my predecessors did, but no one knows of any report like this previously.
I want to be able to show a sales person, for…
You may have created some custom views in your Sage X3 system but are finding them slow to execute. The first step in diagnosing poorly performing SQL is often checking the SQL execution plan, but how can you do this with Sage X3 custom views?
First…
Boa noite,
Tenho um servidor de dados em ambiente Linux (Ubuntu) com o Microsoft SQL Server 2019 (Linux) instalado. Gostaria de configurar o Sage for Accountants para trabalhar com SQL da Microsoft em Linux. Alguém já o fez?
Obrigado Luís Freire
Hola,
hemos entrado este año en el SII, y poco a poco hemos ido notando como la pantalla de entrada (preparación), cada vez es más lenta.
Me explico, al darle al proceso se queda en una pantalla 6 minutos y luego acumula. Y repite el mismo proceso…
History of Question: * The SAGE 100 Con database had over 30 companies in it and performance was "sluggish." * Backups were made of all companies and copied to another server for safekeeping. * A 2nd SQL instance was created and all companies between…
Me gustaría saber como hacer la consulta SQL de la venta del día para una fecha determinada y cada uno de los almacenes.y el importe de las formas de pago
me pueden ayudar
Gracias
Running Sage 100 Premium 2021: need to reduce the size of the AR Invoice History tables. The purge invoice history utility is good as far as it goes, but I need to remove invoices for only one division that creates thousands of repetitive invoices monthly…
We have recently been contacted by our Sage Support, telling us our Sage 200 system needs upgrading.
We are currently running on Windows 2008, and the support have told us Windows have announced they are turning off the server(?) that our Sage connects…
Hi There.
We are discontinuing a service with one of our Sage consultants. We wish to take on Transaction integration inhouse (SQL environment).
What is the best way to go about this? Do we have to use a consultant, or can we adapt this technology…
Want to upgrade our Windows servers to 2019(from SBS 2011 and 2008 R2) and keep Sage 100 2016 for now. I have read that SQL 2008 will install but should not be used in a production environment. Wondering what is the newest version of SQL that I could…
On our picking list report we've got a join to an SQL view called 'SOPAdditionalChargeView' which is used to display the additional charge line for the order at the top of the picking list. Without going into too much detail I have added a column to this…
Version: Sage 100cloud Premium 2020 (Version 6.20.0.01)
Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming
Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…
Good Day Community,
Once again we enter the Year end period and everything that goes with it.
Please remember that if you are using SQL Point of Sale or Debtors Manager, there is a right way and a wrong way to run the Year end.
You CANNOT run the…
I have query in the Graphical Query Tool that I'd like to see the actual query executed. How do I see the query in SQL syntax? I want to see the tables and how / what they are joined. Is there a way of doing that?
Hi, as the subject says, I am building a report to pull sales numbers per company by GLCode in sql server. I'm having a hard time getting data that looks correct. I have tried a few different ways of joining SORDER table to GACCOUNT table. I've tried…
The releases above include new definitions of clustered indexes for SQL Server, to be created when the update is applied. The data indexed in a clustered index is stored in the index area of SQL Server. As a result, this might move data in your database…
Tenéis algún recurso o vídeo de como funciona el addon de informes personalizados?, no logro entender como funciona y como atacar a la BD, no veo nada para poner código SQL.....
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…
We are having issues with our Procore Connector so we are trying to troubleshoot the issue. Procore is saying it is a Sage issue but since we can't get any support with this I am trying to rule out everything I can. We did review our Event Log and are…
During the Sage Premium setup, it asked for a SageCRM user and I have always used the sa user with no issues. Can I set up a different user and what rights does that new user need to have to work properly? Are there written instructions to do this?