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
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, …
Azure SQL Elastic Pools is heavens-send for a lot of partners and customers who are looking for an affordable, yet scalable SQL Database service for their Sage X3 projects. Making sure you are compliant with Microsoft's rather complicated SQL licensing…
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…
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…
I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…
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…
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
Dear Fellows,
As you may all know that when you delete a folder in X3 it will not be deleted from database with all its references which will eventually increase your database size, and therefore i created an sql procedure that safely delete the folder…
Hello,
It feels like I'm overlooking something simple, because tying lot numbers to our delivery records should be fairly straightforward.
When I pull up a sample delivery record in Sage X3, I can select Stock lot and see which Lot number were included…
You can manage Employees at: Common Data > Manufacturing tables > Employees
But I can't find the corresponding table.
Does anybody know what's the table name?
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…
I am looking to see if anyone is running X3 on Oracle 19c. If so, were there any caveats to this? For example, did database compatibility settings come into play?
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
Please I cannot start my Simply Accounting Set up.
It keep telling me cannot connect to Connection Manager.
What should I do.
Will Need an URGENT ASSISTANCE
Hello
We share same infrastructure with another company.
They got IT, not my company.
Their IT refuse me to use crystal report and access database for security. So we do Microsoft Word for all Invoices, Orders, etc. Like t min per Word to do all…
Has anyone had experience with archiving the PO module? According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module. Clean out all those old records. I have done this in a test environment and can…