Browse By Tags

  • Power BI

    We currently have Sage 100 Contractor being hosted on Azure VM. I would like to know if it's possible to connect Power BI to our Sage database to create dashboard from Power BI.

  • Sage 300 - Database is locked

    Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS

  • Any issue with other app databases in same instance as Sage?

    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…

  • Object Reference & Table name for Customer Price Schedule --> Pricing Method --> Price Discount Amount

    Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…

  • Sage 100 Premium 2020 SQL Server Transactional Replication for Reporting

    Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…

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

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

  • How can I go about joining the SINVOICED table to the STOJOU table?

    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…

  • Connect Existing DB Server to Brand New App Server

    Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might). I have some ideas, but I'd like to know how others…

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

  • How To Replicate Same Folder, Same SQL Database from a Production Server to a Data Recovery Server Automatically

    Hi guys, I need help! My client wants me to achieve an automatic backup from her Production server to a Data recovery Server on a daily basis Please how can this be achieved? Hoping to get a positive response Thanks

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

  • Sy_ActivityLog not showing CompanyCode field.

    Hello, I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table. When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…

  • Where in the AOM can I find flag for "fiscal period" locked or unlocked?

    I have a challenge...can someone familiar with the Sage 300 database tables give me some advice? I would like to query the database to find out if a certain document date correponds with a fiscal period that is currently locked for Accounts Payable…

  • Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…

  • Sample ODBC/SQL queries for getting Sales Order information, Customer Information, and inventory information?

    Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…

  • I was wondering if anyone has information on calling SQL stored procedures from within X3 code?

    I have a stored procedure I would like to call to populate a work table as a preprocessor to an SQL client requester. Syntax would be helpful. Thanks SQL stored procedure call from X3

*Community Hub is the new name for Sage City