x Want to participate? Join the group to interact

  • Closing fiscal year 2022 to start entries for Jan 2024

    Hello, We are trying to figure out how to close the 2022 fiscal year so we can start entering Jan 2024 entries. The current months listed in GL are Jan-Dec 2022 and Jan-Dec 2023.

  • GL base accounts setup error

    While setting up the base accounts during 'generating' an error was made including some accounts tied to entities that should not have been. Is there a way to remove these accounts from those entities?

  • Sage 300 CRE GL system has a SOC 1 Type II report in which service auditors test the internal controls over Sage reporting

    Can we create a SOC 1 Type II report in which service auditors test the internal controls over Sage reporting?

  • Creating Deposit for Bank Account Funding

    Organizational structure consists of two companies, Company #1 and Company #2. Last year we switched bank accounts from Bank #1 to Bank #2 for our Checking and Health Reimbursement Accounts. Company #1 did not have any remaining checks for the old bank…

  • Correcting the period on a posted invoice batch

    A batch of about 200 Invoices was posted to a previous year (period) and the checks were posted in the current period. How do we get the invoices corrected into the current period?

  • Cash Management Register's Posted & Reconciled, But General Ledger didn't catch transaction.

    I have Cash Management register (CM) matching the bank account. The General ledger (GL) didn't pick up this transaction. CM is reconciled. how would I add this to GL and keep everything balanced? last time this happened, I had to do a funky chicken…

  • Inventory Count Issues

    Hello, We were performing an inventory count however one of our employees made a stock transfer from one location (being counted) to another. When we look at the part number through the inquiry function, we see the appropraite quantity in each location…

  • GL transaction file in use error at login

    We have a frustrating situation where, if someone prints a GL report to screen and leaves it open, another user cannot login to the GL application. They receive an error message, "GL transaction file in use." If the user in the system closes that report…

  • Profit and Loss

    Is there a way or method I can run a Profit and Loss for a specific time period - for example, 7/1/2018 through 6/30/2019?

  • What does *!! at the end of a general ledger report mean?

    On some reports at the end I'm seeing *!! at the end and was wondering why or what it meant

  • When I try to run a Totals by Batch report in GL, it freezes up every time.

    FormerMember
    FormerMember
    My TB is out of balance by $.72. When I try to run a Totals by Bath report in GL, it freezes up every time before it even gets to the report screen. Has anyone had this issue, and how do we fix it?

  • How do I enter starting balances in a new company

    I don't understand how to enter starting balances in a new company. I want to enter the starting balance for a bank account. The knowledge base describes a procedure for entering a period zero entry using a clearing account, but it doesn't give enough…

  • How do i correct a vendor ending balance to match the invoices?

    I am attempting to roll over to the next month although the audit shows errors: Client Ending Balance does not match Invoices Vendor Ending Balance does not match invoices

  • Paycom payroll service integration with Sage 300 CRE (Timberline)

    I have a construction client that just informed me they decided to switch from Sage 300 CRE Payroll that they have been using for 20 years to Paycom. Does anyone have familiarity with Paycom as to integration with Sage 300 CRE Job Cost and General Ledger…

  • Posting Mechanic Labor to Equipment Expense in the GL

    Mechanic Labor Posting problem. Sometimes our mechanic doesn’t list on his timecard, what equipment he worked on during the week. The payroll department will use our Equipment Repair cost code when entering his time, but if an equipment number isn’t entered…

  • Is there any way to set a default expense (purchase) or default income (sales) ledger account for an individual cost code?

    Is there any way to set a default expense (purchase) or default income (sales) ledger account for an individual cost code. I would like it so that when I select a cost code on a line within a PO,CO, AR invoice, etc. the account is auto populated with…

  • Tax Discount

    If we pay our state sales tax early, there is a discount given by the state to the amount of sales tax we pay. How do I record that?

  • Office Connector

    Hi, I am looking for a quarterly financial statement. Does anyone have one that they are already using, or know how to modify the canned one? Thanks, Amanda

  • Payroll not posting

    I discovered today that last pay period did not post to GL even though all steps were completed per usual. Now when I try to post, it tells me there are no records to post, The records remain computed. Has anyone experienced this and how did you fix…

  • Accounting Date Correction

    My AP Summary report is out of balance due to me deleting some invoices with prior year accounting dates and changing the accounting dates to 'new accounting date' of today. Can this be fixed? Thank you!

  • When can we change GL Account numbering in v19 (Sage 100)?

    Since the change in Sage 100 Contractor with version 19 combining the period and year, and not closing company before starting new year, when can the GL account structure be changed?

  • DOH! I closed my fiscal year in General Ledger when I shouldn't have! - Sage 300 CRE

    We've all done this at some point in our careers. You were clicking along minding our own business. Closing the month, printing checks, running reports, then.... BOOM! You closed the fiscal year in General Ledger when you shouldn't have! The room begins…

  • I'm missing new General Ledger accounts on my Financial Statements!!!

    Adding new General Ledger accounts to your chart of accounts is common throughout the year. You or your controller may do this after an audit or acquisition of a new asset/liability, etc. Depending upon the type of account that is set up will determine…

  • General Ledger account numbering systems

    General Ledger accounts question: We are changing our corporate structure to add 2 subsidiaries and want to change our GL account numbering system to accommodate this. I understand that you can only change GL accounts at year end, prior to beginning a…

  • Prior Year Adjustments a.k.a PYA'S

    Prior year adjustments occur when you record an entry to an income statement account with an accounting date in your prior fiscal year. When this happens, your Current Ledger and Year-to-Date Ledger reports are out of balance until those prior year adjustments…

*Community Hub is the new name for Sage City