Sage X3 v12p34, SQL Server 2022 Standard edition.
Full error as follows: `Connection to server failed : X3 engine error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The SELECT permission was denied on the object 'APLLCK', database 'x3v12'…
Where can I find the time an order was created? I can only seem to find the day in the ORDDATE field in the OEORDH table. Does Sage store this somewhere in the database tables?
Thank you
I am currently running Sage Paperless on SQL 2014 ver 12.0.2269.0 (released 7/14/2015).
My internal vulnerability scans have flagged this version as unsupported and it likely contains several security vulnerabilities.
What is the process for updating…
Hello,
i've database file. i need to load data in my sage cre 300.
I've installed sage cre 300 in my local machine but not found database dump and database load application.
Could you guys help here how to connect with this database?
Thanks, …
Hello. We are looking to upgrade from Advanced to premium primarily because of the need for external reporting from "3rd Party" tools. These tools require SQL server access to be able to PULL data from Sage running SQL.
We have read where the SQL server…
A customer has a third party quoting and bidding software running with SQL Express. They want to move it into the same instance in standard SQL as Sage300 to allow more memory availability. Any issue with this or would a separate instance in standard…
Upgrading from 2019 to 2022 and for that purpose deploying new virtual server. Server is running Windows 2019 and SQL is running on a separate machine. I am able to convert data but when trying to run SAGE receiving error in OE and IC. PO seems to be…
Hi,
Console: CFG.2.54.0.5 (from v12p30 ISO disc)
I have noticed latest version and newer patch level of Sage X3 v12p30 now can set the Db login.
It was previously impossible to edit and must use sa.
Will there be any issue if I change…
Hello,
Could some one please advise where the description would be stored on the sql server please ? Which table would it be under as I am not able to find it. Thank you - Shashank
Hi,
I want to read and write data in sage100 database, so after some research I found out this course for reference.
But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not?
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…
I am trying to join one of the following tables to GACCOUNT. PORDERQ or ITMMASTER. There doesn't seem to be many ways to get from GACCOUNT to an ITMREF_0 or POHNUM.
I have tried a few different options but none seem to be working. Your help, as always…
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…
I am building out existing access report in sagex3. Where can I find GLcode and descriptions? I've looked at the accounting data model tab and am just not really sure what I am looking for.
Thank you in advance!
I am looking to get the sql column name for total requirements qty located in available stock. If anyone could point me in the right direction, it would be greatly appreciated.
Good Morning! I am currently working on swapping from Process Pro To Sagex3 and one of the columns in PP is Usage qty which is total qty used for the year. Is there a field in sagex3 for this? As always, your responses are greatly appreciated!
As seen above, I am looking for received/delivered qty from a Purchase Order. Is it the Received STK or PUR in the PORDERQ table? so far I have been using received stk, but am unsure if that is correct
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?
We are working with a company using Sage 300 on a Pervasive SQL database.
They are interested in exporting data such as GL, AR, and AP transactions and other table information, such as accounts, customers, and vendors.
I'd like to know if there are…
the following error message appeared unprovoked today:
firebird database error
cannot attach to password database
class: EIBNativeException
code: 335544653
i can't even open the database. the minute i double click the icon, the error appears…
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…