Browse By Tags

  • How to connect Sage CRE Accounting with existing database

    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, …
  • How do I join STOJOU to GACCCODE?

    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…
  • What is the column name for AvailableStock->TotalRequirements in sql?

    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.
  • Mongodb service doesn't autostart after upgrade

    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 …
  • BPSUPPLIER SCREEN (X3) - CONTACT default field KCNTFLG not in MSSQL database tables - CONTACT or CONTRACTCRM

    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…
  • Safe X3 Console modification of path

    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…
  • Latest V12 & SQL SERVER 2014 R1

    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
  • Foreign keys

    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
  • X3 Access database

    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…
  • Table Validation Error PAYMENTH Error No 76

    This error comes up anytime I try to validate any table. Please has anyone encountered this before?
  • Cannot acess table values

    I made a new table (ZITEMECO) and a new screen (ZITF0) to use inside OITF window but i'm having trouble to read the table, it appears that $LIENS action not working at all, what am i doing wrong. Here is the code of the SPEITF: # Gestão da máscara…
  • Does Sage HRMS 2017 support SQL HA (High Availability) databases?

    We will be upgrading to Sage HRMS 2017 and Sage Employee Self Service 2017 soon. As our company has two data centers I am interested to know if these products support a SQL HA cluster so that I could offer failover capabilities that we've not had previously…