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 three…
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 thing…
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 Fre…
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…
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…
Relativamente à execução de querys, deverá utilizar a função da seguinte forma:
Bd.Executar(mSql)
Bonjour à tous
Je voudrais savoir si quelqu'un aurait réalisé un script SQL pour importer un inventaire dans Batigest Connect.
Par avance, merci pour vos réponse.
Jean Baptiste
Bonjour,
Je m'arrache les cheveux pour tenter de trouver des alternatives et adapter mes requêtes ACCESS (qui fonctionnait dans batigest i7) en requêtes TRANSACT-SQL (aucun souci sous SQL Manager) mais cette version de Batigest Connect…
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
Voici là encore une requête ACCESS qui fonctionnait parfaitement sous Batigest i7
SELECT Year(Interv.DateEff) AS [Année], Switch(Interv.CanalReception='A', 'Autre', Interv.CanalReception='M', 'Mail', Interv.CanalReception='P', 'Pages…
Les fonctions CHARINDEX() et PATINDEX() portant standard ne semblent pas fonctionner dans les requêtes SQL sous Batigest Connect. (J'utilisais la fonction InStr() sous Batigest i7 qui ne marche plus non plus).
Y'a t-il une solution ?
bonjour,
Je viens de souscrire à la Version Connect Premium avec le runtime SQL 2019.
Je suis en train de faire un test de migration sur une machine de test car j'ai des applications tierces à adapter avant une migration définitive.…
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…
Hi, Everyone How Can I check or clarify SQL server is runtime edition version.
Please help me.
Thank you so much
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 Year…
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…
