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

    This error comes up anytime I try to validate any table. Please has anyone encountered this before?
  • SQL Data Report

    I am trying to pull data from three tables but running into a relation issues. Table1: Customer Table. Table 2: Invoice Table Table 3: Invoice Detail Table On table 1 the customer number column is "BPCNUM_0" On Table 2: The customer number column is …