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, …
  • Looking to build a report for Sales by GLCode by month

    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…
  • Deleting Sage X3 folder from database

    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…
  • 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…