x Want to participate? Join the group to interact

  • The Bank Account balance on the BS is not the same as in CM

    The bank account balance on the Balance Sheet does not tie to either the bank balance in Cash Management. I have tried to go through and reconcile, but can't seem to find why they are different.

  • Equipment Cost Month Close

    Hello, is there a way to reopen a previous month? At month end i advanced two months instead of one.

  • SQL Replicator Stuck in Deleting Log Loop

    Current running SQL Replicator v 2.0.374.0 Have been battling this problem for months to little avail. Have tried: Regenerating tables in Replicator Deleting the databases from SQL (the ones that are created by Sage SQL Replicator) and reconfiguring…

  • SQL Query to return GL trial balances

    I'm trying to write a query to return the GL trial balance for each account. Does anyone have a recommendation on the best way to achieve this?

  • how do i print a list of standard cost codes

    I need to print a list of my standard cost codes

  • WIP Closed Jobs

    How can I change estimates to revenue and cost in order to zero out over/under billing amounts for closed jobs on the WIP Report?

  • Trying to use Crystal, but getting an error saying that I don't have access to part of the database. Can someone help with how to fix?

    We installed Crystal recently and we were very excited to get started. However, when I tried to connect to the database, this is the error I received: SAP Crystal Reports Logon failed. Details: HY000:[Sage][SQLEngine] (31832) This user does not…

  • payroll

    I am wondering if anyone has employees with higher shop rate than the basic rate on certified jobs. How do you get the basic rate to calculate since with the fringes added on, the rate is higher than shop rate. Otherwise, we are paying higher certified…

  • Remove unposted import into Job Cost module

    I have to import weekly from our payroll software to the Job Cost module. Before I posted, I realized there was an error. How do I remove the import so that I can pull in the new corrected one?

  • Interfacing with Sage's Pervasive SQL Instance

    We've been trying to access our on premises Sage 300 CRE server over SQL without luck. It throws Btrieve Error 35 "The Btrieve file directory is invalid" every time I try to connect with Dbeaver using the Pervasive JDBC drivers. I don't see anything that…

  • 24.1 - 64-bit ODBC just for Crystal? Outdated Java in PSQL updated finally? FIPS still not compatible? Syslog integration?

    Question 1: 24.1 - So I see ya'll finally added 64-bit ODBC in some form, the documentation says for Crystal Reports. Is this a full implementation so if I update ours from 23.2 to latest 24.1 can I finally switch our users out to the 64-bit version…

  • P&L Report

    I am brand new to Sage 300, and I am trying to figure out how to run an over all monthly P&L , and then a breakdown monthly P&L by department. Can anyone tell me the steps how to do this? I greatly appreciate any help

  • Check Stubs

    Does Sage have the capability to store/email check stubs?

  • When do summary fields update with the latest transactions?

    I am trying to identify when the summary columns (such as JTD_Labor_Dollars_Paid or JDT_Material_Dollars_paid') get updated? I can see the Labor or Materials transactions come into the JCT_CURRENT__TRANSACTION file, and I can add them up to compute a…

  • Marking jobs closed

    Can you use Access with an ODBC connection to mark multiple jobs closed rather than going into each job. We do not mark them closed until we archive, and I need to go back to 2016!

  • JC Cost Code SectionsHi

    Hi - does anyone know which file stores the "JC Cost Code Sections" form details (i.e. sections 1-4, descriptions, delimiters, and size)? I tried looking at TS_CUST_DESC but could not find it there.

  • System Administrator program

    We are working to connect our SAGE database through Microsoft SQL server. The System Administrator program is on our server, along with our database. The SQL Express program is on a workstation. It appears we need to put the System Administrator program…

  • ODBC connector to read and write

    Hello all, How to connect ODBC connector to read and write to multiple different 300 CRE files ?

  • API for Sage 300 CRE?

    It looks like this question has been asked before, but I am not finding a current answer to my question. Is there an API to connect to Sage 300 CRE Job Cost files?

  • COI - certificate of insurance

    Can I download or scan the 100+ pages of insurance certificates for our vendors, instead of manually inputting all the policy numbers?

  • Job Checklist Items not updating in database

    I am attempting to create a Power BI report with some of the data from Sage. It needs to pull data about the job checklist items. However, for some reason the Checklist_12 item is not updating in the replicator database (The one we use to push Sage data…

  • Job Numbers & Cost Codes

    We use AL Mobile for timesheet entry. When jobs and cost codes are entered in Job Cost, they are imported into AL Mobile at regular times during the day. If they are set to unstarted, they aren't imported; I manually change the status to "in progress…

  • Why is Timberscan and Sage not matching in the units column after a Commitment CO?

    Why is Timberscan and Sage not matching in the units column after a Commitment CO?

  • Excel to Update Vendor Info

    Can you update vendor information in Excel and have it import back to Sage? If yes, how?

  • AP - This program is about to close. See the journal in the following location

    We started experiencing this issue 2 days ago and it seems that we are unable to get past the error. When trying to make a payment in Sage AP, my user gets the following error when trying to submit: This program is about to close. See the journal in the…

*Community Hub is the new name for Sage City