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, …
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 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.
As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…
Hi there,
I have made 3 different upgrades from Mongodb 3.4 to 4.2 and now when I restart Windows, the mongodb service doesn't autostart. I have to start it manually.
The update path was the following:
Mongodb 3.4 -> 3.6
Mongodb 3.6 -> 4.0 …
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…
October 25th, 2020
Hello Teams,
Need your help. :)
BPSUPPLIER-->CONTACT-->CONTACTCRM
Where to find the field KCNTFLG - which is the Default Contact Flag in the MSSQL x3 database tables.
Goal - I am looking for where the CNTFLG field is stored…
Hi All,
I am moving the SQL database from C: drive to D: drive for existing client (Installed and configured Console 2 yrs back) because the C: drive was fully occupied.
If I move the SQL database, do I need to change the path on the Safe X3 management…
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…
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
Hello,
I would like to draw links between tables (automatically).
But I didn't find any foreign key in INFORMATION_SCHEMA.TABLE_CONSTRAINTS.
I checked other tables without success.
Could you please help me?
Best regards,
Nicolas
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…
can any one help i had to update my sage accounts 50 because i moved my computer and all of a sudden the sage couldnt recognise the computer.
so i was advised to cahnge and upgrade to v25 of which once i had done that my main computer worked. what i…
Hi,
I am working with a client using Sage 300 version 9.5(?). When I open PCC I am unable to see the PRM tables. After some research I think that the reason the PRM tables (among others) do not show up is because the DDF files do not contain the schema…
I recall reading articles years ago about BV and its reliance on Pervasive 10 which reached its end of life a few years ago, and crystal reports which i think is no longer a thing?
I recall there being a limitation with BV that all database access would…